Created attachment 125166 [details] test document 1. Open the attached document. 2. Save as XLSX. 3. Open the exported file in Excel. => Excel reports errors in the conditional formatting. First, the source ranges are written incorrectly. The test document contains a conditional formatting based on the ranges B2:B4 and D2:D4. Excel uses spaces as range separator, but LO writes semicolon: LO: <conditionalFormatting sqref="B2:B4;D2:D4"> expected: <conditionalFormatting sqref="B2:B4 D2:D4"> Second, after fixing this manually in the XML file with a text editor for testing, Excel still complains about invalid data in the conditional formatting elements.
Version: 5.2.0.0.alpha1+; win7 - after export to xlsx is conditional formatting lost in the file In version 5.1.1.3 is Range empty after export to xlsx
Seems a duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=99917 Please if you are not agree reopen it. *** This bug has been marked as a duplicate of bug 99917 ***
Reopened because of the multi-range problem described in this bug and its attached test document.
Thanks. The sqref error has been fixed.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f18a996409657a2f8f53cca1fad3c045f8f031ec use correct separator for ScRangeList, tdf#99947 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.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=97ecd865c64d9f2bbba7002e87595f3b7401063b use CONV_XL_OOX for xlsx export, related tdf#99947 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.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f56fb307d59897a33aa425bde06fab22ab3f8d0e add test for tdf#99947 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.
This is still a problem in version 5.2.3.