OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Formula paste from another sheet causes filename disappear

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
SailorFred
General User
General User


Joined: 16 May 2011
Posts: 6

PostPosted: Thu Jun 21, 2012 11:01 am    Post subject: Formula paste from another sheet causes filename disappear Reply with quote

I have spreadsheet "A.ods" which has a cell with the formula:

Code:
=INDEX('file:///C:/files/Biz/All_Parts_Bom.ods'#$Sheet1.$C$2:$C$9999;MATCH(F2;'file:///C:/files/Biz/All_Parts_Bom.ods'#$Sheet1.$G$2:$G$9999;0);1)


I open a new spreadsheet, Ctrl-C the cell from A.ods, and Ctrl-V it into the new spreadsheet. What gets copied is this:

Code:
=INDEX(''#$Sheet1.$C$2:$C$9999;MATCH(F2;''#$Sheet1.$G$2:$G$9999;0);1)


The filename has disappeared Sad

- Pasting into a different .ods kills the filename
- Pasting from one cell to another within the SAME .ods does NOT kill the filename,.

A workaround is F2,Ctrl-A,Ctrl-C... and then paste. But I have a zillion cells with distinct formulas to copy, and I'd like to be able to select all the cells and copy en-masse. Anyone have any ideas?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group