https://bugs.documentfoundation.org/show_bug.cgi?id=158870
Bug ID: 158870
Summary: Deleted/Left Out Functioality
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Chart
Assignee: [email protected]
Reporter: [email protected]
The problem is not in formatting. It was meant to be an example without actully
providing any personal information.
I have a great number of individual spreadsheets for finanancial indicies and
entities that I follow. Rather than scroll through numerous spreadsheets I I
have used the URL method to have one composite spreadsheet that has a chart for
each individual spreadsheet. I started doing that back with Sun’s Star 8 or 9.
This has worked up until sometime in 2022/23, with various versions of Star,
Apache, and LibreOffice. I am now using LibO 7.6.4.1.
The problem is that now you can neither Copy nor Create a chart that uses data
from another spread sheet. by using either URL paths or by selecting the data
from another spreadsheet.
Here are generic examples o fURL paths that have worked in the past:
Data Range ‘file:///C:/Users/User Name/Cloud Service/File
Folder/DJIAHistory.ods’#$Sheet2.$A$41:$C$79,$Sheet2.$B$1:$C$1
Data Series:
Wks Avg Name ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA
History.ods’#$Sheet2.$B$1:$B$1
x values ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA
History.ods’#$Sheet2.$A$41:$A$79
y values ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA
History.ods’#$Sheet2.$B$41:$B$79
Moving Avg Name ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA
History.ods’#$Sheet2.$C$1:$C$1
x values ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA
History.ods’#$Sheet2.$A$41:$A$79
y values ‘file:///C:/Users/User Name/Cloud Service/File Folder/DJIA
History.ods’#$Sheet2.$C$41:$C$79
Data Series:
Data Range ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ
History.ods’#$Sheet2.$A$41:$C$79,$Sheet2.$B$1:$C$1
Wks Avg Name ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ
History.ods’#$Sheet2.$B$1:$B$1
x values ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ
History.ods’#$Sheet2.$A$41:$A$79
y values ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ
History.ods’#$Sheet2.$B$41:$B$79
Moving Avg Name ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ
History.ods’#$Sheet2.$C$1:$C$1
x values ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ
History.ods’#$Sheet2.$A$41:$A$79
y values ‘file:///C:/Users/User Name/Cloud Service/File Folder/NASDAQ
History.ods’#$Sheet2.$C$41:$C$79
--
You are receiving this mail because:
You are the assignee for the bug.
