Bug 42171 - FORMATTING: Setting font colour does not work. Found similar issue in Internet, but no fix
Summary: FORMATTING: Setting font colour does not work. Found similar issue in Interne...
Status: VERIFIED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.3.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-24 13:33 UTC by Andrey
Modified: 2019-03-06 08:25 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
Calc file sample with some formatting set (10.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-10-24 13:33 UTC, Andrey
Details

Description Andrey 2011-10-24 13:33:37 UTC
Created attachment 52705 [details]
Calc file sample with some formatting set

Problem description: 
When I try to change font colour (foreground) - via combo-box on toolbar or via "Format Cells" selected colour does not apply. Backgroud colour setting is working, but foreground NOT.
Similar case found at http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=32425, but with exception workaround with new sheet not working. 
The right colour is displayed for cell value only while editing the text, after pressing Enter - font again - Automatic black colour.

Some old files (Excel format) shows with proper formatting.
I had this bug in OpenOffice, changed to LibreOffice, but having the same problem. I have Windows 7 Pro, 64-bit version.
On other notebook with Windows XP (32bit) - OpenOffice (and I suppose LibreOffice too, but not tested) all working as expected.
Setting Deafult Formatting and then change colour - also not working.

Steps to reproduce:
1. enter text in cell
2. change colour (foreground)
3. font color not changed - remained Black (or Green (formula) or Blue for numbers with Currency format applied))

Current behavior:
font colour not changed

Expected behavior:
font colour should change according to selection.

Platform (if different from the browser): 
Windows 7, 64-bit, Service Pack 1 + small fixes.
Comment 1 vitriol 2011-10-24 13:44:14 UTC
Uncheck the option Tools > Options... > LibreOffice Calc >  View > Value highlighting. Not a bug for me.
Comment 2 Andrey 2011-10-24 22:15:07 UTC
Thanks a lot - this helped!

But, my opinion - such "highlighting" should not be applied to cell with custom formatting, at least for simple text (not formula, not conditional formatting).

anyway - thanks once more!


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.