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)
Version:
(earliest affected)
3.4.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: ODF-import
  Show dependency treegraph
 
Reported: 2012-05-01 08:49 UTC by Andreas J Guelzow
Modified: 2025-04-28 22:58 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


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

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>
</table:table-cell>

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"/>
</style:style>

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
Confirmed.

Win 7 64-bit Version: 4.4.0.0.alpha2+
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
(In reply to Andreas J Guelzow from comment #4)
> 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.

Your grasping is an error. It is simply a question of the amount of developers vs. amount of bugs.

See the graph for NEW bugs: https://bugs.documentfoundation.org/reports.cgi?product_id=109&datasets=NEW

If you subtract the couple of thousand feature requests and the several hundred meta bugs + easy hacks, you get somewhere between 8000-9000 bugs.

As we get something like 600-900 reports pouring in per month, the situation CANNOT be because of "interest".

So please continue filing the interop bugs.

I understand you are annoyed by the mass pinging comments, but they do have the intended effect of cleaning the bug tracker. Every time there are many reports turning out to be WORKSFORME (fixed without knowing the fixing commit, possibly duplicates).

Note that you can set an email filter that looks for the text MassPing-UntouchedBug in the body of the email and throws it straight into the trash can.

I do confirm the original report with a fresh master build.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: fc0d4e6bc43d5f982452df07930f5ecf5927ad22
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on December 31st 2016
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]
colour_lots_for_black
Comment 8 Stéphane Aulery 2019-05-13 11:40:27 UTC
Comment on attachment 151356 [details]
colour_lots_for_black

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
1.12.41.

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.
Comment 10 QA Administrators 2021-05-13 03:58:25 UTC Comment hidden (obsolete)
Comment 11 QA Administrators 2023-12-05 03:16:36 UTC Comment hidden (obsolete)
Comment 12 Eyal Rozenberg 2025-04-28 22:58:50 UTC
Bug still manifests with:

Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-IL (en_IL); UI: en-US
Calc: CL threaded

(In reply to Andreas J Guelzow from comment #4)

Hello Andreas,

I know this comment comes after several years of silence, but:

* Is the attached sample file a valid ODF 1.0 document? If not, then what version of the spec does it adhere to?

> 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. 

That's too bad to here, even if it's 8 years later... have you tried getting in touch with the LO Project's Engineering Steering Council about interoprability with gnumeric and in general?