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