Created attachment 45798 [details] series of random numbers; cond. form. colors largest & 2nd largest When entering a conditional formatting formula in MS Excel, sheet references are not allowed. Opening a .xls file with cond. form. in OOo or LibO, (editing and) saving it as .xls, then opening the saved file again in Excel shows the "corruption" done by OOo and LO: cell references in cond. form. formulas get prepended by sheet references, which generates an error message in Excel. See the file attached: - open with Excel: no problem - open with OOo or LibO: no problem - save as .xls in OOo or LibO: no problem - now open saved file again in Excel: cond. form. formulas give error message.
Could you attach the original Excel file that Excel opens without problem? The attached file is already damaged and even opening it in Excel shows #NAME! errors.
Created attachment 45845 [details] series of random numbers; cond. form. colors largest & 2nd largest - corrected My mistake. Sorry. Hope this does it...
Hmm... Excel still shows a bunch of #NAME! errors even with the 2nd file...
Created attachment 45904 [details] 45845: series of random numbers; cond. form. colors largest & 2nd largest - 2xcorrected See mail for 2nd correction. Sorry again...
Similar to Bug 48785
Bug may be related also to https://bugs.freedesktop.org/show_bug.cgi?id=36587 It seems indeed that when opening the file (in bug 36587 ), the formula is modified. So an IMPORT xls formula bug. Maybe they can be merged together ?
*** Bug 48785 has been marked as a duplicate of this bug. ***
*** Bug 57076 has been marked as a duplicate of this bug. ***
*** Bug 36587 has been marked as a duplicate of this bug. ***
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d1def6b029ad941d0b2cbecd8f682ae0d33ddd79 don't make 2D refs 3D refs in the cond format import, fdo#36379 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.