Warning, /office/calligra/sheets/OASIS.txt is written in an unsupported language. File is not indexed.
0001 OpenDocument support in Calligra Sheets 0002 ======================================= 0003 0004 Supported Features (OpenDocument's view) 0005 ======================================== 0006 0007 Legend 0008 ====== 0009 Status field: 0010 DONE Loading and saving have been implemented. 0011 ---- No work has been done on this task yet. 0012 noop feature not supported by Calligra Sheets yet 0013 R loading implemented 0014 r loading with minor issues (comment on next line) 0015 W saving implemented 0016 w saving with minor issues (comment on next line) 0017 0018 Prio field: 0019 1 Important task. Should definitely be fixed. 0020 2 Semi-important task. Should be fixed if possible, but can be 0021 moved to the next release 0022 3 Nice to have. Should be fixed if there is time. 0023 0024 0025 Item Prio Status 0026 ------------------------------------------------------------------------------ 0027 8.1 Basic Table Model 0028 8.1.1 Table Element 0029 Table name DONE 0030 Table style ? 0031 Protected ? 0032 Print ? 0033 Print Ranges ? 0034 8.1.2 Table Row 0035 Number Of Rows Repeated DONE 0036 Row style DONE 0037 Default cell style ? 0038 Visibility ? 0039 8.1.3 Table Cell 0040 Number Of Cells Repeated DONE 0041 Spanned ? 0042 Cell Style DONE 0043 Content Validation ? 0044 Formula DONE 0045 Matrix noop 0046 Value Type ? 0047 Current Numeric Value ? 0048 Current Currency ? 0049 Current Date Value ? 0050 Current Time Value ? 0051 Current Boolean Value ? 0052 Current String Value ? 0053 Protection ? 0054 8.2 Advanced Table Model 0055 8.2.1 Column Description ? 0056 Number of Columns Repeated DONE 0057 Column Style DONE 0058 Visibility ? 0059 Default Cell Style ? 0060 8.2.2 Header Columns ? 0061 8.2.3 Columns Groups ? 0062 Display ? 0063 8.2.4 Header Rows ? 0064 8.2.5 Row Groups ? 0065 Display ? 0066 8.2.6 Subtables ? 0067 8.3 Advance Tables 0068 8.3.1 Table Cell References DONE 0069 see 8.1.3 Table Cell, Formula 0070 8.3.2 Linked Tables ? 0071 Mode ? 0072 Table name ? 0073 URL ? 0074 Filter Name ? 0075 8.3.3 Filter Options ? 0076 Refresh Delay ? 0077 8.3.4 Scenario Tables 3 noop 0078 Scenario Ranges 3 noop 0079 Is Active 3 noop 0080 Display Border 3 noop 0081 Border Color 3 noop 0082 Copy Black 3 noop 0083 Copy Styles 3 noop 0084 Copy Formulas 3 noop 0085 Comment 3 noop 0086 Protected 3 noop 0087 8.3.4 Shapes ? 0088 8.4 Advanced Table Cells 0089 8.4.1 Linked Table Cells 3 noop 0090 Name 3 noop 0091 Last Size 3 noop 0092 URL 3 noop 0093 Filter Name 3 noop 0094 Filter Options 3 noop 0095 Refresh Delay 3 noop 0096 8.4.2 Cell Annotation ? 0097 8.4.3 Detective 3 noop 0098 8.4.4 Detective Operation 3 noop 0099 Name 3 noop 0100 Index 3 noop 0101 8.4.5 Highlighted Range 3 noop 0102 Cell Range Address 3 noop 0103 Direction 3 noop 0104 Contains Error 3 noop 0105 Marked Invalid 3 noop 0106 8.5 Spreadsheet Document Content 0107 8.5.1 Document Protection ? 0108 8.5.2 Calculation Settings ? 0109 [...] 0110 8.5.3 Table Content Validations) ? 0111 [...] 0112 8.5.4 Label Ranges 3 noop 0113 [...] 0114 8.5.5 Named Expressions 0115 Named Range ? 0116 Named Expression ? 0117 8.6 Database Ranges 3 noop 0118 [...] 0119 8.7 Filters 3 noop 0120 [...] 0121 8.8 Data Pilot Tables 3 noop 0122 [...] 0123 8.9 Consolidation 3 noop 0124 [...] 0125 8.10 DDE Links 3 noop 0126 [...] 0127 8.11 Change Tracking 2 ---- 0128 [...] 0129 0130 14.1 Table Cell Style Element 0131 Style name DONE 0132 Display Name DONE 0133 Style Family DONE 0134 Parent Style 1 rw 0135 The display name instead of the style name is used. 0136 List Style noop 0137 Automatically Update 3 noop 0138 Data Style Name ? 0139 Class 3 noop 0140 14.1.1 Style Mappings ? 0141 Condition ? 0142 Applied Style ? 0143 Base Cell Address ? 0144 14.2 Table Cell Default Style DONE 0145 0146 0147 14.1 Table Style Element 0148 Style name DONE 0149 Display Name noop 0150 Style Family DONE 0151 Parent Style noop 0152 List Style noop 0153 Master Page Name ? 0154 Automatically Update 3 noop 0155 14.2 Table Default Style 2 ---- 0156 0157 0158 14.1 Table Row Style Element 0159 Style name DONE 0160 Display Name noop 0161 Style Family DONE 0162 Parent Style noop 0163 List Style noop 0164 Automatically Update 3 noop 0165 14.2 Table Row Default Style 2 ---- 0166 0167 0168 14.1 Table Column Style Element 0169 Style name DONE 0170 Display Name noop 0171 Style Family DONE 0172 Parent Style noop 0173 List Style noop 0174 Automatically Update 3 noop 0175 14.2 Table Column Default Style 2 ---- 0176 0177 0178 0179 ============================================================================== 0180 0181 Supported Features (Calligra Sheets' view) 0182 ========================================== 0183 0184 *Legend* 0185 [ ] Not implemented 0186 [x] Implemented 0187 [!] Implemented, not fully compatible 0188 0189 0190 Cell 0191 [x] Obscured/covered cells 0192 [x] Column spans 0193 [x] Row spans 0194 [!] Comment/annotation 0195 [!] Hyperlink 0196 [!] Validation 0197 [!] Conditional formatting 0198 [x] Value, Type and Result 0199 [x] Boolean 0200 [x] String 0201 [x] Number 0202 [x] Floating-point 0203 [ ] Percentage 0204 [ ] Currency 0205 [x] Date 0206 [x] Time 0207 [x] Fraction 0208 [x] Scientific 0209 0210 Format 0211 [x] Font family 0212 [x] Font size 0213 [!] Numeric format 0214 [X] Borders 0215 [ ] Border shadow 0216 [X] Font color 0217 [X] Background style 0218 0219 Sheet 0220 [x] Sheet name 0221 [x] Display or hide 0222 [x] Protection status 0223 [x] Marker position (Not reload) 0224 [x] Sheet properties (view options) 0225 [ ] Value highlighting 0226 [ ] Sheet tab color (Not supported by Calligra Sheets) 0227 0228 Document/Workbook 0229 [x] Active sheet 0230 [x] Header 0231 [x] Footer 0232 [x] Page layout 0233 [x] Protection status 0234 [x] Print range 0235 [x] Print setup 0236 0237 View Settings 0238 0239 Formula (not supported yet) 0240 0241 Configuration Settings 0242 ShowZeroValues 0243 ShowNotes 0244 [X] ShowGrid 0245 GridColor 0246 ShowPageBreak 0247 LinkUpdateMode 0248 HasColumnRowHeaders 0249 HasSheetTabs 0250 IsOutlineSymbolsSet 0251 IsSnapToRaster 0252 RasterIsVisible 0253 RasterResolutionX 0254 RasterResolutionY 0255 RasterSubdivisionX 0256 RasterSubdivisionY 0257 IsRasterAxisSynchronized 0258 AutoCalculate 0259 PrinterName 0260 PrinterSetup 0261 ApplyUserData 0262 CharacterCompressionType 0263 IsKernAsianPunctuation 0264 SaveVersionOnClose 0265 UpdateFromTemplate 0266 0267 =========================================================== 0268 REMARKS, INCOMPATIBILITIES, etc 0269 =========================================================== 0270 0271 Calligra Sheets does not support rich text. Any cells/annotations which contain 0272 rich text will be converted to simple plain text. 0273 0274 Link may not fully compatible since Calligra Sheets can only link the whole cell, 0275 not partial text. For example, if the text is "Visit the website" where only 0276 the string "website" is a hyperlink to an URL, in Calligra Sheets the whole string 0277 "Visit the website" becomes the link. Consequently, if the text contains 0278 two or more links, only the first link will be used. 0279 (I will fixe when we convert it to kotext) 0280 0281 =========================================================== 0282 IN PROGRESS 0283 =========================================================== 0284 -> Save/load numeric-style 0285 0286 =========================================================== 0287 TODO 0288 =========================================================== 0289 -> after loading cursor position me must update view 0290 -> fix default value (for printing) 0291 -> Save/load spell checking ignore word into settings.xml 0292 -> Save/load col-width/row-height into settings.xml 0293 -> Fix load conditional attribute, for the moment it load just one style 0294 0295 =========================================================== 0296 EXEMPLARY XML SNIPPETS 0297 =========================================================== 0298 0299 Hyperlink (whole cell) 0300 <table:table-cell> 0301 <text:p> 0302 <text:a xlink:href="http://www.calligra.org/">Visit Calligra website</text:a> 0303 </text:p> 0304 </table:table-cell> 0305 0306 Hyperlink (one word, rich text) 0307 <table:table-cell> 0308 <text:p> 0309 This is a 0310 <text:a xlink:href="http://www.kde.org/">link</text:a> 0311 to somewhere 0312 </text:p> 0313 </table:table-cell> 0314 0315 Link to another cell 0316 <table:table-cell> 0317 <text:p> 0318 <text:a xlink:href="#A1">Jump to Home</text:a> 0319 </text:p> 0320 </table:table-cell> 0321 0322 Multiline Text inside cell 0323 <table:table-cell> 0324 <text:p>Halo There</text:p> 0325 <text:p>What's up guys</text:p> 0326 <text:p>This is very long indeed</text:p> 0327 </table:table-cell> 0328 0329 Merged cells 0330 <table:table-cell table:style-name="ce2" office:value-type="string" 0331 office:string-value="These A1:B1 are merged together" table:number-columns-spanned="2"> 0332 <text:p>These A1:B1 are merged together</text:p> 0333 </table:table-cell> 0334 <table:covered-table-cell table:style-name="ce3"/> 0335 0336 Cell horizontal alignment: top 0337 <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default"> 0338 <style:table-cell-properties style:vertical-align="top"/> 0339 </style:style> 0340 0341 Cell horizontal alignment: middle 0342 <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default"> 0343 <style:table-cell-properties style:vertical-align="middle"/> 0344 </style:style> 0345 0346 Cell horizontal alignment: bottom 0347 <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default"> 0348 <style:table-cell-properties style:vertical-align="bottom"/> 0349 </style:style> 0350 0351 Cell vertical alignment: top 0352 <style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default"> 0353 <style:table-cell-properties fo:text-align="center" 0354 style:text-align-source="fix" style:repeat-content="none" 0355 fo:margin-left="0in" style:vertical-align="top"/> 0356 </style:style> 0357 0358 Cell vertical alignment: middle 0359 <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default"> 0360 <style:table-cell-properties fo:text-align="center" 0361 style:text-align-source="fix" style:repeat-content="none" 0362 fo:margin-left="0in" style:vertical-align="middle"/> 0363 </style:style> 0364 0365 0366 Cell vertical alignment: bottom 0367 <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default"> 0368 <style:table-cell-properties fo:text-align="center" 0369 style:text-align-source="fix" style:repeat-content="none" 0370 fo:margin-left="0in" style:vertical-align="bottom"/> 0371 </style:style> 0372 0373 <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default"> 0374 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> 0375 <style:paragraph-properties fo:text-align="center"/> 0376 <style:text-properties fo:font-size="16pt" fo:font-style="italic" fo:font-weight="bold"/> 0377 </style:style> 0378 0379 0380 Unprotected cell 0381 <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default"> 0382 <style:table-cell-properties style:cell-protect="none" 0383 style:print-content="true"/> 0384 </style:style> 0385 0386 Protected sheet 0387 <table:table table:name="Sheet1" table:style-name="ta1" 0388 table:protected="true" table:protection-key="Fa52hNHBdTG7CgoGGStwsTuzHyI=" 0389 table:automatic-print-range="false"> 0390 .... 0391 </table:table> 0392 0393 Repeate-header-rows: 0394 <table:table-header-rows> 0395 <table:table-row table:style-name="ro1"> 0396 <table:table-cell table:number-columns-repeated="2"/> 0397 <table:table-cell table:style-name="Default"/> 0398 <table:table-cell table:number-columns-repeated="3"/> 0399 </table:table-row> 0400 <table:table-row table:style-name="ro1"> 0401 <table:table-cell table:number-columns-repeated="3"/> 0402 <table:table-cell table:style-name="ce1" table:number-columns-repeated="3"/> 0403 </table:table-row> 0404 </table:table-header-rows> 0405 0406 Repeate header columns 0407 ---------------------- 0408 <table:table-header-columns> 0409 <table:table-column table:style-name="co1" table:number-columns-repeated="2" table:default-cell-style-name="ce5"/> 0410 <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/> 0411 </table:table-header-columns> 0412 0413 Bug found: 0414 ---------- 0415 - duplicate cell area is not good. 0416 - Style is not save/load correctly 0417 - Cell format is not saving/loading 0418