https://bugs.documentfoundation.org/show_bug.cgi?id=137167
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTOURBUG
Status|UNCONFIRMED |RESOLVED
--- Comment #2 from Mike Kaganski <mikekagan...@hotmail.com> ---
This is not a bug, more specifically - not our bug.
OOXML standard does not put any restrictions on size of value of the related
XML element (ECMA-376 Part 1 sect. 18.3.1.44 "formula1") - it is just a
ST_Formula simple type (and related ยง18.18.35 only states that the simple type
is a string).
[MS-OE376] Office Implementation Information for ECMA-376 Standards Support,
though, does limit the length of ST_Formula to 8192 characters (2.1.1113 Part 4
Section 3.18.36). The other restrictions related to formula1 XML element,
mentioned in the "Implementation Information" (2.1.653 Part 4 Section
3.3.1.41), are not related to the length of the value.
But 8192 characters is rather long string. It's funny how Excel puts further
undocumented (? I couldn't find any official mention of this) restriction on
the parameter: it only accepts 255 characters there. LibreOffice follows that
in [1].
I have tested that using Excel 2016. It opens files with 255 characters there;
it shows an error "We found a problem with some content in 'file.xlsx'. Do you
want us to try to recover as much as we can? If you trust the source of this
workbook, click Yes." and drops the validity list if you change the XML
manually to contain 256 characters, and it simply ignores your attempts to type
more into Source field in Data Validation dialog after 255 characters.
[1]
https://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xecontent.cxx?r=1b43ccea#1752
Closing NOTOURBUG, since we cannot change Excel's behaviour, and we can't save
files, although standard-compliant, that are claimed broken by "reference"
implementation - Excel.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
