slitaz-dev-tools annotate tazwikiss/rootfs/var/www/wiki/pages/HelpCalc.txt @ rev 200
tazwikiss: add calc plugin
author | Pascal Bellard <pascal.bellard@slitaz.org> |
---|---|
date | Sun Nov 17 13:32:25 2013 +0000 (2013-11-17) |
parents | |
children | d80619cb46db |
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@200 | 17 {{Apples;12;=parseInt((100*B1)/B3)+'%'; |
pascal@200 | 18 Pears;7;=parseInt((100*B2)/B3)+"%"; |
pascal@200 | 19 Total :;=B1+B2;;}} |
pascal@200 | 20 Apples;12;=parseInt((100*B1)/B3)+'%'; |
pascal@200 | 21 Pears;7;=parseInt((100*B2)/B3)+"%"; |
pascal@200 | 22 Total :;=B1+B2;; |
pascal@200 | 23 {{A number;its square root; |
pascal@200 | 24 2;=(A2<0)?alert('A2 < 0 !'):Math.sqrt(A2);}} |
pascal@200 | 25 A number;its square root; |
pascal@200 | 26 2;=(A2<0)?alert('A2 < 0 !'):Math.sqrt(A2); |