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
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
on 2009/10/22 09:22
Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -xwiki:XWiki.lu dovic1 +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: 3332 -colpane:0:1: 2033 -ecell: B648 +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}}