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.