But chart usually generated form Calc.

(In reply to comment #1)
> But chart usually generated form Calc.

Hi!

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

Thank you!

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.

Best regards!

(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...

Removing "in Writer documents" from the title as it is relevant to any component that makes use of chart data tables (Writer, Impress, Draw).

Still not possible to do this in current master:

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 1dd4a80fa076bedb3a82821517036bad8dd79857
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-07-26_22:41:19
Calc: threaded

Hi, I am joining the group begging for a solution to this problem, which is really annoying for people creating a lot of charts for presentations.
When you go back to your previous presentations all charts are detached from their original calc source, chart data can be viewed but not used again in any way, unless you remember exactly from which spreadsheet it originated, or you are prepared to rewrite manually all and each figure.
It would suffice to activate standard selection/copy functions on the table displaying numbers.

Created attachment 197024 [details]
Chart Data Table has limited functionality (not as Calc) [LO24.8.2.1]

1) Open attachment 57027 [details]
2) Select chart
3) Right click → E̲dit
4) Right click on chart area -> D̲ata table...

(https://yaytext.com/underline/)



Still, we cannot manage more than one cell at once (as is also illustrated in the bug 81514). It would be great for this Chart Data Table to work as an embedded Calc spreadsheet instance.

Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: pl-PL (pl_PL); UI: en-US
Calc: CL threaded

As a workaround I sometimes embed or link a spreadseeh as an OLE object. Showing exectly what you want is a bit convoluted and ot has other drawbacks, but in some cases it is the best option.

Created attachment 197028 [details]
Writer document showing a Calc chart embedded as an OLE object.

The first chart is pasted from the spreadsheet as a standard chart object, and it shows a bug where numbers are formatted as dates, but that is out of scope here. The second chart is actually a Calc document embedded as an OLE object.