Wiki source code of Calc
Last modified by Ludovic Dubost on 2009/10/23 00:07
Hide last authors
author | version | line-number | content |
---|---|---|---|
1.1 | 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 | ||
3.1 | 19 | cell:D1:t:Item | |
20 | cell:E1:t:Quantity | ||
21 | cell:F1:t:Price | ||
22 | cell:G1:t:Total | ||
1.1 | 23 | cell:A2:t:France | |
24 | cell:B2:v:2323 | ||
3.1 | 25 | cell:D2:t:Bread | |
7.1 | 26 | cell:E2:v:4 | |
3.1 | 27 | cell:F2:vtc:n$:8:$8 | |
7.1 | 28 | cell:G2:vtf:n$:32:E2*F2 | |
1.1 | 29 | cell:A3:t:UK | |
30 | cell:B3:v:1203 | ||
3.1 | 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 | ||
1.1 | 35 | cell:A4:t:US | |
2.1 | 36 | cell:B4:v:22304 | |
3.1 | 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 | ||
2.1 | 41 | cell:B5:vtf:n:25830:sum(B2\cB4) | |
7.1 | 42 | cell:G5:vtf:n$:58:sum(G2\cG4) | |
3.1 | 43 | sheet:c:7:r:5 | |
1.1 | 44 | --SocialCalcSpreadsheetControlSave | |
45 | Content-type: text/plain; charset=UTF-8 | ||
46 | |||
47 | version:1.0 | ||
8.1 | 48 | rowpane:0:1:51 | |
49 | colpane:0:1:21 | ||
7.1 | 50 | ecell:E3 | |
1.1 | 51 | sort::-1:up:::: | |
52 | --SocialCalcSpreadsheetControlSave | ||
53 | Content-type: text/plain; charset=UTF-8 | ||
54 | |||
5.1 | 55 | --SocialCalcSpreadsheetControlSave | |
8.1 | 56 | Content-type: text/html; charset=UTF-8 | |
5.1 | 57 | ||
8.1 | 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-- | |
1.1 | 59 | ||
60 | {{/spreadsheet}} |