Bug 49177 - Add color gradient for FORMATTING cell background
Summary: Add color gradient for FORMATTING cell background
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 80039 83670 121202 138469 (view as bug list)
Depends on:
Blocks: Calc-Enhancements 122104 35837 105225
  Show dependency treegraph
 
Reported: 2012-04-26 09:13 UTC by Nino
Modified: 2023-11-09 09:56 UTC (History)
12 users (show)

See Also:
Crash report or crash signature:


Attachments
Example gradient with Excel 2010 (10.18 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-10-16 03:07 UTC, Thomas Arnhold
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nino 2012-04-26 09:13:22 UTC
see also Bug 46029, Bug 35837
Comment 1 Thomas Arnhold 2013-10-16 03:07:18 UTC
Created attachment 87710 [details]
Example gradient with Excel 2010
Comment 2 Thomas Arnhold 2013-10-16 03:08:59 UTC
Currently the cell background could only be set to a solid color. The idea is to extend this to gradients.
Comment 3 ign_christian 2014-09-09 14:59:26 UTC
*** Bug 83670 has been marked as a duplicate of this bug. ***
Comment 4 Thomas Lendo 2017-05-23 07:54:51 UTC
This should be fixed with Bug 105225 - Color palette cannot be chosen in various places
Comment 5 Heiko Tietze 2018-02-20 16:25:56 UTC
Question is whether the file format allows gradients. And if that is the case we should go ahead for compatibility. Otherwise I would say out of scope for Calc.
Comment 6 Xisco Faulí 2018-11-07 16:21:05 UTC
*** Bug 121202 has been marked as a duplicate of this bug. ***
Comment 7 NISZ LibreOffice Team 2020-07-21 08:48:06 UTC
*** Bug 80039 has been marked as a duplicate of this bug. ***
Comment 8 Ming Hua 2020-11-24 20:16:40 UTC
*** Bug 138469 has been marked as a duplicate of this bug. ***
Comment 9 Regina Henschel 2021-04-25 12:34:29 UTC
(In reply to Heiko Tietze from comment #5)
> Question is whether the file format allows gradients. And if that is the
> case we should go ahead for compatibility. Otherwise I would say out of
> scope for Calc.

The current ODF 1.3 does not allow gradients for single cells and not for whole tables. That is the same for tables in Writer as for tables in Calc. So who wants to work on this, needs to come up with a concept, how to extend the file format, ideally before starting to implement something.
Comment 10 Lucas J 2021-09-22 04:34:34 UTC
See documented attempt at implementing this feature (for any devs who want a head start): https://www.patreon.com/posts/bug-49177-color-50095922
This provides some insight into what's going on here.
Comment 11 Ryan70 2023-04-03 07:29:37 UTC Comment hidden (spam)
Comment 12 Shoaib 2023-05-29 15:12:17 UTC Comment hidden (spam)
Comment 14 Tool370 2023-07-24 18:31:04 UTC Comment hidden (spam)
Comment 15 Shoaib 2023-07-31 14:48:40 UTC Comment hidden (spam)
Comment 16 Shoaib 2023-07-31 14:50:06 UTC Comment hidden (spam)
Comment 17 Shoaib 2023-07-31 14:52:19 UTC Comment hidden (spam)
Comment 18 Shoaib 2023-07-31 14:52:56 UTC Comment hidden (spam)
Comment 19 Regina Henschel 2023-07-31 15:13:30 UTC
The problem is handled in https://issues.oasis-open.org/browse/OFFICE-4125
and its resolution in the draft of ODF 1.4.
https://github.com/oasis-tcs/odf-tc/tree/master/docs/odf1.4/part3-schema
Comment 20 Stéphane Guillou (stragu) 2023-07-31 16:54:23 UTC
(In reply to Regina Henschel from comment #19)
> The problem is handled in https://issues.oasis-open.org/browse/OFFICE-4125
> and its resolution in the draft of ODF 1.4.
> https://github.com/oasis-tcs/odf-tc/tree/master/docs/odf1.4/part3-schema

Thanks Regina.
And I guess this also benefits bug 31205 (Calc) and bug 70384 (Writer) because it includes draw:fill-hatch-name ?
Comment 21 Regina Henschel 2023-07-31 17:39:47 UTC
(In reply to Stéphane Guillou (stragu) from comment #20)

> Thanks Regina.
> And I guess this also benefits bug 31205 (Calc) and bug 70384 (Writer)
> because it includes draw:fill-hatch-name ?

Yes, in ODF 1.4, all places where in ODF 1.3 an background-image is usable will allow all kind of the background fills we know from shapes. Those places include page, header, footer, paragraph, section, table cell, table row and table.

For page, header, footer and paragraph it is currently written in extended mode as <loext:graphic-properties> element as child of <style:style> element. In ODF 1.4 it will be a new <style:background-fill> element as child element of <style:paragraph-properties> or of <style:table-cell-properties>, for example.
Comment 22 Shoaib Jom 2023-10-06 20:37:31 UTC Comment hidden (spam)
Comment 23 rimi sen 2023-10-28 07:35:26 UTC Comment hidden (spam)
Comment 24 leoandress69 2023-11-09 09:11:57 UTC Comment hidden (spam)