Ask Your Question
2

How do I change the source data range for duplicated charts in Calc 3.5? [closed]

asked 2012-07-21 09:11:56 +0200

Mary P. gravatar image

updated 2015-09-02 01:45:14 +0200

Alex Kemp gravatar image

I have been using StarOffice/OpenOffice/LibreOffice since the 1990s and have enthusiastically promoted it to friends and colleagues. So, this weekend I decided to upgrade from OO 3.1 to 3.4 and then install LO for the first time (3.5) on this particular machine. This proved a mistake.

I use Calc very heavily and am currently doing a project that requires the production of line-graph after line-graph with data from a detrended correspondence analysis. My normal m.o. is to copy a sheet with all the data and the chart onto another sheet or spreadsheet and then insert the new data in the range the graph refers to or right-click on the active chart and then select Data Ranges and manually change the reference if the data already exist elsewhere. In 3.1, this automatically redraws the chart with the new data and I move speedily on to the next one.

In both OO 3.4 and LO 3.5, the copied graph cannot be redirected to different data. On right-clicking, you no longer get the Data Ranges option but a new Data Table option. Mind you, the Data Table is a nice addition, akin to the attribute tables in a GIS, allowing case by case change of particular records.

It is, however, utterly useless for the kind of mass-production graphing I'm doing, and it should never have been SUBSTITUTED for the Data Range function but ADDED to the choices available on right-clicking an active chart. There is no way to copy the desired data into the Data Table: All the data appear in the first cell. I have been unable to find any way to get around this. With an active chart, I looked under Format and found Data Table, but it's greyed out and inaccessible.

I found a very clumsy stopgap measure: copying sheets but then entering new data in the ORIGINAL sheet/chart. This is suboptimal, as I am facing trying to put several dozen sheets within one workbook, instead of dividing all this into several workbooks, each with maybe half a dozen sheets (especially since these are large databases with intensive computations in each cell). Another option would be to redesign each chart from scratch for each sheet of data, but that is extremely time-consuming as these are pretty elaborate, non-default charts.

So, I really do not think LO 3.5 and OO 3.4 are ready for the real world of number crunching, and I am just terribly disappointed in what had been, until now, just about my favorite software suite and propaganda project.

This is such an obvious error and it reflects the disconnect between actual statisticians/end-users who do not have the technical capacity to design software and the software authors who are computer scientists or programmers not statisticians or normal end-users and have no way of imagining what people are actually doing with the s/w.

Mary Palomar

PS: Where can I find a download link to ... (more)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-28 20:21:34.452613

5 Answers

Sort by » oldest newest most voted
1

answered 2013-02-06 06:38:22 +0200

Marcel gravatar image

Hi Mary

I've had the same problem. Trying to create blank template multi-sheets with a couple of charts on each. Just kept getting the same "date table" glitch on each new sheet. I tried several other packages without any luck until I d/led the lastest Libre 3.6.5.2. Hooray! It works just as we'd expect it to. Files seem to port back to O.o and work fine there now.

edit flag offensive delete link more

Comments

@Mary P. -- Does the latest release of LibreOffice still exhibit the same problem? Please let us know!

qubit gravatar imagequbit ( 2013-03-10 04:18:34 +0200 )edit

I can confirm that the sheet copy problem is fixed as of version 4.3.7~rc2-0ubuntu1~precise1. I tested this on Ubuntu 12.04.

jdpipe gravatar imagejdpipe ( 2016-01-07 04:08:10 +0200 )edit
1

answered 2013-02-01 14:47:22 +0200

George gravatar image

I have the same problem.

As a workaround, I have found that this works:

Duplicate the sheet containing the chart that you wish to copy. Double-click the chart in the newly created sheet. (Data Ranges are now available). Edit the data ranges and point them back to the original sheet. Copy the chart and paste it back onto the original sheet.

Data ranges are available and you can delete the copied sheet.

Interestingly, the newly created chart can be recopied on the original sheet and seems to work the way you wanted originally.

edit flag offensive delete link more

Comments

This workaround was a lifesaver, but it is still not exactly what is wanted. AFAICT, this workaround still does not offer the DataRange option, only the DataTable option on the chart copied from the newly created sheet to the original sheet.

I am a rather new user of OpenOffice, and even fear I am on the wrong list since I know nothing about "Libre Office." Anyway, it's hard to believe a bug as serious as this is still around after so many years. I'm using "Apache OpenOffice 4.1.0".

henry n. gravatar imagehenry n. ( 2014-08-26 09:59:50 +0200 )edit
1

answered 2012-07-21 10:17:13 +0200

Pedro gravatar image

You just need to double click on the chart (the border changes to thick grey) and then right click on the chart area to get the Data Ranges.

Hope this helps ;)

edit flag offensive delete link more

Comments

1

Hi, Pedro, that's how it's supposed to work but no longer does. This method works if I want to edit a graph's data ranges, IF the data I want to edit are the original data. It doesn't work if I copy the graph and THEN right-click on the chart area -- there is no longer a Data Ranges option, just a Data Table option. I can't substitute data into the copied table, only the original graph/table. Mary

Mary P. gravatar imageMary P. ( 2012-08-26 09:52:32 +0200 )edit
0

answered 2013-02-02 01:28:58 +0200

m.a.riosv gravatar image

Hy Mary Palomar,
maybe some help in this thread:
http://ask.libreoffice.org/en/questio...

edit flag offensive delete link more
0

answered 2013-02-01 22:07:32 +0200

horst gravatar image

Hi Mary P., one add-on to PPS: in your question. You can install more than one LO version. How to do it see this link.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-07-21 09:11:56 +0200

Seen: 8,444 times

Last updated: Jul 06 '14