Bug 88175 (XLSX-Limitations) - [META] XLSX (OOXML) format limitations
Summary: [META] XLSX (OOXML) format limitations
Status: NEW
Alias: XLSX-Limitations
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on: 79787 82218 84874 90324 91332 58375 61148 62878 75167 82654 103173 104530
Blocks: Format-Limitations XLSX
  Show dependency treegraph
 
Reported: 2015-01-07 19:06 UTC by Robinson Tryon (qubit)
Modified: 2019-02-27 09:47 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Robinson Tryon (qubit) 2015-01-07 19:06:34 UTC
For each bug added, please add a short comment describing the limitation. This can often be the Summary line, if it's descriptive enough

e.g.
"bug 12345 - Can't save foobar-encoded video to DOC file"
Comment 1 Robinson Tryon (qubit) 2015-01-07 20:10:52 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).
Comment 2 Robinson Tryon (qubit) 2015-12-09 16:50:55 UTC
Migrating Whiteboard tags to Keywords: (filter:xlsx)
Comment 3 Bartosz 2016-06-08 15:55:00 UTC
FORMATTING: User Defined Custom Formatting is not applied during importing XLSX documents:
https://bugs.documentfoundation.org/show_bug.cgi?id=70565
Comment 4 Victor V. Terber 2016-11-27 12:52:36 UTC Comment hidden (obsolete)
Comment 5 Luke 2016-11-29 07:33:10 UTC Comment hidden (obsolete)
Comment 6 Bartosz 2016-12-10 22:25:08 UTC
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
Comment 7 Bartosz 2016-12-10 22:37:15 UTC
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
Comment 8 Bartosz 2016-12-10 23:09:21 UTC
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.
Comment 9 Timur 2018-07-19 12:39:15 UTC
I guess Bug 58375 goes here. 
LO Calc has "Hyphenation Active" with Format-Cells-Wrap and MSO Excel doesn't have that option. I don't see Hyphenation in "18. SpreadsheetML Reference Material".