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@lists.freedesktop.org
Reporter: mula...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs