Issue 123667 - Conditional formatting is not always read from Excel 97 + if sheet name is included
Summary: Conditional formatting is not always read from Excel 97 + if sheet name is in...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.0.1
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-11-09 18:08 UTC by wrigh
Modified: 2013-11-09 19:02 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Conditional format example for saving as .xls 97 file and reloading (9.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-11-09 18:08 UTC, wrigh 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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