slitaz-dev-tools annotate tazwikiss/rootfs/var/www/wiki/pages/HelpCalc.txt @ rev 205
tazdev: set mirror path in chroot
author | Pascal Bellard <pascal.bellard@slitaz.org> |
---|---|
date | Sun Dec 22 19:21:18 2013 +0000 (2013-12-22) |
parents | e3b40fe05c1d |
children | 674bad1f758b |
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@204 | 19 Total :;=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@204 | 22 Total :;=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 !; |