Features
Spreadsheets help Features
| Function | Arguments | Example | Result | Additional Information | Sample # | Sample Text |
| ABS | numbers_as_array | "=ABS(F4)" | 62 | 23 | Hello World | |
| AVERAGE | values_as_array | "=AVERAGE(F4:F14)" | 46.92307692307692 | Synonym:?AVG | 45 | True |
| CEILING | numbers_as_array | "=CEILING(F4:F14)" | 6,21E+016 | 62 | False | |
| COUNT | html_as_string | "=COUNT(F2:F14)" | 13 | 108 | To High | |
| DAYSFROM | ur |
"=DAYSFROM(2009,4,15)" | -11 | 200 | To Low | |
| DOLLAR | numbers_as_array | "=DOLLAR(F13)" | $55.00 | 36 | Perfect | |
| FALSE | "=IF(F4 < 100, TRUE(), FALSE())" | TRUE | 17 | number | ||
| FIXED | number, decimals, noCommas? | "=FIXED(F4+F14)" | 41.00 | Two decimal places | 99 | numbers_as_array |
| FLOOR | numbers_as_array | "=FLOOR(F4-F5)" | -46 | Synonym: INT | 100 | values_as_array |
| HYPERLINK | "=HYPERLINK("http://www.jquery.com", "jQuery's website")" | jQuery's website | -100 | html_as_string | ||
| IF | IF(logical_test, value_if_true, value_if_false) | "=IF(F12 < 100, TRUE(), FALSE())" | TRUE | Can have nested IF functions. | -14 | ur |
| 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 | ||
| MAX | values_as_array | "=MAX(F3:F13)" | 200 | -21 | ||
| MIN | values_as_array | "=MIN(F3:F13)" | -100 | |||
| N | numbers_as_array | "=N(F3)" | 45 | |||
| PI | "=PI()" | 3.141592653589793 | If you use "=PI" it will return the actual function as text, which is incorrect. Use "=PI()". | |||
| TODAY | "=TODAY()" | Wed Sep 15 2010 14:32:35 GMT-0400 (Eastern Daylight Time) | ||||
| TRUE | "=TRUE() || FALSE()" | TRUE | ||||
| SUM | values_as_array | "=SUM(F2:F13)" | 631 | |||
| ROUND | numbers_as_array | "=ROUND(1.6)" | 2 | |||
| RAND | "=RAND()" | 0.2405688383833392 | Synonym: RND |
| Cell Navigation | Result | Dependancy | Synonym |
| Left Arrow | Active cell moves left if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| Right Arrow | Active cell moves right if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| Up Arrow | Active cell moves up if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| Down Arrow | Active cell moves down if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| Escape | Active cell is removed from focus. | jQuery.sheet.evt.cellEditAbandon() | jS.evt.cellEditAbandon() |
| Enter | Starts in-place edit / Active cell moves down if possible. | jQuery.sheet.evt.formulaKeyDown() | jS.evt.formulaKeyDown() |
| Ctrl + Enter | Ends in-place edit / Active cell moves down if possible. | jQuery.sheet.evt.formulaKeyDown() | jS.evt.formulaKeyDown() |
| Tab | Active cell moves right if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| Chart Type | Example | Chart | Data | Month | Year |
| Vertical Bar | "=BARCHART(D2:D13) | <div class="jSheetChart"><svg height="172" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M80,139L58,139L58,127L80,127Z" stroke="none" fill="#1751a7"></path><path d="M108,139L86,139L86,1 | 4 | Jan | 2001 |
| Horizontal Bar | "=HBARCHART(D2:D13) | <div class="jSheetChart"><svg height="148" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M53,27L53,20L95,20L95,27Z" stroke="none" fill="#1751a7"></path><path d="M53,36L53,29L116,29L116, | 6 | Feb | 2002 |
| Pie | "=LINECHART(D2:D8, F2:F6)" | <div class="jSheetChart"><svg height="220" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><text fill="#000000" stroke="none" font="12px Arial, sans-serif" style="text-anchor: middle; font: 12px A | 7.2 | Mar | 2003 |
| Line | "=PIECHART(D2:D8, E2:E8)" | <div class="jSheetChart"><svg height="144" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path stroke-linejoin="round" stroke-width="1" style="stroke-width: 1; stroke-linejoin: round;" d="M210.5 | 7.5 | Apr | 2004 |
| 8.2 | May | 2005 | |||
| 9.1 | Jun | 2006 | |||
| 14.1 | Jul | 2007 | |||
| 16 | Aug | 2008 | |||
| 17.9 | Sep | 2009 | |||
| 22 | Oct | 2010 | |||
| 30 | Nov | 2011 | |||
| 32 | Dec | 2012 | |||
| Inputs are for capturing fixed data, such as a drop down list (INPUT.SELECT), or a checkbox (INPUT.CHECKBOX) | |||||||
| Input Type | Example | Data Number | Data String | ||||
| Select List | "=INPUT.SELECT(D3:D10)" | 34 | Lorem | ||||
| Radio List | "=INPUT.RADIO(E3:E10)" | Lorem Proin Aliquam Quisque Aliquam Vivamus Etiam Donec | -20 | Proin | |||
| Checkbox | "=INPUT.CHECKBOX(E3)" | Lorem | 123 | Aliquam | |||
| Get Select List Value | "=INPUT.SELECTVAL(C3)" | 4 | 123 | Quisque | |||
| Get Radio List Value | "=INPUT.RADIOVAL(C4)" | Donec | 4 | Aliquam | |||
| Get Checkbox Value | "=INPUT.CHECKBOXVAL(C5)" | Lorem | 534456 | Vivamus | |||
| Detect if Checkbox is Checked | "=INPUT.ISCHECKED(C5)" | FALSE | 3 | Etiam | |||
| 1 | Donec |
| Function | Arguments | Example | Results | Additional Information | Sample # | Sample Text |
| FACTORIAL | number | '=FACTORIAL(5)' | 120 | |||
| COMBINATION | number, number | '=COMBINATION(7,5) | 21 | |||
| PERMUTATION | number, number | '=PERMUTATION(7,5) | 2520 | |||
| GAMMA | number | |||||
| PRECISION | num, precision | |||||
| MINIMUM | array | |||||
| MODE | array | |||||
| MAXIMUM | array | |||||
| MEAN | array | |||||
| SUM | array | |||||
| MEDIAN | array | |||||
| QUARTILES | array | |||||
| VARIANCE | array | |||||
| MEANDEV | array | |||||
| STDEV | array | |||||
| COVARIANCE | array, array | |||||
| CORR_COEFF | array, array | |||||
| UNIFORMCDF | number, number, number | |||||
| BINOMIAL | number, number, number | |||||
| BIONOMIALCDF | num, num, num | |||||
| NEGBIN | num, num, num | |||||
| NEGBINCDF | N, m, n, x | |||||
| HYPGEOM | N, m, n, x | |||||
| HYPGEOMCDF | N, m, n, x | |||||
| EXPONENTIALCDF | l, x | |||||
| POISSON | l, x | |||||
| POISSONCDF | l, x | |||||
| NORMCDF | u, s, t | |||||
| LINEAR_REQ_EQ | array, array | |||||
| EXP_REG_EQ | array, array | |||||
| SECANTMETHOD | func, min, max, error, maxiter | |||||
| FIVEPT | func, x, h | |||||
| FCRIT | f, a b | |||||
| ASR | f, a b, precision |
