Download it now!
Bug 49343 - failure to apply named font colour specified in file
Summary: failure to apply named font colour specified in file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: ODF-import
  Show dependency treegraph
Reported: 2012-05-01 08:49 UTC by Andreas J Guelzow
Modified: 2019-05-13 11:42 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

sample file (5.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-05-01 08:49 UTC, Andreas J Guelzow
colour_lots_for_black (17.82 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-05-13 11:39 UTC, Stéphane Aulery

Note You need to log in before you can comment on or make changes to this bug.
Description Andreas J Guelzow 2012-05-01 08:49:54 UTC
Created attachment 60854 [details]
sample file

In the attached file in cell A1 we have the string "abc":

in content.xml
<table:table-cell table:style-name="Gnumeric-default" office:value-type="string">
<text:p>a<text:span text:style-name="NS-colour-ff0000">b</text:span>c</text:p>

The style-name "NS-colour-ff0000" refers to the named style given in styles.xml:

<style:style style:name="NS-colour-ff0000" style:family="text" style:display-name="Font Color #ff0000">
      <style:text-properties fo:color="#ff0000"/>

This should cause the "b" in A1 to be red, but it shows as regular black.
Comment 1 Buovjaga 2014-11-09 19:28:13 UTC

Win 7 64-bit Version:
Build ID: 9229170920ab770624415c4330da57af5b1b5398
TinderBox: Win-x86@39, Branch:master, Time: 2014-11-09_03:16:43
Comment 2 QA Administrators 2015-12-20 16:07:31 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2017-01-03 19:46:28 UTC Comment hidden (obsolete)
Comment 4 Andreas J Guelzow 2017-01-03 20:37:45 UTC
As a developer of a different ODF producing and consuming application I used to file bugs on LO to assist in interoperability. I have since grasp that LO maintainers appear not interested in such interoperability and have stopped filing these bugs. 

So I really do not care what you do with these bugs.
Comment 5 Buovjaga 2017-01-03 20:56:38 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2018-07-24 02:36:54 UTC Comment hidden (obsolete)
Comment 7 Stéphane Aulery 2019-05-13 11:39:19 UTC
Created attachment 151356 [details]
Comment 8 Stéphane Aulery 2019-05-13 11:40:27 UTC
Comment on attachment 151356 [details]

Attached with debian bug #907644

the attached Calc file was created and saved with Windows Openoffice
4.1.3.  It displays normally when read under Linux with Gnumeric

When read with Libreoffice, cells in C3:C30, whose text colour is Red4,
are displayed with black text, and cells in C31:C41, whose text colour
in #0084D1, are likewise displayed in black.

The correct text colour is reported when looking at the cell properties.
Comment 9 Stéphane Aulery 2019-05-13 11:42:41 UTC
So this bug is reproduced with LO 6.1.1 on Debian.