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.
Uncheck the option Tools > Options... > LibreOffice Calc > View > Value highlighting. Not a bug for me.
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!