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&lt;0)?alert('A2 &lt; 0 !'):Math.sqrt(A2);}}
pascal@200 25 A number;its square root;
pascal@200 26 2;=(A2&lt;0)?alert('A2 &lt; 0 !'):Math.sqrt(A2);