https://bugs.freedesktop.org/show_bug.cgi?id=79998
raal <r...@post.cz> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |r...@post.cz
Summary|FILESAVE: XLSX export |FILESAVE: XLSX export
|breaks or some sheet names |breaks or some sheet names
| |(sheet name length >31
| |characters)
--- Comment #12 from raal <r...@post.cz> ---
Version: 4.4.0.0.alpha0+
Build ID: 9aa36a1ad39e37c372cc833a44fba450b8cc30cd
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time:
2014-10-09_04:46:44
Created file from scratch with following sheet names (without ""):
"1234567890 1234567890 1234567890" - excel viewer doesn't open file (32
letters)
"1234567890 1234567890 123456789" - excel viewer open this file. Formula is
correct. (31 letters)
The problem is in sheet name length. When sheet name length is >31 characters
than excel viewer fails to open this file. I have not Excel 2010, but according
to google discussions this should be limit in excel (also in version 2013).
Setting as NEW, LibreOffice should warn user that .xlsx file is not readable in
ms office.
In ECMA specification I didn't found allowed length of sheet name:
name (Sheet Name)
Specifies the name of the sheet. This name shall be unique
This attribute is required.
The possible values for this attribute are defined by the ST_Xstring simple
type
(§22.9.2.19).
22.9.2.19
ST_Xstring (Escaped String)
String of characters with support for escaped invalid-XML characters.
For all characters which cannot be represented in XML as defined by the XML 1.0
specification, the characters
are escaped using the Unicode numerical character representation escape
character format _xHHHH_, where H
represents a hexadecimal character in the character's value. [Example: The
Unicode character 8 is not permitted
in an XML 1.0 document, so it must be escaped as _x0008_. end example]
This simple type's contents are a restriction of the W3C XML Schema string
datatype.
[Note: The W3C XML Schema definition of this simple type’s content model
(ST_Xstring) is located in §A.6.9. end
note]
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
