[Libreoffice-bugs] [Bug 36379] New: EDITING , FORMATTING: Conditional Formatting formula changed by LibO & OOo

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=36379

           Summary: EDITING , FORMATTING: Conditional Formatting formula
                    changed by LibO & OOo
           Product: LibreOffice
           Version: LibO 3.3.1 release
          Platform: Other
        OS/Version: Windows (All)
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: marc.claes.369 at b-rail.be


Created an attachment (id=45798)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=45798)
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.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.