It would be very, very great improvement to the Chart component, if it would be possible to extract somehow Chart data tables to use them separately as tables, like to add data, to do some calculations etc. Alternative option is to use separate spreadsheets to store charts, but it is not at all a good and efficient way to work.
But chart usually generated form Calc.
(In reply to comment #1)
> But chart usually generated form Calc.
Initially yes, but then I have to keep 2 files to have access to data. And these files have to be harmonised, which is more complicated than to work with a single set of data. Sometimes those spreadsheet files gets lost and it is another problem.
It is also impossible to export charts in writer to .doc format so it is very convenient to be able to export data before saving charts as pictures so that they can be accessed somehow also in .doc files.
I don't know if the function is so complicated to implement, but it is what users of ms word are expected to see in charts. I'm away from ms word for some 8 years, but I still feel lack of this and some other functions, like paste calc table into writer table, which was recently implemented as extension.
Created attachment 57027 [details]
odt file containging chart (diagram)
Thanks for explanations! Indeed, with exporting is some problem, especially to docx format.
odt file contains content of initial table, so I not see problem to create such function, IMHO even on Basic my be possible.
> paste calc table into writer table, which was recently implemented as extension
this extension was inside of OpenOffice installation or separately installed?
Separately installed, it is available here http://extensions.services.openoffice.org/en/project/pasteasvalue
One of the most welcome extensions for me :)
> this extension was inside of OpenOffice installation or separately installed?
Created attachment 57030 [details]
Sample doc file to extract data from the datatable
Sample file to show, how data can be extracted from a .doc file (office version - 2003). Ms word chart allow to copy / paste chart datatable as tab separated text, which can be easily transformed into table. I don't have newer versions of ms office, so may be there the system is different.
Thanks for information
Following to this. Another useful function would be ability to paste list of values into the writer chart datatable instead of rewriting values one by one, if changes are necessary.
It is useful also if charts in writer have different formatting characteristics (fonts etc.) than in original calc file. It would take less time to copy/paste data in case of changes instead of pasting chart from calc with following changes of formatting elements in chart, starting with the anchoring.
some workaround for extracting data in Bug 42243
It is really not the easiest way; however, it is solution for large charts. It might be a bit tricky to find right object folder if there are some tens of charts and they are not entered in the same order as they are in document :)
> might be a bit tricky to find right object folder
When we in newly extracted folder, there may be folders Thumbnails and ObjectReplacements. Open contents of folder Thumbnails in picture viewer or drag and drop files from folder ObjectReplacements into LibreDraw.
Created attachment 70581 [details]
Basic macro, which extract data from selected diagram into new spreadsheet
I have created simple Basic macro which extracts data from selected diagram into new Calc spreadsheet.
(Works only if document contains real chart, not an EMF image of chart)
Thank you very much for excellent work!!!
I tried the macro on several charts and it worked in all cases. It will be really useful extension to the Libreoffice.
(In reply to comment #12)
> Created attachment 70581 [details]
> Basic macro, which extract data from selected diagram into new spreadsheet
> I have created simple Basic macro which extracts data from selected diagram
> into new Calc spreadsheet.
> (Works only if document contains real chart, not an EMF image of chart)
This issue is abandoned for several years, but probably there is possibility to implement this macro into an extension or Libreoffice code. This would be really great addition.
God unbelievable this is abandoned. Extracting data from a chart saved in a file which is not a Calc sheet (writer or impress) is a nightmare, and it shouldn't be. Please help anybody who can do something...