[Libreoffice-bugs] [Bug 111819] New: Chart Linkage

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 111819
           Summary: Chart Linkage
           Product: LibreOffice
           Version: 5.4.0.3 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dbondo1 at gmail.com

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?

-- 
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/20170815/f97712c7/attachment.html>