SailorFred
General User
Joined: 16 May 2011
Posts: 6
|
 Posted: Thu Jun 21, 2012 11:01 am Post subject: Formula paste from another sheet causes filename disappear |
 |
|
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 
- 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? |
|
