In Open Calc, how do I copy a paste cells that contain references to other workbooks?

Posted by Gabriel on Super User See other posts from Super User or by Gabriel
Published on 2012-10-12T21:17:56Z Indexed on 2012/10/12 21:39 UTC
Read the original article Hit count: 244

Filed under:

copy-paste

|

openoffice-calc

I have an OpenOffice Calc sheet with cells containing formulas that refer to another file, e.g: 'file:///C:/path/to/other.xls'#$Sheet1.A1:B2.

Note: When I copy the cells from one sheet to another in the same workbookt, it works as expected. When I copy this to a sheet in another workbook, the references are lost and all is left is ''#$Sheet1.A1:B2.

I could copy/paste the cell's contents, but that would be fastidious, error-prone, and anyhow not a good solution.

How do I keep the external references when copy-pasting from one workbook to another ?

© Super User or respective owner

Related posts about copy-paste

Windows7 and Virtual PC guest copy/paste intermittent delay

as seen on Super User - Search for 'Super User'
I've been using Virtual PC for some time now and have not had any issues with copy and paste until I upgraded my host to Windows7 64-bit. After the upgrade sometimes when I copy and paste some text there is like a 15-20 second delay before it completes, this is very frustrating when I'm trying to… >>> More
Fmylife javascript copy-paste into link

as seen on Stack Overflow - Search for 'Stack Overflow'
Fmylife.com has a nifty feature that when you copy the text from a post, it actually copies a LINK (html) so that when you paste it into your email/facebook/instant messenger/twitter/whatever it automatically will link to the post, giving them more traffic and more page views and more ad revenue,… >>> More
Is copy paste programming bad ?

as seen on Programmers - Search for 'Programmers'
With plain google as well as google code search tools it is easy to find how to program using some resource or solve certain problems ( such as a Java class, or a ftp block in perl etc) and so developers are so tempted to just purely copy paste the code (in a way re-use) - is this an incompetency… >>> More
UITextField in UIAlertView doesn't respond to cut/copy/paste on second showing

as seen on Stack Overflow - Search for 'Stack Overflow'
I"m adding a UITextView to a UIAlertView with the following code: UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"Enter Name Here" message:@"this gets covered!" delegate:self cancelButtonTitle:@"Dismiss" otherButtonTitles:@"OK!", nil]; UITextField *myTextField = [[UITextField alloc] initWithFrame:CGRectMake(12… >>> More
UITextField in UIAlertView doesn't respond to cut/copy/paste on second showing

as seen on Stack Overflow - Search for 'Stack Overflow'
Edit Reposting... I accidentally marked my previous question as "commuity wiki" and didn't realize that answers to wiki posts don't generate reputation. I"m adding a UITextView to a UIAlertView with the following code: UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"Enter Name Here" message:@"this… >>> More

Related posts about openoffice-calc

Ubuntu: Convert OpenOffice Calc to Excel workbook using CLI

as seen on Super User - Search for 'Super User'
I need to create an automated report in a spreadsheet format. Unfortunately, There seems to be an easy way to create these reports using OpenOffice Calc, but upper managements wants them in MS Excel format. As these reports are to be created and emailed automatically, is there a nice, command-line… >>> More
OpenOffice Calc: inserting image into a cell

as seen on Super User - Search for 'Super User'
I'm an Open Office Calc user. Is there a way to insert an image inside a cell? When I choose Insert - Picture it inserts it so it's floating over the cells, and that's now what I want. I want to be able to insert the image into cell A1, for instance. >>> More
Read data from separate CSV file in OpenOffice Calc

as seen on Super User - Search for 'Super User'
Hi, I have a very large CSV file (many thousands of rows) that I want to work with. Due to the size of the file, I don't want to import it into openoffice. Rather, I want to create a spreadsheet that contains formulas & graphs that read from this (or any other) CSV file I point it it. Ideally… >>> More
How to apply an Openoffice Calc template?

as seen on Super User - Search for 'Super User'
How I can easily apply a template to an existing OO Calc file? AFAIK it is possible only to make a new file from a template, copy the sheets in it, and save/overwrite the old file. But I don't like this way; there is a easier/better way to do this? Like a macro, or something like that. I just need… >>> More
Using a Script to automate data entry to an OpenOffice Calc Spreadsheet

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to be able to automate creating spreadsheets and adding data to an OpenOffice spreadsheet using a script (any scripting language is acceptable - PowerShell, Python, or even JavaScript). What is a suitable library or tutorial? >>> More