[Libreoffice-bugs] [Bug 144794] New: FILEOPEN XLSX Chart axis labels are rotated in multiple categories and partial secondary data series

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144794

            Bug ID: 144794
           Summary: FILEOPEN XLSX Chart axis labels are rotated in
                    multiple categories and partial secondary data series
           Product: LibreOffice
           Version: 5.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: bibisectRequest, filter:xlsx, implementationError
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org, varga.balazs3 at nisz.hu
            Blocks: 75057

Created attachment 175353
  --> https://bugs.documentfoundation.org/attachment.cgi?id=175353&action=edit
Example file from Excel

Attached example file was made in Excel and contains charts with multiple
categories.
The charts on the right have an automatic label rotation, which means the roman
quarter labels and the years are horizontal in Excel.
In Calc however if the data range is only partially covering the primary
category with secondary data points, i.e. there is only one secondary data
point for the last “2009” item in the data range, the labels are rotated.
This does not happen if the data range fully covers the primary data point,
even if there are no actual values filled in.

Steps to reproduce:
    1. Open attached document in Excel and Calc

Actual results:
The quarter labels are rotated 270 degrees on the “Axis rotation: empty” titled
charts: a combined bar+line chart on top and a bar chart at the bottom.
This does not happen for the right side charts that differ only in the size of
the data range.

Expected results:
The quarter labels of the secondary data series are not rotated in any case.

LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: b60b6bfaafa1315e07108dba50f016975b619c59
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

Also in 7.0, 6.0 - 5.4 (although these rotated the years too), 5.3 and before
did not show the secondary labels at all for these charts.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=75057
[Bug 75057] [META] OOXML Chart object issues
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210929/72cc4c2a/attachment.htm>