00 Votes

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?

1Best Answer1 Vote

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:

  1. First, press the CTRL key without having previously marked your chart you want to get copied.
  2. Now you click on the diagram while holding down the CTRL key. Keep the mouse button pressed and move the diagram with the mouse to the side.

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

ReplyPositive Negative

Related Topics


Question | 1 Answer

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.


Ask your own question or write your own article on askingbox.com. That’s how it’s done.