Bug 56678 - conditional formatting justification wrong for xlsx file
Summary: conditional formatting justification wrong for xlsx file
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.3.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-11-02 12:15 UTC by jkonecny
Modified: 2014-06-28 07:37 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
screen shot (252.81 KB, image/jpeg)
2012-11-02 12:16 UTC, jkonecny 		Details
original file (124.95 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-11-02 12:16 UTC, jkonecny 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description jkonecny 2012-11-02 12:15:37 UTC 
I have an xlsx file opened under 3.6.3.2 and the conditional formatting appears to incorrectly justify the cell contents.  I have attached a screen shot with the problem circled and the original file.
Comment 1 jkonecny 2012-11-02 12:16:00 UTC 
Created attachment 69440 [details]
screen shot
Comment 2 jkonecny 2012-11-02 12:16:26 UTC 
Created attachment 69441 [details]
original file
Comment 3 Jean-Baptiste Faure 2012-11-02 12:42:01 UTC 
The style ConditionalStyle_3 applied by the conditional formatting does not say that values in the cell must be center aligned. What this style says in MSO ?

Best regards. JBF
Comment 4 jkonecny 2012-11-02 12:58:54 UTC 
I would have to assume is says to center justify since that is what it does however I am only able to look at it with ms excel viewer.  I may have to download mso to check for sure unless someone else reading here has it.
Comment 5 jkonecny 2012-11-02 13:01:25 UTC 
Perhaps the cells are center justified and the conditional formatting is overriding it?
Comment 6 jkonecny 2012-11-02 13:05:07 UTC 
I just checked the cell format and the alignment is set to "center".  The conditional formatting specifies "default".  I would expect that to leave the cell alignment as it was.  Apparently that is what excel is doing.
Comment 7 ign_christian 2013-07-19 09:36:24 UTC 
I can confirm this behavior with LO 4.0.4.2 (Win7 32bit). 

Similar with Bug 49572:
Excel made style, which is applied on conditional formatting, replaced with "ConditionalStyle_X" by LO.
In that "ConditionalStyle_X" we see 'Default' horizontal allignment which should center (in Excel) but shown right alligned in LO.

Bug 65072: looks like similar issue with different problem (fonts)

Perhaps also related to filesave problem in Bug 59346 & Bug 65371 (if saving as XLSX)
Comment 8 ign_christian 2014-06-28 07:37:07 UTC 
Problem gone in LO 4.2.5.2 and 4.3.0.1 - Ubuntu 12.04 x86.