Wiki source code of Calc

Version 7.1 by Ludovic Dubost on 2009/10/22 16:39
Show last authors
1 {{spreadsheet}}
2 socialcalc:version:1.0
3 MIME-Version: 1.0
4 Content-Type: multipart/mixed; boundary=SocialCalcSpreadsheetControlSave
5 --SocialCalcSpreadsheetControlSave
6 Content-type: text/plain; charset=UTF-8
7
8 # SocialCalc Spreadsheet Control Save
9 version:1.0
10 part:sheet
11 part:edit
12 part:audit
13 --SocialCalcSpreadsheetControlSave
14 Content-type: text/plain; charset=UTF-8
15
16 version:1.5
17 cell:A1:t:Country
18 cell:B1:t:Sales
19 cell:D1:t:Item
20 cell:E1:t:Quantity
21 cell:F1:t:Price
22 cell:G1:t:Total
23 cell:A2:t:France
24 cell:B2:v:2323
25 cell:D2:t:Bread
26 cell:E2:v:4
27 cell:F2:vtc:n$:8:$8
28 cell:G2:vtf:n$:32:E2*F2
29 cell:A3:t:UK
30 cell:B3:v:1203
31 cell:D3:t:Butter
32 cell:E3:v:4
33 cell:F3:vtc:n$:4:$4
34 cell:G3:vtf:n$:16:E3*F3
35 cell:A4:t:US
36 cell:B4:v:22304
37 cell:D4:t:Milk
38 cell:E4:v:2
39 cell:F4:vtc:n$:5:$5
40 cell:G4:vtf:n$:10:E4*F4
41 cell:B5:vtf:n:25830:sum(B2\cB4)
42 cell:G5:vtf:n$:58:sum(G2\cG4)
43 sheet:c:7:r:5
44 --SocialCalcSpreadsheetControlSave
45 Content-type: text/plain; charset=UTF-8
46
47 version:1.0
48 rowpane:0:1:37
49 colpane:0:1:20
50 ecell:E3
51 sort::-1:up::::
52 --SocialCalcSpreadsheetControlSave
53 Content-type: text/plain; charset=UTF-8
54
55 set E2 value n 4
56 --SocialCalcSpreadsheetControlSave
57 Content-type: text/xwiki/2.0; charset=UTF-8
58
59 |Country|Sales| |Item|Quantity|Price|Total|
60 |France|2323| |Bread|4|8|32|
61 |UK|1203| |Butter|4|4|16|
62 |US|22304| |Milk|2|5|10|
63 | |25830| | | | |58|
64 --SocialCalcSpreadsheetControlSave--
65
66 {{/spreadsheet}}