Issue 123667

Summary: Conditional formatting is not always read from Excel 97 + if sheet name is included
Product: Calc Reporter: wrigh <wrightash>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues
Version: 4.0.1   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Conditional format example for saving as .xls 97 file and reloading none

Description wrigh 2013-11-09 18:08:11 UTC
Created attachment 81902 [details]
Conditional format example for saving as .xls  97 file and reloading

Loading an excel 97 .xls spreadsheet changes the cell target in certain circumstances.
This may be a reopen of Bug 8014

The attached file was created as below the ================ line:

Load it into Open Office.
Save the file as an Excel file 97+   .xls
Close the file
Load it into Open Office.
Cells E5, E7, E8 will be yellow        CORRECT
Cell B6, B9, B10 will not.             ERROR

The Conditional format for Cell E6 is now something like 
   Cell value =  $Sheet2.IT1

If you load the file into Excel 97 the cells are correctly coloured yellow.


==========================================================================

The cells chosen and numbers are random.
Create a new spreadsheet
On sheet 1
  For comparison take 6 cells, say B5 to B10
  Fill these with numbers  say 10,11,12,13

Put the same set of numbers in corresponding cells E5 to E10, so E5 = B5, E6 = B6 etc

Conditionally format E5 as follows
    Cell value = $Sheet1.$B$5  (e.g. by clicking on cell B5 in the cond format window)
    Before clicking on OK, create a new format if true eg yellow background.

Now conditionally format cells E6,to E10 Use the same background if the condition is true
E6:     Cell value = $Sheet1.B6
E7:     Cell value = B7
E8:     Cell value = $B$8
E9:     Cell Value = $Sheet2.B$9
E9:     Cell Value = $Sheet2.B$9
E10:    Cell Value = $Sheet2.$B10

All six cells will be coloured yellow

Now save the file as an ods file
Comment 1 Edwin Sharp 2013-11-09 19:02:56 UTC
As given in description.

AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Debian