Apache OpenOffice (AOO) Bugzilla – Issue 89361
Adding Conditional Formatting changes cell data justification visually to Center & visually eliminates the cell's borders.
Last modified: 2013-04-11 18:08:44 UTC
Why, when applying Conditional Formatting, does the recipient cell become visually "center justified" instead of retaining the original horizontal placement as defined by the "Number Style", & the cell's borders become invisible on the screen? If it will help, I'll gladly attach the relevent areas of my spreadsheet to an email... but I don't see any way of attaching anything to this message.
Created attachment 53579 [details] Conditional Formatting Results = 2 Problems
Horizontal alignment and cell borders are preserved when conditional formatting is applied in Rev. 1458937 Win 7.