summaryrefslogtreecommitdiff
path: root/UI/form-dynatable.odst
blob: 7a4cdfdc5c0a2e1e4f95b8989e3e96033101eab5 (plain)
  1. <workbook>
  2.     <worksheet name="test" rows="<?lsmb rows.size + 1 ?>" columns="<?lsmb columns.size + 1 ?>">
  3. <format bottom="5" bg_color="lime" bottom_color="magenta"><row>
  4. <?lsmb FOREACH column IN columns ?>
  5. <?lsmb IF heading.$column.text ?><format italic="1">
  6. <cell text="<?lsmb heading.$column.text ?>" /></format>
  7. <?lsmb ELSE ?><format bold="1">
  8. <cell text="<?lsmb heading.$column ?>" /></format>
  9. <?lsmb END; END ?>
  10. <format num_format="17">
  11. <cell text="2007-08-05" />
  12. </format>
  13. </row></format>
  14. <format align="right">
  15. <?lsmb FOREACH row IN rows ?>
  16. <row>
  17. <?lsmb FOREACH column IN columns ?>
  18. <?lsmb IF loop.first ?><format num_format="3">
  19. <?lsmb END ?>
  20. <?lsmb IF row.$column.href ?>
  21. <italic>
  22. <cell text="<?lsmb row.$column.text ?>" />
  23. </italic>
  24. <?lsmb ELSE ?>
  25. <format font_outline="1">
  26. <cell text="<?lsmb row.$column ?>" />
  27. </format>
  28. <?lsmb END ?>
  29. <?lsmb IF loop.first ?></format><?lsmb END ?>
  30. <?lsmb END ?>
  31. </row>
  32. <?lsmb END ?></format>
  33. <?lsmb IF totals; t = [] ?>
  34. <row>
  35. <?lsmb FOREACH column IN columns ?>
  36. <cell text="<?lsmb totals.$column ?>" />
  37. <?lsmb END ?>
  38. </row>
  39. <?lsmb END ?>
  40. </worksheet>
  41. <worksheet name="test2" rows='3' columns='1'>
  42. <row><cell text='1' type='number' /></row>
  43. <row><cell text='2' type='number' /></row>
  44. <row><formula text='sum(A1:A2)' type='formula' /></row>
  45. </worksheet>
  46. </workbook>