Bug 53407 - FORMATTING: Calc Conditional Formatting 3.5 vs. 3.6 - not compatible
Summary: FORMATTING: Calc Conditional Formatting 3.5 vs. 3.6 - not compatible
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-12 13:44 UTC by Daniel Armata
Modified: 2012-08-13 16:44 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
example spreadsheet w/ formatting (8.47 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-08-12 13:44 UTC, Daniel Armata
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Daniel Armata 2012-08-12 13:44:04 UTC
Created attachment 65465 [details]
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
Comment 1 Markus Mohrhard 2012-08-13 16:44:20 UTC
Already fixed for 3.6.1