Bug 91868 - Conditional format error after calc file is saved 2x (only in xls file-format)
Summary: Conditional format error after calc file is saved 2x (only in xls file-format)
Status: RESOLVED DUPLICATE of bug 62770
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.7.1 rc
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-06-05 07:14 UTC by Jean-Paul
Modified: 2016-04-21 16:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
easy way to reproduce the bug (14.00 KB, application/vnd.ms-excel)
2015-06-05 07:14 UTC, Jean-Paul 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jean-Paul 2015-06-05 07:14:36 UTC 
Created attachment 116294 [details]
easy way to reproduce the bug

In a Calc in xls file format, the condition of the conditional formatting of a cell is changed after the file is saved and opened again.

How to reproduce : 

Open a new calc
enter "aa" in cell A1
enter "aa" in cell B1
define a conditional format of cell B1 : if cell content is equal to cell A1, get a style (green color in my case).

Save and open again. If you now look at the definition of the conditional format, A1 is changed to sheet1.A1, which is still correct.

Save and open once again; now the error appears. If you now look at the definition of the conditional format, sheet1.A1 is changed to $#REF!.A1, resulting in a all ways FALSE condition.

This problem only appears with xls files, not with xlsx files neither with ods files.
Comment 1 m_a_riosv 2015-06-05 14:19:56 UTC 
Hi @jnplg, thanks for reporting.

Reproducible.
Win7x64
Version: 4.4.3.2 Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16
Comment 2 Markus Mohrhard 2016-04-21 16:30:20 UTC 

*** This bug has been marked as a duplicate of bug 62770 ***