[Libreoffice-bugs] [Bug 137167] Validity List truncated when saving in Excel format

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137167

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTOURBUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #2 from Mike Kaganski <mikekaganski at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200930/5cb84ac6/attachment-0001.htm>