[Libreoffice-bugs] [Bug 137167] Validity List truncated when saving in Excel format
https://bugs.documentfoundation.org/show_bug.cgi?id=137167 Stéphane Guillou (stragu) changed: What|Removed |Added CC||binom3...@yandex.ru --- Comment #5 from Stéphane Guillou (stragu) --- *** Bug 155080 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 137167] Validity List truncated when saving in Excel format
https://bugs.documentfoundation.org/show_bug.cgi?id=137167 Mike Kaganski changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||3345 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 137167] Validity List truncated when saving in Excel format
https://bugs.documentfoundation.org/show_bug.cgi?id=137167 Mike Kaganski changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||7277 -- 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
[Libreoffice-bugs] [Bug 137167] Validity List truncated when saving in Excel format
https://bugs.documentfoundation.org/show_bug.cgi?id=137167 Commit Notification changed: What|Removed |Added Whiteboard||target:7.1.0 -- 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
[Libreoffice-bugs] [Bug 137167] Validity List truncated when saving in Excel format
https://bugs.documentfoundation.org/show_bug.cgi?id=137167 --- Comment #4 from Commit Notification --- Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f90500754fac014638214b5e061832b2c518aab6 Related tdf#137167: reference Excel pb on limitation for data validity formula It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- 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
[Libreoffice-bugs] [Bug 137167] Validity List truncated when saving in Excel format
https://bugs.documentfoundation.org/show_bug.cgi?id=137167 Eike Rathke changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=99 ||856 --- Comment #3 from Eike Rathke --- See also bug 99856 for which the limitation was introduced to satisfy 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
[Libreoffice-bugs] [Bug 137167] Validity List truncated when saving in Excel format
https://bugs.documentfoundation.org/show_bug.cgi?id=137167 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||108988 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108988 [Bug 108988] [META] Validity-related bugs and enhancements -- 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
[Libreoffice-bugs] [Bug 137167] Validity List truncated when saving in Excel format
https://bugs.documentfoundation.org/show_bug.cgi?id=137167 Mike Kaganski changed: What|Removed |Added Resolution|--- |NOTOURBUG Status|UNCONFIRMED |RESOLVED --- Comment #2 from Mike Kaganski --- 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
[Libreoffice-bugs] [Bug 137167] Validity List truncated when saving in Excel format
https://bugs.documentfoundation.org/show_bug.cgi?id=137167 --- Comment #1 from Buovjaga --- *** Bug 137168 has been marked as a duplicate of this bug. *** -- 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
