Apache OpenOffice (AOO) Bugzilla – Issue 123667
Conditional formatting is not always read from Excel 97 + if sheet name is included
Last modified: 2013-11-09 19:02:56 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
As given in description. AOO410m1(Build:9750) - Rev. 1539999 2013-11-09_04:08:11 - Rev. 1540252 Debian