Description: Attached file contains a simple 100 percent stacked area chart with data labels, and its 3D variation. In Calc these labels appear as a ratio of the values instead of the values themselves like in Excel. This does not happen with normal and stacked area chart types. Steps to Reproduce: 1. Open attached file Actual Results: Data labels appear as 0.33 and 0.67 instead of 2 and 4. Expected Results: Data labels formatted as values. Reproducible: Always User Profile Reset: No Additional Info: LibreOffice details: Verzió: 6.5.0.0.alpha0+ (x64) Build az.: 7e09d08807b5ba2fd8b9831557752a415bdad562 CPU szálak: 4; OS: Windows 6.3 Build 9600; Felületmegjelenítés: alapértelmezett; VCL: win; Területi beállítások: hu-HU (hu_HU); Felület nyelve: hu-HU Calc: CL Also happens in: Verzió: 4.1.0.4 Build az.: 89ea49ddacd9aa532507cbf852f2bb22b1ace28
Created attachment 156287 [details] Example file from Excel
Created attachment 156288 [details] Screenshot of the original document side by side in Excel and Calc
Reproduced in Version: 6.5.0.0.alpha0+ Build ID: 8f7010eb47119a2428b77f5d79fc8577d9914958 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded
I can confirm the bug present in Version: 6.4.0.0.alpha1+ (x86) Build ID: ec7374ff84c71edfbb30d6e4dc5b486b6df7107f CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-11-10_21:37:30 Locale: en-US (en_US); UI-Language: en-US Calc: threaded and in LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e57d90cd4e51a1353eafc87bb29cfe6076704a7c tdf#129173 tdf#129175 Fix number format of data labels It will be available in 6.5.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.
Verified in Version: 6.5.0.0.alpha0+ Build ID: f86824cca0c442d371379d2ea0bff2241f18ab3d CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded @Balazs, thanks for fixing this issue!
Balazs Varga committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/9c1063ba13028244346528e307d5563d6faf949d tdf#129173 tdf#129175 Fix number format of data labels It will be available in 6.4.0.1. 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.
Balazs Varga committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/commit/d979eb16b9144c7ed230d7b0a4d0c1474664d7d0 tdf#129173 tdf#129175 Fix number format of data labels It will be available in 6.3.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.
Xisco Faulí committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/commit/2af4d304992d2a508e0d79cd855b93ca7559ebef tdf#131291: Revert "tdf#129173 tdf#129175 Fix number format of data labels" It will be available in 6.3.6. 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.