Star Office 9 had the capability of copying a Calc chart from one spreadsheet and pasting it into another spreadsheet as an OLE object, if one pasted it Paste Special as a “Star Object Descriptor (XML)”.

Using Data Ranges such as these(in the Data Range Fields) without the =:

Name: = ‘file:///C:/Users/<user name>/Dropbox/Fund%20Data/39Wk%20Avgs/DJIA%20History.ods'#$Sheet2.$B$1

x Value = 'file:///C:/Users/<user name>/Dropbox/Fund%20Data/39Wk%20Avgs/DJIA%20History.ods'#$Sheet2.$A$41:$A$79

y Value = 'file:///C:/Users/<user name>/Dropbox/Fund%20Data/39Wk%20Avgs/DJIA%20History.ods'#$Sheet2.$B$41:$B$79

The Chart could be linked to the original chart and updated when the original chart was updated.

Both Apache OpenOffice and LibreOffice have lost this capability and now covert Data Range to Data Table.

I had been using this capability In Open Office to place as many as 20+ charts in one spreadsheet 

Back in March I shifted from OO to LO and ran into some problems with my spreadsheet containing multiple linked charts when I needed to edit one or add another.  LO changed Data Ranges  to Data Tables.  I have been working to get my multiple linked charts spreadsheet back.

I’m not a programmer, but I finally got a working spreadsheet that contains 17 charts linked to their original charts in 17 different spreadsheets.  To do so I had to revert  a system that used 32 bit Windows 7 and only Star Office 9.x and had no traces of any later versions of OO or LO.

As of this writing LO has not changed my Data Ranges to Data Tables. This new spreadsheet has some idiosyncrasies when opened  in LO.   One is that LO gets a consistent Save or Save As error in that it states that the file could not be written,   Another is that the Data Series Range cannot be entered as it was in the old Star Office sheet, nor does it seem to be needed at all in LO.  Another is that The Data series Names don’t reflect  the names in the original charts.  I have also found that one of the linked charts will not display the x data and dates correctly (it keeps trying to start around the year 1899).

I would like to provide my work to to someone in development who could figure out how to program this capability back into LO.  From what I’ve read, it appears that Excel has this capability to link charts in one worksheet to data in charts in different worksheets.

If I provide the linked charts spreadsheet, it can only be viewed and worked on in SO 9 Update 2,  If opened in LO the links gett destroyed and replaced by Data Tables.

Having multiple linked charts is a very useful capability that should not have been eliminated.

How do I get this capability elimination problem reviewed and worked on?