[Libreoffice-bugs] [Bug 143623] New: FILESAVE XLSX Named range as chart data source not saved

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 143623
           Summary: FILESAVE XLSX Named range as chart data source not
                    saved
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          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 173970
  --> https://bugs.documentfoundation.org/attachment.cgi?id=173970&action=edit
Example file from Excel

This is followup to bug 64086
Attached file contains a chart with named ranges used to specify its data
ranges.
These are imported incorrectly and when saved to XLSX with Calc the named
ranges are not used as the charts data ranges.

Steps to reproduce:
    1. Open attached document
    2. Save as XLSX
    3. Reopen the file in Excel

Actual results:
The chart has incorrect data ranges set.
As a result the X axis labels change from a, b, c, d to 1, 2, 3, 4.
Changing the data in A2:A6 or B2:B6 has no effect on the chart display.

Expected results:
The data ranges of the chart should refer to the named ranges.
Changing the data in A2:A6 or B2:B6 should have an effect on the chart display.

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


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/20210730/b13be165/attachment-0001.htm>