Ask Your Question

How to migrate sheets to other calc file with cell name.

asked 2017-05-08 14:34:35 +0200

gavin gravatar image

Hi, I have a master template with cell name/cellreference assigned to the individual cell in the columns. So what i need to do is that to copy this sheet with cell name to another file with formulas that are linking to the cell name/cellreference. However when i do so, the cell reference is not copied. Is there a way to solve this as i do not wish to reference the cell individually to the cell name as there are too many cellnames assigned.

*Example:* Mastercopy: Master data (Cells are referenced/named.)

Actual Copy: Formula + Old data (Cells are referenced/named.)

What i need to do is: -Transfer the master data over by copying the sheet from the mastercopy to actual copy.

Because the master copy and actual copy rely on the cell name. So i need the cell name to be recaptured into the actual copy from the master so that the formula in the actual copy can detect the cell names.

Please kindly advise what can i do to solve this?

edit retag flag offensive close merge delete



It rained karma. You can now upload your file.

Lupp gravatar imageLupp ( 2017-05-09 10:25:48 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-05-08 22:20:23 +0200

m.a.riosv gravatar image

I thing copying/moving sheet should work, right-click on the sheet tab to copy, 'Move/copy sheet', then you can select between copy or move and destination to the same/another/new file.

edit flag offensive delete link more


Thanks for your input, i have tried using 'Move/copy sheet' but the cell name does not copy over.

gavin gravatar imagegavin ( 2017-05-09 01:41:27 +0200 )edit

The thing is that when i use 'Move/copy sheet' some of the cell names disappear . Why is it that not all cellnames are present? And my formula could not link to the cell name due to most of the cell name are not copied over.

gavin gravatar imagegavin ( 2017-05-09 01:59:52 +0200 )edit

Can you share a sample file for test?

m.a.riosv gravatar imagem.a.riosv ( 2017-05-09 02:09:34 +0200 )edit

Hi, Thanks for replying. I need to know how do i attached the sample file for you to test? if you dun mind i can email you the sample file.

gavin gravatar imagegavin ( 2017-05-09 06:46:40 +0200 )edit

Hi, I just realised I don't have enough points to upload the file. Do you mind giving me your email id or if there is any common platform I can share the file there. Thanks

gavin gravatar imagegavin ( 2017-05-09 07:32:13 +0200 )edit

With your last file cell names are copied, on the first sight they are not on the list on the 'Name box', but opening 'Managing names' they are there. 'Name box' list it's updated at least changing between files.

m.a.riosv gravatar imagem.a.riosv ( 2017-05-10 10:13:54 +0200 )edit

That means i have to manually assign the cell names again? The actual list is very long any way to move'copy with the cells having the correct cell name.

gavin gravatar imagegavin ( 2017-05-10 14:34:28 +0200 )edit

Anyone have an answer for exporting sheets together with the cell names.

gavin gravatar imagegavin ( 2017-05-12 06:15:20 +0200 )edit

Under manage names the list is there but the cells are not referenced. Any possible solution to this rather then manually assign the cell name.

gavin gravatar imagegavin ( 2017-05-12 11:37:35 +0200 )edit

answered 2017-05-09 07:31:46 +0200

gavin gravatar image

updated 2017-05-10 04:20:24 +0200

C:\fakepath\TEST File.ods(/upfiles/14943826509696328.ods)

edit flag offensive delete link more


There are file sharing hosts such as dropbox; upload there and update your question with the URL to the file.

robleyd gravatar imagerobleyd ( 2017-05-09 08:22:05 +0200 )edit

It rained karma. You can now upload your file.

Lupp gravatar imageLupp ( 2017-05-09 10:25:23 +0200 )edit

The text "C:\fakepath\sample.ods" you linked the attachment to stumped me. The "(/upfiles/14943236501894527.ods)" is pointing to the uploaded file in this system and should not be repeated as a text.

Lupp gravatar imageLupp ( 2017-05-09 12:21:25 +0200 )edit

Im sorry i will reupload the file again.

gavin gravatar imagegavin ( 2017-05-10 03:51:23 +0200 )edit

I have reupload the file but still with the quote"The text "C:\fakepath\sample.ods" you linked the attachment to stumped me."

I have uploaded file on dropbox. Please kidnly take a look on your convenience.

gavin gravatar imagegavin ( 2017-05-10 04:26:44 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-05-08 14:34:35 +0200

Seen: 81 times

Last updated: May 10 '17