KOffice – TDE office suite
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

241 lines
7.6KB

  1. ===========================================================
  2. STATUS of OASIS support in KSpread
  3. ===========================================================
  4. *Legend*
  5. [ ] Not implemented
  6. [x] Implemented
  7. [!] Implemented, not fully compatible
  8. Cell
  9. [x] Obscured/covered cells
  10. [x] Column spans
  11. [x] Row spans
  12. [!] Comment/annotation
  13. [!] Hyperlink
  14. [!] Validation
  15. [!] Conditional formatting
  16. [x] Value, Type and Result
  17. [x] Boolean
  18. [x] String
  19. [x] Number
  20. [x] Floating-point
  21. [ ] Percentage
  22. [ ] Currency
  23. [x] Date
  24. [x] Time
  25. [x] Fraction
  26. [x] Scientific
  27. Format
  28. [x] Font family
  29. [x] Font size
  30. [!] Numeric format
  31. [X] Borders
  32. [ ] Border shadow
  33. [X] Font color
  34. [X] Background style
  35. Sheet
  36. [x] Sheet name
  37. [x] Display or hide
  38. [x] Protection status
  39. [x] Marker position (Not reload)
  40. [x] Sheet properties (view options)
  41. [ ] Value highlighting
  42. [ ] Sheet tab color (Not supported by kspread)
  43. Document/Workbook
  44. [x] Active sheet
  45. [x] Header
  46. [x] Footer
  47. [x] Page layout
  48. [x] Protection status
  49. [x] Print range
  50. [x] Print setup
  51. View Settings
  52. Formula (not supported yet)
  53. Configuration Settings
  54. ShowZeroValues
  55. ShowNotes
  56. [X] ShowGrid
  57. GridColor
  58. ShowPageBreak
  59. LinkUpdateMode
  60. HasColumnRowHeaders
  61. HasSheetTabs
  62. IsOutlineSymbolsSet
  63. IsSnapToRaster
  64. RasterIsVisible
  65. RasterResolutionX
  66. RasterResolutionY
  67. RasterSubdivisionX
  68. RasterSubdivisionY
  69. IsRasterAxisSynchronized
  70. AutoCalculate
  71. PrinterName
  72. PrinterSetup
  73. ApplyUserData
  74. CharacterCompressionType
  75. IsKernAsianPunctuation
  76. SaveVersionOnClose
  77. UpdateFromTemplate
  78. ===========================================================
  79. REMARKS, INCOMPATIBILITIES, etc
  80. ===========================================================
  81. KSpread does not support rich text. Any cells/annotations which contain
  82. rich text will be converted to simple plain text.
  83. Link may not fully compatible since KSpread can only link the whole cell,
  84. not partial text. For example, if the text is "Visit the website" where only
  85. the string "website" is a hyperlink to an URL, in KSpread the whole string
  86. "Visit the website" becomes the link. Consequently, if the text contains
  87. two or more links, only the first link will be used.
  88. (I will fixe when we convert it to kotext)
  89. ===========================================================
  90. IN PROGRESS
  91. ===========================================================
  92. -> Save/load numeric-style
  93. ===========================================================
  94. TODO
  95. ===========================================================
  96. -> after loading cursor position me must update view
  97. -> fix default value (for printing)
  98. -> Save/load spell checking ignore word into settings.xml
  99. -> Save/load col-width/row-height into settings.xml
  100. -> Fix load conditional attribute, for the moment it load just one style
  101. ===========================================================
  102. EXEMPLARY XML SNIPPETS
  103. ===========================================================
  104. Hyperlink (whole cell)
  105. <table:table-cell>
  106. <text:p>
  107. <text:a xlink:href="http://www.koffice.org/">Visit KOffice website</text:a>
  108. </text:p>
  109. </table:table-cell>
  110. Hyperlink (one word, rich text)
  111. <table:table-cell>
  112. <text:p>
  113. This is a
  114. <text:a xlink:href="http://www.kde.org/">link</text:a>
  115. to somewhere
  116. </text:p>
  117. </table:table-cell>
  118. Link to another cell
  119. <table:table-cell>
  120. <text:p>
  121. <text:a xlink:href="#A1">Jump to Home</text:a>
  122. </text:p>
  123. </table:table-cell>
  124. Multiline Text inside cell
  125. <table:table-cell>
  126. <text:p>Halo There</text:p>
  127. <text:p>What's up guys</text:p>
  128. <text:p>This is very long indeed</text:p>
  129. </table:table-cell>
  130. Merged cells
  131. <table:table-cell table:style-name="ce2" office:value-type="string"
  132. office:string-value="These A1:B1 are merged together" table:number-columns-spanned="2">
  133. <text:p>These A1:B1 are merged together</text:p>
  134. </table:table-cell>
  135. <table:covered-table-cell table:style-name="ce3"/>
  136. Cell horizontal alignment: top
  137. <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default">
  138. <style:table-cell-properties style:vertical-align="top"/>
  139. </style:style>
  140. Cell horizontal alignment: middle
  141. <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">
  142. <style:table-cell-properties style:vertical-align="middle"/>
  143. </style:style>
  144. Cell horizontal alignment: bottom
  145. <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default">
  146. <style:table-cell-properties style:vertical-align="bottom"/>
  147. </style:style>
  148. Cell vertical alignment: top
  149. <style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default">
  150. <style:table-cell-properties fo:text-align="center"
  151. style:text-align-source="fix" style:repeat-content="none"
  152. fo:margin-left="0in" style:vertical-align="top"/>
  153. </style:style>
  154. Cell vertical alignment: middle
  155. <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default">
  156. <style:table-cell-properties fo:text-align="center"
  157. style:text-align-source="fix" style:repeat-content="none"
  158. fo:margin-left="0in" style:vertical-align="middle"/>
  159. </style:style>
  160. Cell vertical alignment: bottom
  161. <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default">
  162. <style:table-cell-properties fo:text-align="center"
  163. style:text-align-source="fix" style:repeat-content="none"
  164. fo:margin-left="0in" style:vertical-align="bottom"/>
  165. </style:style>
  166. <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default">
  167. <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
  168. <style:paragraph-properties fo:text-align="center"/>
  169. <style:text-properties fo:font-size="16pt" fo:font-style="italic" fo:font-weight="bold"/>
  170. </style:style>
  171. Unprotected cell
  172. <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default">
  173. <style:table-cell-properties style:cell-protect="none"
  174. style:print-content="true"/>
  175. </style:style>
  176. Protected sheet
  177. <table:table table:name="Sheet1" table:style-name="ta1"
  178. table:protected="true" table:protection-key="Fa52hNHBdTG7CgoGGStwsTuzHyI="
  179. table:automatic-print-range="false">
  180. ....
  181. </table:table>
  182. Repeate-header-rows:
  183. <table:table-header-rows>
  184. <table:table-row table:style-name="ro1">
  185. <table:table-cell table:number-columns-repeated="2"/>
  186. <table:table-cell table:style-name="Default"/>
  187. <table:table-cell table:number-columns-repeated="3"/>
  188. </table:table-row>
  189. <table:table-row table:style-name="ro1">
  190. <table:table-cell table:number-columns-repeated="3"/>
  191. <table:table-cell table:style-name="ce1" table:number-columns-repeated="3"/>
  192. </table:table-row>
  193. </table:table-header-rows>
  194. Repeate header columns
  195. ----------------------
  196. <table:table-header-columns>
  197. <table:table-column table:style-name="co1" table:number-columns-repeated="2" table:default-cell-style-name="ce5"/>
  198. <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
  199. </table:table-header-columns>
  200. Bug found:
  201. ----------
  202. - duplicate cell area is not good.
  203. - Style is not save/load correctly
  204. - Cell format is not saving/loading