Changes for page Calc

Last modified by Ludovic Dubost on 2009/10/23 00:07
From version 2.1
edited by Ludovic Dubost
on 2009/10/22 00:16
Change comment: There is no comment for this version
To version 3.1
edited by Guillaume Lerouge
on 2009/10/22 09:22
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -xwiki:XWiki.ludovic
1 +xwiki:XWiki.GuillaumeLerouge
Content
... ... @@ -16,26 +16,61 @@
16 16  version:1.5
17 17  cell:A1:t:Country
18 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
19 19  cell:A2:t:France
20 20  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
21 21  cell:A3:t:UK
22 22  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
23 23  cell:A4:t:US
24 24  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
25 25  cell:B5:vtf:n:25830:sum(B2\cB4)
26 -sheet:c:2:r:5
42 +cell:G5:vtf:n$:50:sum(G2\cG4)
43 +sheet:c:7:r:5
27 27  --SocialCalcSpreadsheetControlSave
28 28  Content-type: text/plain; charset=UTF-8
29 29  
30 30  version:1.0
31 -rowpane:0:1:33
32 -colpane:0:1:20
33 -ecell:B5
48 +rowpane:0:1:20
49 +colpane:0:1:14
50 +ecell:H6
34 34  sort::-1:up::::
35 35  --SocialCalcSpreadsheetControlSave
36 36  Content-type: text/plain; charset=UTF-8
37 37  
38 -set B4 value n 22304
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)
39 39  --SocialCalcSpreadsheetControlSave--
40 40  
41 41  {{/spreadsheet}}