Sound_Tests_transforms >> Page_Manager_transforms 

TB Wiki

Login

navigation
search
toolbox
  article   edit this page   history  

Regression Test

Expected HTML for page "DocSpreadsheetExamples"


expected html
nothing
t1 t
2<table align="right"><tr><td><div class="toc">
3Contents:
4<ul>
5  <li><a href="#simple_spreadsheet">simple&nbsp;spreadsheet</a></li>
6  <ul>
7    <li><a href="#table_not_a_spreadsheet">table&nbsp;not&nbsp;a&nbsp;spreadsheet</a></li>
8    <li><a href="#table_as_spreadsheet">table&nbsp;as&nbsp;spreadsheet</a></li>
9  </ul>
10  <li><a href="#complex_spreadsheets">complex&nbsp;spreadsheets</a></li>
11  <ul>
12    <li><a href="#simple_arithmetic">simple&nbsp;arithmetic</a></li>
13    <li><a href="#complex_formulas">complex&nbsp;formulas</a></li>
14    <li><a href="#multiplication_table">multiplication&nbsp;table</a></li>
15    <li><a href="#test_cell_references">test&nbsp;cell&nbsp;references</a></li>
16  </ul>
17</ul>
18</div></td></tr></table>
19<p>
20Here are some examples of spreadsheet functionality in TBWiki tables
21<p>
22<h1><a name="simple_spreadsheet">simple spreadsheet</a>
23<span align=right class="section_edit_link">[<a href="/tbwiki/DocSpreadsheetExamples?action=edit&section=simple_spreadsheet">edit section</a>]</font></span>
24</h1>
25<h2><a name="table_not_a_spreadsheet">table not a spreadsheet</a>
26<span align=right class="section_edit_link">[<a href="/tbwiki/DocSpreadsheetExamples?action=edit&section=table_not_a_spreadsheet">edit section</a>]</font></span>
27</h2>
28Here is the data, without the "is_spreadsheet" attribute
29<table border=1>
30<tr bgcolor="#d0d0ff">
31  <td align="center"><b>Name</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=Name">^</a></td>
32  <td align="center"><b>count</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=count">^</a></td>
33  <td align="center"><b>cost</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=cost">^</a></td>
34  <td align="center"><b>total</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=total">^</a></td>
35</tr>
36<tr>
37  <td>shoes</td>
38  <td>2</td>
39  <td>.30</td>
40  <td>=2*.30</td>
41</tr>
42<tr>
43  <td>shirts</td>
44  <td>3</td>
45  <td>1.50</td>
46  <td>=3*1.50</td>
47</tr>
48</table>
49<a href="/tbwiki/DocSpreadsheetExamples?action=Table.query_form&source_spec=DocSpreadsheetExamples%3ANot1&conf=&table_block=DocSpreadsheetExamples%3ANot1">
50            <font size=-1>Query</font></a>
51<br>
52 
53<p>
54<h2><a name="table_as_spreadsheet">table as spreadsheet</a>
55<span align=right class="section_edit_link">[<a href="/tbwiki/DocSpreadsheetExamples?action=edit&section=table_as_spreadsheet">edit section</a>]</font></span>
56</h2>
57Here is the data, with the 'is_spreadsheet' attribute:
58<p>
59<table border=1>
60<tr bgcolor="#d0d0ff">
61  <td align="center"><b>Name</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=Name">^</a></td>
62  <td align="center"><b>count</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=count">^</a></td>
63  <td align="center"><b>cost</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=cost">^</a></td>
64  <td align="center"><b>total</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=total">^</a></td>
65</tr>
66<tr>
67  <td>shoes</td>
68  <td>2</td>
69  <td>.30</td>
70  <td>0.6</td>
71</tr>
72<tr>
73  <td>shirts</td>
74  <td>3</td>
75  <td>1.50</td>
76  <td>4.5</td>
77</tr>
78</table>
79<a href="/tbwiki/DocSpreadsheetExamples?action=Table.query_form&source_spec=DocSpreadsheetExamples%3AIs1&conf=&table_block=DocSpreadsheetExamples%3AIs1">
80            <font size=-1>Query</font></a>
81<br>
82 
83<p>
84<h1><a name="complex_spreadsheets">complex spreadsheets</a>
85<span align=right class="section_edit_link">[<a href="/tbwiki/DocSpreadsheetExamples?action=edit&section=complex_spreadsheets">edit section</a>]</font></span>
86</h1>
87<h2><a name="simple_arithmetic">simple arithmetic</a>
88<span align=right class="section_edit_link">[<a href="/tbwiki/DocSpreadsheetExamples?action=edit&section=simple_arithmetic">edit section</a>]</font></span>
89</h2>
90<table border=1>
91<tr bgcolor="#d0d0ff">
92  <td align="center"><b>Name</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=Name">^</a></td>
93  <td align="center"><b>test</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=test">^</a></td>
94  <td align="center"><b>num1</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=num1">^</a></td>
95  <td align="center"><b>num2</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=num2">^</a></td>
96  <td align="center"><b>formula</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=formula">^</a></td>
97  <td align="center"><b>calculation</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=calculation">^</a></td>
98  <td align="center"><b>expected value</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=expected_value">^</a></td>
99</tr>
100<tr>
101  <td>addition</td>
102  <td>literal addition</td>
103  <td>2</td>
104  <td>7</td>
105  <td>f=2+7</td>
106  <td>9</td>
107  <td>9</td>
108</tr>
109<tr>
110  <td>subtraction</td>
111  <td>literal subtraction</td>
112  <td>3</td>
113  <td>1.10</td>
114  <td>f=3-1.10</td>
115  <td>1.9</td>
116  <td>1.9</td>
117</tr>
118<tr>
119  <td>multiplication</td>
120  <td>literal multiplication</td>
121  <td>2.6</td>
122  <td>1.5</td>
123  <td>f=2.6*1.5</td>
124  <td>3.9</td>
125  <td>3.9</td>
126</tr>
127<tr>
128  <td>division</td>
129  <td>literal division</td>
130  <td>7.0</td>
131  <td>2</td>
132  <td>f=7.0/2</td>
133  <td>3.5</td>
134  <td>3.5</td>
135</tr>
136<tr>
137  <td>addition2</td>
138  <td>reference addition</td>
139  <td>2</td>
140  <td>7</td>
141  <td>f=$.num1 + $.num2</td>
142  <td>9</td>
143  <td>9</td>
144</tr>
145<tr>
146  <td>subtraction2</td>
147  <td>reference subtraction</td>
148  <td>3</td>
149  <td>1.10</td>
150  <td>f=$.num1-$.num2</td>
151  <td>1.9</td>
152  <td>1.9</td>
153</tr>
154<tr>
155  <td>multiplication2</td>
156  <td>reference multiplication</td>
157  <td>2.6</td>
158  <td>1.5</td>
159  <td>f=$.num1 * $.num2</td>
160  <td>3.9</td>
161  <td>3.9</td>
162</tr>
163<tr>
164  <td>division2</td>
165  <td>reference division</td>
166  <td>7.0</td>
167  <td>2</td>
168  <td>f=$.num1 / $.num2</td>
169  <td>3.5</td>
170  <td>3.5</td>
171</tr>
172</table>
173<a href="/tbwiki/DocSpreadsheetExamples?action=Table.query_form&source_spec=DocSpreadsheetExamples%3Aarithmetic&conf=&table_block=DocSpreadsheetExamples%3Aarithmetic">
174            <font size=-1>Query</font></a>
175<br>
176 
177<p>
178<h2><a name="complex_formulas">complex formulas</a>
179<span align=right class="section_edit_link">[<a href="/tbwiki/DocSpreadsheetExamples?action=edit&section=complex_formulas">edit section</a>]</font></span>
180</h2>
181The following table has relative references, functions (SUM),
182<table border=1>
183<tr bgcolor="#d0d0ff">
184  <td align="center"><b>Name</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=Name">^</a></td>
185  <td align="center"><b>test</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=test">^</a></td>
186  <td align="center"><b>count</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=count">^</a></td>
187  <td align="center"><b>cost</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=cost">^</a></td>
188  <td align="center"><b>formula</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=formula">^</a></td>
189  <td align="center"><b>total</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=total">^</a></td>
190  <td align="center"><b>expected value</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=expected_value">^</a></td>
191</tr>
192<tr>
193  <td>candy</td>
194  <td>simple formula</td>
195  <td>2</td>
196  <td>.30</td>
197  <td>f=2*.30</td>
198  <td>0.6</td>
199  <td>0.6</td>
200</tr>
201<tr>
202  <td>socks</td>
203  <td>simple formula</td>
204  <td>3</td>
205  <td>1.50</td>
206  <td>f=3*1.50</td>
207  <td>4.5</td>
208  <td>4.5</td>
209</tr>
210<tr>
211  <td>shoes</td>
212  <td>simple ref</td>
213  <td>6</td>
214  <td>2.00</td>
215  <td>f=$shoes.count</td>
216  <td>6</td>
217  <td>6</td>
218</tr>
219<tr>
220  <td>shirts</td>
221  <td>expression</td>
222  <td>3</td>
223  <td>12.95</td>
224  <td>f=$.count * $.cost</td>
225  <td>38.85</td>
226  <td>38.85</td>
227</tr>
228<tr>
229  <td>sub-total</td>
230  <td>sum function</td>
231  <td>.</td>
232  <td>.</td>
233  <td>f=SUM($candy.:$shirts.)</td>
234  <td>49.95</td>
235  <td>49.95</td>
236</tr>
237<tr>
238  <td>sub-count</td>
239  <td>sum of count</td>
240  <td>14.0</td>
241  <td>.</td>
242  <td>f=SUM($candy.count:$shirts.count)</td>
243  <td></td>
244  <td>14.0 (see 'count' column)</td>
245</tr>
246</table>
247<a href="/tbwiki/DocSpreadsheetExamples?action=Table.query_form&source_spec=DocSpreadsheetExamples%3Aspread&conf=&table_block=DocSpreadsheetExamples%3Aspread">
248            <font size=-1>Query</font></a>
249<br>
250 
251<p>
252<h2><a name="multiplication_table">multiplication table</a>
253<span align=right class="section_edit_link">[<a href="/tbwiki/DocSpreadsheetExamples?action=edit&section=multiplication_table">edit section</a>]</font></span>
254</h2>
255<table border=1>
256<tr bgcolor="#d0d0ff">
257  <td align="center"><b>.</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=.">^</a></td>
258  <td align="center"><b>rval</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=rval">^</a></td>
259  <td align="center"><b>col1</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=col1">^</a></td>
260  <td align="center"><b>col2</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=col2">^</a></td>
261  <td align="center"><b>col3</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=col3">^</a></td>
262  <td align="center"><b>col4</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=col4">^</a></td>
263  <td align="center"><b>col5</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=col5">^</a></td>
264  <td align="center"><b>col6</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=col6">^</a></td>
265</tr>
266<tr>
267  <td>cval</td>
268  <td>.</td>
269  <td>1</td>
270  <td>2</td>
271  <td>3</td>
272  <td>4</td>
273  <td>5</td>
274  <td>9</td>
275</tr>
276<tr>
277  <td>row1</td>
278  <td>1</td>
279  <td>1</td>
280  <td>2</td>
281  <td>3</td>
282  <td>4</td>
283  <td>5</td>
284  <td>9</td>
285</tr>
286<tr>
287  <td>row2</td>
288  <td>2</td>
289  <td>2</td>
290  <td>4</td>
291  <td>6</td>
292  <td>8</td>
293  <td>10</td>
294  <td>18</td>
295</tr>
296<tr>
297  <td>row3</td>
298  <td>3</td>
299  <td>3</td>
300  <td>6</td>
301  <td>9</td>
302  <td>12</td>
303  <td>15</td>
304  <td>27</td>
305</tr>
306<tr>
307  <td>row4</td>
308  <td>4</td>
309  <td>4</td>
310  <td>8</td>
311  <td>12</td>
312  <td>16</td>
313  <td>20</td>
314  <td>36</td>
315</tr>
316<tr>
317  <td>row5</td>
318  <td>5</td>
319  <td>5</td>
320  <td>10</td>
321  <td>15</td>
322  <td>20</td>
323  <td>25</td>
324  <td>45</td>
325</tr>
326<tr>
327  <td>row6</td>
328  <td>7</td>
329  <td>7</td>
330  <td>14</td>
331  <td>21</td>
332  <td>28</td>
333  <td>35</td>
334  <td>63</td>
335</tr>
336</table>
337<a href="/tbwiki/DocSpreadsheetExamples?action=Table.query_form&source_spec=DocSpreadsheetExamples%3Amultiplication&conf=&table_block=DocSpreadsheetExamples%3Amultiplication">
338            <font size=-1>Query</font></a>
339<br>
340 
341<p>
342<h2><a name="test_cell_references">test cell references</a>
343<span align=right class="section_edit_link">[<a href="/tbwiki/DocSpreadsheetExamples?action=edit&section=test_cell_references">edit section</a>]</font></span>
344</h2>
345<table border=1>
346<tr bgcolor="#d0d0ff">
347  <td align="center"><b>row_label</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=row_label">^</a></td>
348  <td align="center"><b>test</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=test">^</a></td>
349  <td align="center"><b>formula1</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=formula1">^</a></td>
350  <td align="center"><b>formula2</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=formula2">^</a></td>
351  <td align="center"><b>col4</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=col4">^</a></td>
352  <td align="center"><b>col5</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=col5">^</a></td>
353  <td align="center"><b>expected value1</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=expected_value1">^</a></td>
354  <td align="center"><b>expected value2</b>&nbsp;&nbsp;<a href="/tbwiki/DocSpreadsheetExamples?sortby=expected_value2">^</a></td>
355</tr>
356<tr>
357  <td>row1</td>
358  <td>(data)</td>
359  <td>none</td>
360  <td>none</td>
361  <td>7</td>
362  <td>15</td>
363  <td>7</td>
364  <td>15</td>
365</tr>
366<tr>
367  <td>row2</td>
368  <td>previous cell in columm (this row, column-1)</td>
369  <td>none</td>
370  <td>f=$.-1 + 1</td>
371  <td>11</td>
372  <td>12</td>
373  <td>11</td>
374  <td>12</td>
375</tr>
376<tr>
377  <td>row3</td>
378  <td>previous cell in row (row-1, this column)</td>
379  <td>f=$-1. * 2</td>
380  <td>none</td>
381  <td>22</td>
382  <td>no value</td>
383  <td>22</td>
384  <td>no value</td>
385</tr>
386<tr>
387  <td>row4</td>
388  <td>absolute numeric reference to literal</td>
389  <td>f=$00001.4 + 1</td>
390  <td>none</td>
391  <td>8</td>
392  <td>.</td>
393  <td>8</td>
394  <td>.</td>
395</tr>
396<tr>
397  <td>row5</td>
398  <td>absolute numeric reference to literal</td>
399  <td>f=$00001.5 + 1</td>
400  <td>none</td>
401  <td>16</td>
402  <td>.</td>
403  <td>16</td>
404  <td>.</td>
405</tr>
406<tr>
407  <td>row6</td>
408  <td>named reference to literal</td>
409  <td>f=$row1.col4</td>
410  <td>f=$row1.col5</td>
411  <td>7</td>
412  <td>15</td>
413  <td>7</td>
414  <td>15</td>
415</tr>
416<tr>
417  <td>row7</td>
418  <td>named reference to formula result</td>
419  <td>f=$row2.col5</td>
420  <td>f=$row5.col4</td>
421  <td>12</td>
422  <td>16</td>
423  <td>12</td>
424  <td>16</td>
425</tr>
426<tr>
427  <td>row8</td>
428  <td>absolute numeric reference to formula result</td>
429  <td>f=$00002.5</td>
430  <td>f=$00005.5</td>
431  <td>12</td>
432  <td>16</td>
433  <td>12</td>
434  <td>16</td>
435</tr>
436<tr>
437  <td>row9</td>
438  <td>forward reference to a literal</td>
439  <td>f=$row12.col4</td>
440  <td>f=$row12.col5</td>
441  <td>49</td>
442  <td>43</td>
443  <td>49</td>
444  <td>43</td>
445</tr>
446<tr>
447  <td>row10</td>
448  <td>forward relative reference to a literal</td>
449  <td>f=$+2.col4 + 12</td>
450  <td>f=$+2.-1 * 2</td>
451  <td>61</td>
452  <td>98</td>
453  <td>61</td>
454  <td>98</td>
455</tr>
456<tr>
457  <td>row11</td>
458  <td>forward reference to a formula</td>
459  <td>f=$row13.col4</td>
460  <td>f=$row13.col5</td>
461  <td>=49 + 5</td>
462  <td>=43 + 5</td>
463  <td>54</td>
464  <td>48</td>
465</tr>
466<tr>
467  <td>row12</td>
468  <td>(data)</td>
469  <td>none</td>
470  <td>none</td>
471  <td>49</td>
472  <td>43</td>
473  <td>49</td>
474  <td>43</td>
475</tr>
476<tr>
477  <td>row13</td>
478  <td>named reference to a literal</td>
479  <td>f=$row12.col4 + 5</td>
480  <td>f=$row12.col5 + 5</td>
481  <td>54</td>
482  <td>48</td>
483  <td>54</td>
484  <td>48</td>
485</tr>
486</table>
487<a href="/tbwiki/DocSpreadsheetExamples?action=Table.query_form&source_spec=DocSpreadsheetExamples%3Areferences&conf=&table_block=DocSpreadsheetExamples%3Areferences">
488            <font size=-1>Query</font></a>
489<br>
490 
491<p>
492<p>
Legends
Colors
 Added 
Changed
Deleted
Links
(f)irst change
(n)ext change
(t)op

Differences for page "DocSpreadsheetExamples"


expected html
generated html
t No Differences Found t No Differences Found 
Legends
Colors
 Added 
Changed
Deleted
Links
(f)irst change
(n)ext change
(t)op

Update saved output

Back to diff page

Return to Regression_Test page
Categories: Documentation|Tables
TBWiki engine 2.0.1 by Tim Bird