| Summary: | FILESAVE Long data-validity-list when saves as XLSX give error in Excel, due to exceed 255 character limit of <formula1> | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | VLB <vlb1> |
| Component: | Calc | Assignee: | Justin L <jluth> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | erack, ilmari.lauhakangas, jluth, kelemeng, markus.mohrhard |
| Priority: | medium | ||
| Version: | 3.5.7.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=86575 https://bugs.documentfoundation.org/show_bug.cgi?id=137167 https://bugs.documentfoundation.org/show_bug.cgi?id=137277 |
||
| Whiteboard: | target:5.5.0 target:5.4.0.1 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Data-test file
Example of exported file Minimum data test file Data test file fix in Office 2010 Validation list created with Excel 2010 with special characters ("<", ">", "'", "&") .xlsx file with maximum allowed characters in <formula1> |
||
|
Description
VLB
2016-05-15 11:48:36 UTC
Created attachment 125058 [details]
Data-test file
windows 10 64 bit and use LO 5.1.3 In referring to bug 86575. I have test in 3.5.7 to 5.1.4 Bug reproduce: 1) Open attachment 2) see Data-validity-list in cell a1 3) save as file *.xslx 4) open in excel and give error and data-validity-lis is gone Repro. Win 8.1 32-bit LibreOffice Version: 5.2.0.0.alpha1+ Build ID: cc1a0ba927ad6f85103059aa8e6108017f436304 CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2016-05-17_02:31:19 Locale: fi-FI (fi_FI) MSO 2013 Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2d3f0f2dade850af8b7e179bcc076f1ba543bfbd mention purpose of FLOOR.XCL() and CEILING.XCL(), tdf#99856 related It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Forget that ^^^ commit, it's unrelated, bad bug number in commit message. @moggi: apparently Excel doesn't like something we save to the <dataValidation> element, idea? (In reply to Eike Rathke from comment #6) > @moggi: apparently Excel doesn't like something we save to the > <dataValidation> element, idea? @Eike: do you have a file? Normally it shows up as a validation error. @Markus: hum.. take https://bugs.documentfoundation.org/attachment.cgi?id=125058 of this bug? ;-) Created attachment 127634 [details]
Example of exported file
Created attachment 127635 [details]
Minimum data test file
Created attachment 127636 [details]
Data test file fix in Office 2010
To resolve that issue characters like "<", ">" and "&" must be replaced with: < > and & Created attachment 127708 [details]
Validation list created with Excel 2010 with special characters ("<", ">", "'", "&")
Created attachment 127720 [details]
.xlsx file with maximum allowed characters in <formula1>
The root cause of that issue is too many characters in <formula1> field (255 characters limit).
When the list will be smaller, then MS Excel opening such file correctly.
Unfortunately I cannot provide solution for that issue.
proposed fix: gerrit.libreoffice.org/38038 tdf#99856 Several other data validation values can also cause a corrupt file. -non-list items: value starts with a number, followed by non-numbers -non-list items: values containing spaces, especially followed by a number -date/time: invalid date/time value (possible, but not easy to do in LO). Justin Luth committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b139bf96574010f317c543bc45d23dd6a5810621 tdf#99856 xlsx export: limit dataValidation list to 255 chars It will be available in 5.5.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=21b7cb2737d95f281e28e248c4dad306a5c6463f&h=libreoffice-5-4 tdf#99856 xlsx export: limit dataValidation list to 255 chars It will be available in 5.4.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |