Bug 154477 - Color attribute set by colorscale conditional format not copied to HTML
Summary: Color attribute set by colorscale conditional format not copied to HTML
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.8.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: target:7.6.0 target:7.5.5
Keywords:
Depends on:
Blocks: Cut-Copy HTML-Paste
  Show dependency treegraph
 
Reported: 2023-03-30 13:43 UTC by Regis Perdreau
Modified: 2023-06-29 17:31 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Test file (11.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-03-30 13:43 UTC, Regis Perdreau
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Regis Perdreau 2023-03-30 13:43:20 UTC
Description:
In a Calc sheet, a range of cell are formatted with conditionnal colorscale format. When trying to copy/paste to an  HTML editor (like Thunderbird) the color is not copied.
Simple conditionnal format is working
The clipboard datas shows that there is no color attribute copied.
(in Writer, you can use HTML paste special option)

Steps to Reproduce:
1.load test-copy-colorscale.ods
2.select cells A1-A3
3. copy and paste in another application (thunderbird)
4. select cell C3
5. copy/paste in another application 

Actual Results:
Step 3 : color is not copied
Step 5 : color is copied

Expected Results:
Color is copied with every type of conditionnal format.


Reproducible: Always


User Profile Reset: No

Additional Info:
None
Comment 1 Regis Perdreau 2023-03-30 13:43:51 UTC
Created attachment 186317 [details]
Test file
Comment 2 Ezinne 2023-04-03 07:53:07 UTC
Reproducile in:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 96aad0d0497c8486f8affc8fed79e63a060c9a59
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Comment 3 ady 2023-04-03 19:24:14 UTC
STR:
1. Open attachment 186317 [details] from comment 1.
2. [CTRL]+[A]
3. [CTRL]+[C]
4. Menu File > New > HTML Document
5. [CTRL]+[V]

Note that direct formatting colors are pasted whereas conditional scale colors are not. This is unrelated to using "white" as one of the colors.
Comment 4 Commit Notification 2023-05-17 13:56:40 UTC
Henry Castro committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/fcb348da642f7e5c41fe495cf6289f9992bfa1b9

tdf#154477: sc: add "updateValues" method to conditional format list

It will be available in 7.6.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 5 Commit Notification 2023-05-17 13:57:43 UTC
Henry Castro committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/c85255fd7a62bec9342fa6f2a79d1395979d54be

tdf#154477: sc: copy cache values when clone color conditional format

It will be available in 7.6.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 6 Commit Notification 2023-05-17 13:57:45 UTC
Henry Castro committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/604c27f7c382bdd6baea73e60eed6525b9bfbd3d

tdf#154477: sc: filter: html: fix missing color scale conditional format

It will be available in 7.6.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 7 Timur 2023-05-22 08:51:49 UTC
Thanks . Let's close as Fixed.
Comment 8 Commit Notification 2023-06-29 17:30:44 UTC
Henry Castro committed a patch related to this issue.
It has been pushed to "libreoffice-7-5":

https://git.libreoffice.org/core/commit/284ac82b1af70c8734bae6eb841ae01735bb6b41

tdf#154477: sc: copy cache values when clone color conditional format

It will be available in 7.5.5.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 9 Commit Notification 2023-06-29 17:30:47 UTC
Henry Castro committed a patch related to this issue.
It has been pushed to "libreoffice-7-5":

https://git.libreoffice.org/core/commit/e4010b7d83244d9d51f36e22c9d9cd63eda870cb

tdf#154477: sc: add "updateValues" method to conditional format list

It will be available in 7.5.5.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 10 Commit Notification 2023-06-29 17:31:49 UTC
Henry Castro committed a patch related to this issue.
It has been pushed to "libreoffice-7-5":

https://git.libreoffice.org/core/commit/87d1e49f0cdbff6023bc6083a561c96192eb1eed

tdf#154477: sc: filter: html: fix missing color scale conditional format

It will be available in 7.5.5.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.