| Summary: | [META] XLSX (OOXML) format limitations | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Robinson Tryon (qubit) <robinson.libreoffice> |
| Component: | LibreOffice | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | normal | CC: | cno, gang65, kelemeng, robinson.libreoffice, thomas.lendo |
| Priority: | medium | Keywords: | filter:xlsx |
| Version: | unspecified | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | 43136, 140496, 152036, 153214, 157967, 159654, 58375, 61148, 62878, 65136, 75167, 79787, 82218, 82654, 90324, 91332, 103173, 104530, 136219, 136721, 140185, 150996 | ||
| Bug Blocks: | 87761, 108897 | ||
|
Description
Robinson Tryon (qubit)
2015-01-07 19:06:34 UTC
Bug 75167 - Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved LIMITATION: Calc does not save Regular Expression settings in a format of spreadsheet that is incompatible with Excel (Excel does not support Regular Expressions). Migrating Whiteboard tags to Keywords: (filter:xlsx) FORMATTING: User Defined Custom Formatting is not applied during importing XLSX documents: https://bugs.documentfoundation.org/show_bug.cgi?id=70565 Bug 104186 was added to the "Depends on" section of bug 88175. In my opinion this is incorrect as bug 104186 describes a failure to comply with the existing XLSX (ECMA-376) format. In my understanding this is not a "limitation" of the format as stated in the title of bug 88175 but a plain and simple bug. Bartosz, Is this something you could take a look at? Thanks! OOXML format supports only 6 arrow ends: None, Triangle Arrow Head, Stealth Arrow, Diamond, Oval and Arrow Head http://www.datypic.com/sc/ooxml/t-a_ST_LineEndType.html https://msdn.microsoft.com/en-us/library/documentformat.openxml.drawing.headend(v=office.14).aspx Bug 61148 OOXML doesn't support border thickness, other than: 0.75 (Medium) and 1.75 (Thick): https://msdn.microsoft.com/en-us/library/office/documentformat.openxml.spreadsheet.borderstylevalues.aspx Bug 62878 is an limitation of the OOXML format. The indentation is saved in .xlsx, as integer value, where an increment of 1 represents 3 spaces. https://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.alignment.aspx It means that minimal identation width is 3 spaces. Unfortunately we cannot do much to fix that bug. |