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.
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":
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:
Affected users are encouraged to test the fix and report feedback.