Bug 44976 - conditional formatting breaks text allignment on .xlsx
Summary: conditional formatting breaks text allignment on .xlsx
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 Beta3
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-01-20 02:59 UTC by Nick
Modified: 2015-01-29 10:58 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Attachments
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 Nick 2012-01-20 02:59:27 UTC 
able to reproduce in LO 3.4.5 and LOdev 3.5.0beta3+ Build ID: e85bf5d-9eed775-d06f752

To reproduce:
Open a new Spreadsheet and save it as .xlsx
Save and close it
Open it with LO
Center text for Cell A1
Conditional format for Cell A1 (if equal to "test") change background color
type in test in Cell A1
A1 text is now left aligned even though centered is selected
Comment 1 sasha.libreoffice 2012-05-08 05:55:57 UTC 
Thanks for bugreport
Please, verify if in last version of LibreOffice still reproducible
Comment 2 Nick 2012-05-25 02:23:36 UTC 
Bug is still showing on version 3.6.0alpha0+ (Build ID: 4.0)
Comment 3 sasha.libreoffice 2012-05-25 02:26:26 UTC 
Thanks for additional testing
Comment 4 bfoman (inactive) 2012-07-13 07:26:00 UTC 
Confirmed with:
LO 3.5.5.3 
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit
Comment 5 GerardF 2012-07-14 07:10:48 UTC 
Is it really a bug ?
New style with background color depends on default style which is left align for strings.
Comment 6 GerardF 2012-07-14 07:14:46 UTC 
Forget what I say above. "test" is centered in .ods
Comment 7 QA Administrators 2015-01-05 17:52:37 UTC 
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of LibreOffice (4.3.5 or later): https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)

Thank you for your help!

-- The LibreOffice QA Team
Comment 8 Buovjaga 2015-01-29 10:58:44 UTC 
No problem with centering anymore -> WFM.

Win 7 Pro 64-bit Version: 4.5.0.0.alpha0+
Build ID: 784d069cc1d9f1d6e6a4e543a278376ab483d1eb
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-25_23:07:36