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
Already fixed for 3.6.1