Wiki source code of Calc

Version 4.1 by Guillaume Lerouge on 2009/10/22 09:22
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:3
27 cell:F2:vtc:n$:8:$8
28 cell:G2:vtf:n$:24: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$:50: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:20
49 colpane:0:1:14
50 ecell:H6
51 sort::-1:up::::
52 --SocialCalcSpreadsheetControlSave
53 Content-type: text/plain; charset=UTF-8
54
55 set D1 text t Item
56 set E1 text t Quantity
57 set F1 text t Price
58 set G1 text t Total
59 set D2 text t Bread
60 set D3 text t Butter
61 set D4 text t Milk
62 set E2 value n 3
63 set E3 value n 4
64 set E4 value n 2
65 set F2 constant n$ 8 $8
66 set F3 constant n$ 4 $4
67 set F4 constant n$ 5 $5
68 set G2 formula E3*F3
69 filldown G2:G4 all
70 set G2 formula E2*F2
71 filldown G2 all
72 filldown G2:G4 all
73 set G5 formula sum(G2:G4)
74 --SocialCalcSpreadsheetControlSave--
75
76 {{/spreadsheet}}