Plot with Linked Data Ereases Data Points when Unable to Find Linked Data

[thelonekiddo]

In LibreOffice, the behavior of charts that rely on external linked data (from another xls/xlsx file) differs from Microsoft Office and MacOS Numbers. If the linked dataset cannot be found, LibreOffice clears the data points from the chart by default whereas Microsoft office and Numbers will still show the last plotted data on the chart.

Is there anyway to get LibreOffice to behave the way that Microsoft Office or Numbers behave?

OS: Ubuntu:22.04
LO: LibreOffice_24.8.2

[thelonekiddo]

This post is close to the same thing I was asking for, but it doesn’t look like there was any solution 4 years ago. At least not posted to the one who asked the question.

When I open O365 excel file in libreoffice and linked excel are not available it does not show cached data

Hello, I am almost new on LO and I am trying to work basically with it and get rid of O365 excel, I have noticed that when I open any spreadsheet that contains external link to another spreadsheet it does not show the last saved data from the external excel file .External excel file is not available on target computer since i am trying to use Main excel file on another computer. Ex: PC A: Main.xlsx file has below files linked: data1.xlxs and data2.xlxs If I open Main.xlsx from O365 Excel…

[Wanderer]

@thelonekiddo

At least not posted to the one who asked the question.

May I suggest a feature request at bugzilla, according to
“Feature requests should go directly to Bugzilla as Enhancements”
https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&bug_severity=enhancement