Wiki source code of Calc
Last modified by Ludovic Dubost on 2009/10/23 00:07
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: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"> </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"> </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"> </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"> </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"> </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"> </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"> </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"> </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"> </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}} |