Description: In a document created in MS Excel, the colour scale changes after opening in writer. Steps to Reproduce: 1. Open attached file in Calc. 2. Compare the file opened in Excel. Actual Results: The colour scale changed. Expected Results: The colour scale is not changed. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 6f1534940ac12ff8e46f4782e18cfb6cf585da39 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: CL threaded
Created attachment 187288 [details] Sample file
Created attachment 187289 [details] Compaire the problem Writer and Excel
Also reproduced in Version: 7.3.0.0.alpha1+ / LibreOffice Community Build ID: 229123ccc6f90ebf66b3e659bebbd53f8a9bdd3a CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded
This is a difference in the visualization of the percentile values: LibreOffice chooses the lowest color, MSO the highest one from the possible values. See the second test file: middle cells are yellow in LibreOffice, and light green in MSO.
Created attachment 187527 [details] More percentile values
(In reply to László Németh from comment #4) > This is a difference in the visualization of the percentile values: > LibreOffice chooses the lowest color, MSO the highest one from the possible > values. See the second test file: middle cells are yellow in LibreOffice, > and light green in MSO. Also yellow in Google Docs.
(In reply to László Németh from comment #6) > (In reply to László Németh from comment #4) > > This is a difference in the visualization of the percentile values: > > LibreOffice chooses the lowest color, MSO the highest one from the possible > > values. See the second test file: middle cells are yellow in LibreOffice, > > and light green in MSO. > > Also yellow in Google Docs. But not the original file. It seems, Google Sheets uses the end of the color scale in the case of the last repeating percentile value, so it's OK to do only that in Calc, as the proposed fix does in https://gerrit.libreoffice.org/c/core/+/152117 @Tibor: many thanks for the fix!
Created attachment 187617 [details] Same colors in Google Sheets
Created attachment 187618 [details] But not for the non-terminating repeating values Yellow are light green in MSO.
Tibor Nagy committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6a059f8d1b0a7a5b64bd272e1e7b8291979bcd56 tdf#155321 sc: fix color of the highest value on percentile color scale 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.
Tibor, thanks for fixing this. Green in Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: d7d2b172065f90aa2f61c0216f3722e868ae76a1 CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded Yellow in (tested for reference) Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Tibor Nagy committed a patch related to this issue. It has been pushed to "libreoffice-7-5": https://git.libreoffice.org/core/commit/808cc62e2f43e638598fc1f4869735138ccf8217 tdf#155321 sc: fix color of the highest value on percentile color scale 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.