Bug 129616 - EDITING: Support switching of data sources for charts (between Data Ranges and Data Table)
Summary: EDITING: Support switching of data sources for charts (between Data Ranges an...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
6.3.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Data
  Show dependency treegraph
 
Reported: 2019-12-25 16:37 UTC by Markus Elfring
Modified: 2021-07-27 14:36 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Markus Elfring 2019-12-25 16:37:19 UTC
Description:
I have tried the provided functionality out again together with the software combination “LibreOffice Writer 6.3.3.2-865.16”.

Steps to Reproduce:
I can create a simple chart in an empty document.

Actual Results:
A diagram is displayed based on values which can be modified by the dialogue “Data table”.
https://help.libreoffice.org/6.3/en-GB/text/schart/main0000.html

But the button “Data areas” is deactivated (greyed out) in the tool bar.

Expected Results:
I would like to choose an other data source for the chart object.

* Construct an additional table within the current document.

* Refer to an external file.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Comment 1 Oliver Grimm 2019-12-28 23:51:11 UTC
cannot reproduce here.
Markus, can you please provide the exact steps of what you did when the bug occurred? And which button (where) you wanted to press? thank you.
Comment 2 Markus Elfring 2019-12-29 09:16:11 UTC
(In reply to Oliver Grimm from comment #1)
Do you observe that the “chart edit mode” gets activated after a diagram was created based on a default data set according to the button “Insert chart” from the standard tool bar?
Which actions are supported then to switch the data sources?
Comment 3 Oliver Grimm 2019-12-29 21:58:08 UTC
okay, now I get where you are aiming at.
A reference to an external spreadsheet can be set up via Menu Insert | Object | OLE | "import from file" but I understand you are asking for a way to

1) change the data source of an existing diagram in Writer after it was created AND
2) have a diagram refer to another table object within the same writer document

Is that correct?

As a workaround you can use two external spreadsheet files where file A contains the data table and file B contains the diagram (sourcing it's data from file A). You can then insert both files via OLE into your writer document, respectively, to get any combination of data sources and diagrams.
Comment 4 Markus Elfring 2019-12-30 12:31:51 UTC
(In reply to Oliver Grimm from comment #3)
I am generally looking for ways to improve the export of information also from a chart data table (if the content was customised).
Can it become easier to convert such a table object to other data structures?
Comment 5 Dieter 2020-08-18 15:30:20 UTC
Hello Markus, a new major release of LibreOffice is available since this bug was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Comment 6 Markus Elfring 2020-08-18 16:48:09 UTC
(In reply to Dieter from comment #5)
Did you really notice any information (in the release notes) which should indicate remarkable improvements for this feature request?
Comment 7 Dieter 2020-08-18 18:23:39 UTC
(In reply to Markus Elfring from comment #6)
> (In reply to Dieter from comment #5)
> Did you really notice any information (in the release notes) which should
> indicate remarkable improvements for this feature request?

Have you ever noticed, that you doesn't reach anything with unfriendly comments?
Comment 8 Markus Elfring 2020-08-19 07:05:46 UTC
(In reply to Dieter from comment #7)
Why did you touch this issue if it can be determined that no significant progress happened here?

I hope also that corresponding improvements can be achieved for affected software components in more constructive ways.
Comment 9 Stéphane Guillou (stragu) 2021-07-27 14:36:18 UTC
Confirmed that it is not possible to switch between Data Table and Data Ranges when editing a chart in Writer. I can see how that could be useful: writer is the one component that allows both data sources.

Not sure if this bug needs UX eval?

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: cd2b5168e8ef1cb6e721bc5220421464ed723096
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-21_14:56:23
Calc: threaded