https://issues.apache.org/ooo/show_bug.cgi?id=123667
Bug ID: 123667
Issue Type: DEFECT
Summary: Conditional formatting is not always read from Excel
97 + if sheet name is included
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: formatting
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 81902
--> https://issues.apache.org/ooo/attachment.cgi?id=81902&action=edit
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
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
