[Solved] Calc paste chart problem

Discuss the spreadsheet application

[Solved] Calc paste chart problem

Postby neuralnet » Thu Dec 10, 2015 12:29 pm

I'm having an issue with the way that Calc pastes chart objects. In other spreadsheet programmes I've used (e.g. M$ Office, Libre office) copying/pasting a chart into the same document duplicates the chart and references the same data as the original chart object. You can then quickly and easily reuse the same chart by changing the source data range.

Calc pastes the chart as an embedded object that comes with it's own 'chart data table' and doesn't reference the underlying data in the spreadsheet. I can see the value when pasting charts into different programmes or even different spreadsheets, however this makes little sense and creates redundancy when it's the same worksheet. I've tried 'paste special' and none of the options available do what I need. Any way to fix this ?

Calc OO 4.1.2 on win 7.
Last edited by neuralnet on Fri Dec 11, 2015 1:09 pm, edited 1 time in total.
OpenOffice 4.1.2 on Windows 7 / Debian Linux
neuralnet
 
Posts: 2
Joined: Thu Dec 10, 2015 11:54 am

Re: Calc paste chart problem

Postby Lupp » Thu Dec 10, 2015 4:36 pm

To be able to paste a chart also into a different document not containing the data themselves (another Calc document, a Writer or a Draw/Impress document) it must be copied together with the data (contained in the chart's 'Data Table...' then). Otherwise the references would need to change into external ones (very differently handled). Only if it subsequently is pasted into the document from which it originated the chart's data references make sense (and might then be edited).

I cannot tell you for all the versions of ODF conformant software, but recent versions of LibreOffice do it the way you obviously expect if applicable (underlined case above). AOO 4.1.2 does not.

You may be interested in this recent thread in another forum: http://en.libreofficeforum.org/node/12144. Do not miss my second answer there. The example attached there was created copying charts together with the references and subsquently editing these. (You can see the result but not reproduce its creation with AOO, as already mentioned.)
On Windows 10: LibreOffice 6.4 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2736
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Calc paste chart problem

Postby neuralnet » Fri Dec 11, 2015 1:08 pm

Thanks for your reply. My search-fu must have been a bit off yesterday morning as I managed to find a solution later in the day but had to wait until my question was approved by a moderator before I could edit it.

My question was pasting a chart into the document from which it originated. To achieve the same in AOO simply hold down 'ctrl' and drag the chart you want to duplicate. Calc will then make a replica of the original chart (instead of embedding a copy with a data table) and you can then right click on it and choose 'Data ranges' to edit them. Easy when you know how!
OpenOffice 4.1.2 on Windows 7 / Debian Linux
neuralnet
 
Posts: 2
Joined: Thu Dec 10, 2015 11:54 am

Re: [Solved] Calc paste chart problem

Postby bebs » Tue Jun 21, 2016 3:15 pm

thanks neuralnet for this life-saving trick.

ctrl+drag a chart will indeed copy the chart in OpenOffice calc while preserving its data range (ie no conversion to internal data table), even across sheets in the same document. It's important to me as I'm used to gather all computations in one single sheet (back-end) and group most graphs in a user-friendly sheet for discussions/presentation/printing.

I whish Apache's devs would not change a basic feature as preserving data link without more care... but at least your trick makes it bearable. not user friendly but bearable.
OpenOffice on Ubuntu.
bebs
 
Posts: 15
Joined: Mon Mar 14, 2011 2:42 pm

Re: [Solved] Calc paste chart problem

Postby jokanane » Thu Apr 06, 2017 8:34 pm

bebs wrote:ctrl+drag a chart will indeed copy the chart in OpenOffice calc while preserving its data range (ie no conversion to internal data table), even across sheets in the same document.

How do you drag a chart across sheets in the same document?

If I try to drag a chart onto another sheet's tab (hoping that it activates the other sheet), the rows of the initial sheet just start running when the dragged item touches an edge of the cells' area.
OpenOffice 4.0.1 on MacOS 10.12.4
jokanane
 
Posts: 2
Joined: Thu Apr 06, 2017 8:24 pm

Re: [Solved] Calc paste chart problem

Postby Richarda44 » Fri Apr 07, 2017 1:34 pm

@jokanane it scrolls on the original sheet when you are on the bottom visible row. If you want to change sheet drag a bit further to the sheet tabs.
OOo 4.1.1. bld 9593 on MS Windows 10 64 SP1 Chillblast fusion i5 and Acer Aspire E1-572 Laptop

There's got to be a better way
And for all accountants - The change is coming
Richarda44
 
Posts: 351
Joined: Sat May 24, 2008 6:59 pm

Re: [Solved] Calc paste chart problem

Postby jokanane » Fri Apr 07, 2017 5:59 pm

@Richarda44 yeah that's what I'd expect, but it does not seem to work so; no matter if I try to reach the tabs slowly or by slamming the chart all the way down of the program window, the rows just keep running and the tabs section / tabs won't activate.
OpenOffice 4.0.1 on MacOS 10.12.4
jokanane
 
Posts: 2
Joined: Thu Apr 06, 2017 8:24 pm

Re: [Solved] Calc paste chart problem

Postby bebs » Sun Apr 09, 2017 9:13 pm

jokanane wrote:How do you drag a chart across sheets in the same document?


It's really just a matter of ctrl+drag. push and hold CTRL key, click and hold on your graph, go slowly down at first to see a "shadow" graph moving, then go quickly all the way down, outside of the original spreadsheet, to the "tab" of the destination spreadsheet at the bottom, it will show on top, move you mouse to the destination you want and release the mouse button.

It may take a bit of practice... or you can ask somebody else to try, or try with another computer / mouse / mousepad... to get a first grasp of the technique.

good luck !
OpenOffice on Ubuntu.
bebs
 
Posts: 15
Joined: Mon Mar 14, 2011 2:42 pm


Return to Calc

Who is online

Users browsing this forum: MSN [Bot] and 26 guests