[Libreoffice-bugs] [Bug 142346] New: FILEOPEN XLSX Chart with complex axis labels opens incorrectly if “Range for Name” value is fixed text

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 142346
           Summary: FILEOPEN XLSX Chart with complex axis labels opens
                    incorrectly if “Range for Name” value is fixed text
           Product: LibreOffice
           Version: 3.6.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: bibisectRequest, filter:xlsx, regression
          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 172119
  --> https://bugs.documentfoundation.org/attachment.cgi?id=172119&action=edit
Example file from Excel

Attached user made document contains two similar line charts with complex axis
labels.
The main difference between them is that the top ones data series have their
name defined as a static string “Nth quarter” while the bottom ones data series
have their name defined as a cell reference.

The top ones axis label is completely garbled with the last year number and all
quarter numbers visible in a single vertical “cell” of the complex axis label.
The bottom one looks fine with the same data.

Changing the “Range for Name” values from the static string to a cell reference
fixes the display of the top chart.

Steps to reproduce:
    1. Open attached document

Actual results:
Top charts X-axis label is unreadable.

Expected results:
Top charts X-axis label should look like the bottom ones with year numbers and
quarter numbers.

LibreOffice details:
Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 91330c503b7eb91d777978018b66890af87cf8f5
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

Also in: 7.0, 6.0, 5.0, 4.0, 3.6
But not yet in 3.5.


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/20210518/f1e95a1d/attachment.htm>