SliTaz Repositories

     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/tazwikiss/rootfs/var/www/wiki/pages/HelpCalc.txt	Sun Nov 17 13:32:25 2013 +0000
     1.3 @@ -0,0 +1,26 @@
     1.4 +!Help on the CSV spreadsheet
     1.5 +!!Creation
     1.6 +Spreadsheets are created from inlined CSV data with at least 2 rows and 2 lines :
     1.7 +* The CSV lines must end with a ''';'''
     1.8 +* The CSV lines have 2 or more ''';'''
     1.9 +* Each CSV line have the same count of ''';'''
    1.10 +* Each cell is addressed by a letter and a number, and may hold
    1.11 +** Some text
    1.12 +** A number
    1.13 +** A ''javascript'' formula starting with '''='''
    1.14 +!!Usage
    1.15 +* Move the mouse over the cells to see the contents
    1.16 +* click and modify the white cells
    1.17 +** click anywhere outside the cell to recompute everything
    1.18 +* click to a gray cell to see the CSV update
    1.19 +!!Examples
    1.20 +{{Apples;12;=parseInt((100*B1)/B3)+'%'; 
    1.21 +Pears;7;=parseInt((100*B2)/B3)+"%"; 
    1.22 +Total :;=B1+B2;;}}
    1.23 +Apples;12;=parseInt((100*B1)/B3)+'%';
    1.24 +Pears;7;=parseInt((100*B2)/B3)+"%";
    1.25 +Total :;=B1+B2;;
    1.26 +{{A number;its square root; 
    1.27 +2;=(A2<0)?alert('A2 < 0 !'):Math.sqrt(A2);}}
    1.28 +A number;its square root;
    1.29 +2;=(A2<0)?alert('A2 < 0 !'):Math.sqrt(A2);