Bug 49177

Summary: Add color gradient for FORMATTING cell background
Product: LibreOffice Reporter: Nino <libo2016>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: aron.budea, decepticceast, documentfoundation, f.alexander.wilms, gerry.treppel, heiko.tietze, kelemeng, libreoffice, mihhkel, rb.henschel, squeezechart, thomas.lendo
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=84267
https://bugs.documentfoundation.org/show_bug.cgi?id=31205
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 107977, 122104, 35837, 105225    
Attachments: Example gradient with Excel 2010

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)