Bug 136267 - FILEOPEN XLSX index instead of content of category value in data label in column chart
Summary: FILEOPEN XLSX index instead of content of category value in data label in col...
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
6.4.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Balázs Varga
URL:
Whiteboard: target:7.1.0 target:7.0.3
Keywords: bibisected, bisected, regression
Depends on:
Blocks:
 
Reported: 2020-08-29 17:12 UTC by Regina Henschel
Modified: 2020-11-18 21:29 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
File for reproducing the bug (31.24 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-08-29 17:12 UTC, Regina Henschel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2020-08-29 17:12:02 UTC
Created attachment 164852 [details]
File for reproducing the bug

Open attached document. It contains a column chart with data label above the column, and an image of how it looks in Excel.

Error: Instead of the name as category value, the index of the item is shown.
Comment 1 Xisco Faulí 2020-09-07 09:26:42 UTC
Reproduced in

Version: 7.1.0.0.alpha0+
Build ID: 6b2eff7d69c6e14d89dd33eaa58c01d82c541266
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 2 Xisco Faulí 2020-09-07 09:43:56 UTC
Regression introduced by:

https://cgit.freedesktop.org/libreoffice/core/commit/?id=e0b0502516a10181bbd1737b93b38b2bba4c98e8

author	Balazs Varga <balazs.varga991@gmail.com>	2019-10-08 13:29:12 +0200
committer	László Németh <nemeth@numbertext.org>	2019-10-12 09:23:28 +0200
commit e0b0502516a10181bbd1737b93b38b2bba4c98e8 (patch)
tree b0571d34dcd0e87d020795c2cd4f016d0ec3b2e7
parent 2ec58f883bd4d7fe0ac1b716d1abc05cb2b16b4e (diff)
tdf#128016 Chart OOXML Import: fix duplicated category labels

Bisected with: bibisect-linux64-6.4

Adding Cc: to Balazs Varga
Comment 3 Commit Notification 2020-09-18 11:25:21 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/2d51b9fd4e7b22a21c77cff473de56ebebc5c9f2

tdf#136267 OOXML Chart Import: create main category axis labels once

It will be available in 7.1.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 4 Xisco Faulí 2020-09-29 12:47:39 UTC
Verified in

Version: 7.1.0.0.alpha0+
Build ID: cd85546a2fbdade42f80fd3b6bd650791db9f32d
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: tr-TR (en_US.UTF-8); UI: en-US
Calc: threaded

@Balázs Varga, thanks for fixing this issue!
Comment 5 Commit Notification 2020-09-29 14:55:20 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "libreoffice-7-0":

https://git.libreoffice.org/core/commit/1208b154c44a4e930fc630e062273d91b21edb0a

tdf#136267 OOXML Chart Import: create main category axis labels once

It will be available in 7.0.3.

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.