Wiki source code of Calc

Last modified by Ludovic Dubost on 2009/10/23 00:07

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:4
27 cell:F2:vtc:n$:8:$8
28 cell:G2:vtf:n$:32: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$:58: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:51
49 colpane:0:1:21
50 ecell:E3
51 sort::-1:up::::
52 --SocialCalcSpreadsheetControlSave
53 Content-type: text/plain; charset=UTF-8
54
55 --SocialCalcSpreadsheetControlSave
56 Content-type: text/html; charset=UTF-8
57
58 <table style="border-collapse: collapse; width: 560px;" cellpadding="0" cellspacing="0"><colgroup><col width="80"><col width="80"><col width="80"><col width="80"><col width="80"><col width="80"><col width="80"></colgroup><tbody><tr><td width="80" height="1"></td><td width="80" height="1"></td><td width="80" height="1"></td><td width="80" height="1"></td><td width="80" height="1"></td><td width="80" height="1"></td><td width="80" height="1"></td></tr><tr><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_A1">Country</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_B1">Sales</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_C1">&nbsp;</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_D1">Item</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_E1">Quantity</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_F1">Price</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_G1">Total</td></tr><tr><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_A2">France</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_B2">2323</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_C2">&nbsp;</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_D2">Bread</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_E2">4</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_F2">$8.00</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_G2">$32.00</td></tr><tr><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_A3">UK</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_B3">1203</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_C3">&nbsp;</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_D3">Butter</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_E3">4</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_F3">$4.00</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_G3">$16.00</td></tr><tr><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_A4">US</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_B4">22304</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_C4">&nbsp;</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif;" id="cell_D4">Milk</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_E4">2</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_F4">$5.00</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_G4">$10.00</td></tr><tr><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_A5">&nbsp;</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_B5">25830</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_C5">&nbsp;</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_D5">&nbsp;</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_E5">&nbsp;</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_F5">&nbsp;</td><td style="padding: 2px 2px 1px; vertical-align: top; font-size: small; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: right;" id="cell_G5">$58.00</td></tr></tbody></table>--SocialCalcSpreadsheetControlSave--
59
60 {{/spreadsheet}}