slitaz-dev-tools annotate tazwikiss/rootfs/var/www/wiki/pages/HelpCalc.txt @ rev 281
hg: coded with love!
| author | Christophe Lincoln <pankso@slitaz.org> |
|---|---|
| date | Wed Mar 01 22:17:53 2017 +0100 (2017-03-01) |
| parents | 674bad1f758b |
| children | f452ee112773 |
| rev | line source |
|---|---|
| pascal@200 | 1 !Help on the CSV spreadsheet |
| pascal@200 | 2 !!Creation |
| pascal@200 | 3 Spreadsheets are created from inlined CSV data with at least 2 rows and 2 lines : |
| pascal@200 | 4 * The CSV lines must end with a ''';''' |
| pascal@200 | 5 * The CSV lines have 2 or more ''';''' |
| pascal@200 | 6 * Each CSV line have the same count of ''';''' |
| pascal@200 | 7 * Each cell is addressed by a letter and a number, and may hold |
| pascal@200 | 8 ** Some text |
| pascal@200 | 9 ** A number |
| pascal@200 | 10 ** A ''javascript'' formula starting with '''=''' |
| pascal@200 | 11 !!Usage |
| pascal@200 | 12 * Move the mouse over the cells to see the contents |
| pascal@200 | 13 * click and modify the white cells |
| pascal@200 | 14 ** click anywhere outside the cell to recompute everything |
| pascal@200 | 15 * click to a gray cell to see the CSV update |
| pascal@200 | 16 !!Examples |
| pascal@204 | 17 {{Apples;12;=round((100*B1)/B3)+'%'; |
| pascal@204 | 18 Pears;7;=round((100*B2)/B3)+"%"; |
| pascal@237 | 19 Total :;=sum("B1","B2");=parseInt(C1)+parseInt(C2)+'%';}} |
| pascal@204 | 20 Apples;12;=round((100*B1)/B3)+'%'; |
| pascal@204 | 21 Pears;7;=round((100*B2)/B3)+"%"; |
| pascal@237 | 22 Total :;=sum("B1","B2");=parseInt(C1)+parseInt(C2)+'%'; |
| pascal@200 | 23 {{A number;its square root; |
| pascal@203 | 24 2;=(A2<0)?alert('A2 < 0 !'):sqrt(A2);}} |
| pascal@200 | 25 A number;its square root; |
| pascal@203 | 26 2;=(A2<0)?alert('A2 < 0 !'):sqrt(A2); |
| pascal@205 | 27 {{SliTaz 1.0 was released;Saturday 22 march 2008; |
| pascal@205 | 28 =round(((new Date()).getTime() - Date.parse(B1))/1000/3600/24);days ago !;}} |
| pascal@205 | 29 SliTaz 1.0 was released;Saturday 22 march 2008; |
| pascal@205 | 30 =round(((new Date()).getTime() - Date.parse(B1))/1000/3600/24);days ago !; |
| pascal@252 | 31 !!Some true spreadsheets |
| pascal@252 | 32 * [sc|http://127.0.0.1:82/user/pkgs.cgi?info=sc] for console |
| pascal@252 | 33 * [sc-im|http://127.0.0.1:82/user/pkgs.cgi?info=sc-im] for console with colors |
| pascal@252 | 34 * [gnumeric|http://127.0.0.1:82/user/pkgs.cgi?info=gnumeric] |