[Libreoffice-bugs] [Bug 53407] New: FORMATTING: Calc Conditional Formatting 3.5 vs. 3.6 - not compatible

[bugzilla-daemon at freedesktop.org]

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

             Bug #: 53407
           Summary: FORMATTING: Calc Conditional Formatting 3.5 vs. 3.6 -
                    not compatible
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.6.0.4 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: armatad at verizon.net


Created attachment 65465
  --> https://bugs.freedesktop.org/attachment.cgi?id=65465
example spreadsheet w/ formatting

Problem description: 
I can't find this as an open bug yet...
When opening a new spreadsheet created in Calc 3.5.5 or Calc 3.5.6rc2 that has
conditional formatting with a formula, it does not read properly when opened in
Calc 3.6.0.4.
Additionally, when creating a new spreadsheet in Calc 3.6 that has conditional
formatting and opening it in Calc 3.5.5 (or any 3.5.x) that has a formula, the
formula changes the cell reference.

Steps to reproduce:
1. In any version of Calc 3.5, create a new spreadsheet.  
2. In cell A1, enter 0
3. In cell B2, open conditional formatting, and put in: Condition 1, formula is
IF(A1=1).
4. Save spreadsheet and close Calc.
5. Open Calc 3.6, and open the new spreadsheet.
6. Open the conditional formatting for cell B2.  Formula will read
IF(#REF!#REF!=1).  Oddly enough, it will work.
7. If you correct the conditional formatting formula in Calc 3.6, save it and
open it in Calc 3.5.x, the formula will read IF(B2=1)
8. If you don't touch cell b2 and add a new conditional formatting formula in
cell b3 as IF(A1=1) and open it in calc 3.5.x, the formula will read IF(B3=1)

Current behavior: #6,#7,#8
**A side-note, if the spreadsheet saved in 3.5 contains a lot of conditional
formatting across multiple tabs and opened in 3.6, editing any cell will crash
3.6 - It might be related to the #REF formulas or it might be a separate bug. 
I'm still working on steps to reproduce to see if it is related to this issue
or not.

Expected behavior:  Formulas do not change between 3.5.x and 3.6.0.4. My guess
is v3.6 is reading the formatting from 3.5 wrong and v3.6 is saving the
formatting differently so 3.5 does not read it correctly.  Possible problem
introduced with the new Conditional Formatting UI?

Platform (if different from the browser): 
Fedora Linux x86_64
And
Windows 7 SP1 x86_64

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