Features
Spreadsheets help Features
| A | B | C | D | E | F | G | |
| 1 | Function | Arguments | Example | Result | Additional Information | Sample # | Sample Text |
| 2 | ABS | numbers_as_array | "=ABS(F4)" | 62 | 23 | Hello World | |
| 3 | AVERAGE | values_as_array | "=AVERAGE(F4:F14)" | 46.92307692307692 | Synonym:?AVG | 45 | True |
| 4 | CEILING | numbers_as_array | "=CEILING(F4:F14)" | 6,21E+016 | 62 | False | |
| 5 | COUNT | html_as_string | "=COUNT(F2:F14)" | 13 | 108 | To High | |
| 6 | DAYSFROM | url_as_string | "=DAYSFROM(2009,4,15)" | -11 | 200 | To Low | |
| 7 | DOLLAR | numbers_as_array | "=DOLLAR(F13)" | $55.00 | 36 | Perfect | |
| 8 | FALSE | "=IF(F4 < 100, TRUE(), FALSE())" | TRUE | 17 | number | ||
| 9 | FIXED | number, decimals, noCommas? | "=FIXED(F4+F14)" | 41.00 | Two decimal places | 99 | numbers_as_array |
| 10 | FLOOR | numbers_as_array | "=FLOOR(F4-F5)" | -46 | Synonym: INT | 100 | values_as_array |
| 11 | HYPERLINK | "=HYPERLINK("http://www.jquery.com", "jQuery's website")" | jQuery's website | -100 | html_as_string | ||
| 12 | IF | IF(logical_test, value_if_true, value_if_false) | "=IF(F12 < 100, TRUE(), FALSE())" | TRUE | Can have nested IF functions. | -14 | url_as_string |
| 13 | IMG | "=IMG("http://ui.jquery.com/images/logo.gif")" | The url can be sensitive to numbers. Also, on initial
load, because the image doesn't really have a size, the outerheight can be distorted. An easy way to offset this is to have some text in front of it that's taller than the image :). |
55 | values | ||
| 14 | MAX | values_as_array | "=MAX(F3:F13)" | 200 | -21 | ||
| 15 | MIN | values_as_array | "=MIN(F3:F13)" | -100 | |||
| 16 | N | numbers_as_array | "=N(F3)" | 45 | |||
| 17 | PI | "=PI()" | 3.141592653589793 | If you use "=PI" it will return the actual function as text, which is incorrect. Use "=PI()". | |||
| 18 | TODAY | "=TODAY()" | Wed Sep 15 2010 14:32:35 GMT-0400 (Eastern Daylight Time) | ||||
| 19 | TRUE | "=TRUE() || FALSE()" | TRUE | ||||
| 20 | SUM | values_as_array | "=SUM(F2:F13)" | 631 | |||
| 21 | ROUND | numbers_as_array | "=ROUND(1.6)" | 2 | |||
| 22 | RAND | "=RAND()" | 0.2405688383833392 | Synonym: RND |
| A | B | C | D | |
| 1 | Cell Navigation | Result | Dependancy | Synonym |
| 2 | Left Arrow | Active cell moves left if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| 3 | Right Arrow | Active cell moves right if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| 4 | Up Arrow | Active cell moves up if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| 5 | Down Arrow | Active cell moves down if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| 6 | Escape | Active cell is removed from focus. | jQuery.sheet.evt.cellEditAbandon() | jS.evt.cellEditAbandon() |
| 7 | Enter | Starts in-place edit / Active cell moves
down if possible. |
jQuery.sheet.evt.formulaKeyDown() | jS.evt.formulaKeyDown() |
| 8 | Ctrl + Enter | Ends in-place edit / Active cell moves
down if possible. |
jQuery.sheet.evt.formulaKeyDown() | jS.evt.formulaKeyDown() |
| 9 | Tab | Active cell moves right if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| A | B | C | D | E | F | |
| 1 | Chart Type | Example | Chart | Data | Month | Year |
| 2 | Vertical Bar | "=BARCHART(D2:D13) | 4 | Jan | 2001 | |
| 3 | Horizontal Bar | "=HBARCHART(D2:D13) | 6 | Feb | 2002 | |
| 4 | Pie | "=LINECHART(D2:D8, F2:F6)" | 7.2 | Mar | 2003 | |
| 5 | Line | "=PIECHART(D2:D8, E2:E8)" | 7.5 | Apr | 2004 | |
| 6 | 8.2 | May | 2005 | |||
| 7 | 9.1 | Jun | 2006 | |||
| 8 | 14.1 | Jul | 2007 | |||
| 9 | 16 | Aug | 2008 | |||
| 10 | 17.9 | Sep | 2009 | |||
| 11 | 22 | Oct | 2010 | |||
| 12 | 30 | Nov | 2011 | |||
| 13 | 32 | Dec | 2012 | |||
| 14 | ||||||
| 15 |
| A | B | C | D | E | F | G | H | |
| 1 | Inputs are for capturing fixed data, such as a drop down list (INPUT.SELECT), or a checkbox (INPUT.CHECKBOX) | |||||||
| 2 | Input Type | Example | Data Number | Data String | ||||
| 3 | Select List | "=INPUT.SELECT(D3:D10)" | 34 | Lorem | ||||
| 4 | Radio List | "=INPUT.RADIO(E3:E10)" | Lorem
Proin Aliquam Quisque Aliquam Vivamus Etiam Donec |
-20 | Proin | |||
| 5 | Checkbox | "=INPUT.CHECKBOX(E3)" | Lorem | 123 | Aliquam | |||
| 6 | Get Select List Value | "=INPUT.SELECTVAL(C3)" | 4 | 123 | Quisque | |||
| 7 | Get Radio List Value | "=INPUT.RADIOVAL(C4)" | Donec | 4 | Aliquam | |||
| 8 | Get Checkbox Value | "=INPUT.CHECKBOXVAL(C5)" | Lorem | 534456 | Vivamus | |||
| 9 | Detect if Checkbox is Checked | "=INPUT.ISCHECKED(C5)" | FALSE | 3 | Etiam | |||
| 10 | 1 | Donec |
| A | B | C | D | E | F | G | |
| 1 | Function | Arguments | Example | Results | Additional Information | Sample # | Sample Text |
| 2 | FACTORIAL | number | '=FACTORIAL(5)' | 120 | |||
| 3 | COMBINATION | number, number | '=COMBINATION(7,5) | 21 | |||
| 4 | PERMUTATION | number, number | '=PERMUTATION(7,5) | 2520 | |||
| 5 | GAMMA | number | |||||
| 6 | PRECISION | num, precision | |||||
| 7 | MINIMUM | array | |||||
| 8 | MODE | array | |||||
| 9 | MAXIMUM | array | |||||
| 10 | MEAN | array | |||||
| 11 | SUM | array | |||||
| 12 | MEDIAN | array | |||||
| 13 | QUARTILES | array | |||||
| 14 | VARIANCE | array | |||||
| 15 | MEANDEV | array | |||||
| 16 | STDEV | array | |||||
| 17 | COVARIANCE | array, array | |||||
| 18 | CORR_COEFF | array, array | |||||
| 19 | UNIFORMCDF | number, number, number | |||||
| 20 | BINOMIAL | number, number, number | |||||
| 21 | BIONOMIALCDF | num, num, num | |||||
| 22 | NEGBIN | num, num, num | |||||
| 23 | NEGBINCDF | N, m, n, x | |||||
| 24 | HYPGEOM | N, m, n, x | |||||
| 25 | HYPGEOMCDF | N, m, n, x | |||||
| 26 | EXPONENTIALCDF | l, x | |||||
| 27 | POISSON | l, x | |||||
| 28 | POISSONCDF | l, x | |||||
| 29 | NORMCDF | u, s, t | |||||
| 30 | LINEAR_REQ_EQ | array, array | |||||
| 31 | EXP_REG_EQ | array, array | |||||
| 32 | SECANTMETHOD | func, min, max, error, maxiter | |||||
| 33 | FIVEPT | func, x, h | |||||
| 34 | FCRIT | f, a b | |||||
| 35 | ASR | f, a b, precision |