[Libreoffice-bugs] [Bug 121260] New: FILESAVE: Using "Excel A1" formula syntax in LibO Calc options results in charts losing their link to source data if the worksheet is saved in .xlsx format

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 121260
           Summary: FILESAVE: Using "Excel A1" formula syntax in LibO Calc
                    options results in charts losing their link to source
                    data if the worksheet is saved in .xlsx format
           Product: LibreOffice
           Version: 6.0.6.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mulamax at gmail.com

If the formula syntax is set to "Excel A1" and the worksheet is saved as
"Microsoft Excel 2007-2013 XML (*.xlsx)", all charts contained in the
spreadsheet lose their link to the source data: a data table is created for
them instead, preventing the user to dynamically update the chart by updating
the originally pointed cells.


Reproducibility: always

STEPS TO REPRODUCE

 - Open an empty spreadsheet and create a new chart of any type (i.e. a Line
chart). Make sure that options concerning Data Range and data series are
properly set (Series Name, Y Values, Categories, etc.)

 - Open Tools -> Options -> LibreOffice Calc -> Formula menu; In Formula
Options, set the "Formula syntax" option to "Excel A1"

 - Save the spreadsheet as "Microsoft Excel 2007-2013 XML (*.xlsx);

 - Close LibreOffice Calc;

 - Reopen in LibreOffice Calc the document just saved;

 - Right-click the chart and select "Edit" from the context menu;

 - Right click the chart again. 

Notice that "Data range" option is not present; "Data table" option is
displayed instead. The chart is not linked to the original cells anymore.

The issue has also been discussed here:
https://ask.libreoffice.org/en/question/89063/calc-replacing-all-chart-data-ranges-with-data-tables/

Kind regards,
Massimo

-- 
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/20181107/fefe79e9/attachment-0001.html>