Wiki source code of Calc
Version 3.1 by Guillaume Lerouge on 2009/10/22 09:22
Show last authors
author | version | line-number | content |
---|---|---|---|
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}} |