Changes for page Calc

Last modified by Ludovic Dubost on 2009/10/23 00:07
From version 1.1
edited by Ludovic Dubost
on 2009/10/22 00:15
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,39 +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 -cell:B4:v:30303
25 -cell:B5:vtf:n:33829:sum(B2\cB4)
26 -sheet:c:2:r:5
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
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:B6
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 A1 text t Country
39 -set B1 text t Sales
40 -set A2 text t France
41 -set A3 text t UKS
42 -set A3 text t UK
43 -set A4 text t US
44 -set B2 value n 2323
45 -set B3 value n 232312
46 -set B4 value n 23232
47 -set B3 value n 30303
48 -set B4 value n 30303
49 -set B5 value n 3030
50 -set B3 value n 1203
51 -set B5 formula sum(B2:B4)
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)
52 52  --SocialCalcSpreadsheetControlSave--
53 53  
54 54  {{/spreadsheet}}