OpenOffice: Data Table instead of Data Ranges after copying a Diagram
Question by Guest | 2018-01-04 at 16:57
I have used Open Office to create a chart that gets its data directly from the table. By right-clicking on the diagram, I can select the menu item "Data Ranges" where I can define the rows and columns from which the data should come from.
Now to my problem: If I copy this diagram (even within the same sheet), OpenOffice does not take over the references to the data cells of the table. Instead, there is a new diagram created containing just the raw data, only the numbers, but no longer the reference. I also get the menu item "Data Table" instead of "Data Ranges" after copying.
Presumably that must be a bug of OpenOffice, which would give me an incredible amount of work - I have to completely rebuild my diagram now. Isn't there any way to get around this bug and copy the references with the diagram copying?
Related Topics
MySQL: Delete Data from Table - Difference between TRUNCATE, DELETE and DROP
Tutorial | 0 Comments
Units: SI Prefixes for Powers of Ten
Info | 0 Comments
SQLite: Check whether Table exists
Info | 0 Comments
MySQL: Add new Column to a Table
Tutorial | 0 Comments
XLS and XLSX: Maximum Number of Columns and Rows
Info | 2 Comments
MySQL: 3 Ways of showing Table Definition and Structure
Info | 0 Comments
Important Note
Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more.
Participate
Ask your own question or write your own article on askingbox.com. That’s how it’s done.
Unfortunately, if you copy and paste a diagram in OpenOffice using CTRL + C and CTRL + V, OpenOffice does not take the references.
But there is one way to keep the references:
This will leave the old diagram in place and push a new diagram out of the old one. This new diagram should still retain the references.
This is really a stupid and cumbersome story and as far as I know this "bug" maybe is even wanted. However, it the behavior was different in older versions of OpenOffice, as far as I now.
2018-01-05 at 16:37