https://bugs.freedesktop.org/show_bug.cgi?id=57955
Priority: medium
Bug ID: 57955
Assignee: [email protected]
Summary: FORMATTING:
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.6.4.3 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 71092
--> https://bugs.freedesktop.org/attachment.cgi?id=71092&action=edit
Example spreadsheet showing the problem.
Conditional formatinng in spreadsheet is not seen correctly when opened in
Excel 2007. I have this problem with version 3.6.4 and several previous
versions. 3.6.4 was not available, so I selected 3.6.4rc3.
Steps to reproduce:
1) Create a spreadsheet with Calc, with three cells A1, B1 and C1, conatining
"A", "B" and "C" respectively.
2) Create a new style, name it Q, and select Bold Font.
3) Select the three cells, and select conditional formatting.
4) Add a rule with a formula $Sheet1.$B1="Q", and apply the style Q.
5) Copy and paste rows to create 4 rows of these three cells.
6) Change B3 to "Q" and notice that A3, B3 and C3 are now Bold.
7) Save this spreadsheet as an xls file (97/2000/XP/2003).
8) Open this file in Excel 2007, and observe that the Bold is not shown.
9) Set B1 to "Q", and observe that all 12 cells are now bold.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
