I wish to bring over a total from one workbook to another without using DDE as that is deprecated and is causing me problems. The total is in a single cell with a range name. Both workbooks are in the same directory.
If I try Insert | Link or dragging the range name from the source sheet using the navigator, it inserts the contents of the cell, character for character. This is a formulae, which gives the required result in the source sheet but is utterly meaningless in the destination.
If I type "=" in the cell contents toolbar then click on the cell in the source document, this works fine, but it inserts the cell reference raw rather than with its range name
='file:///home/simon/Home/Files/Accounts/Peracs14-15.ods'#$Journal.F412. If I try to substitute the cell reference with the range name
='file:///home/simon/Home/Files/Accounts/Peracs14-15.ods'#Journal.Number20, it produces an error
#NAME. If I enter the range name on its own
='file:///home/simon/Home/Files/Accounts/Peracs14-15.ods'#Number20 pressing [Enter] causes the cell contents to change to
='file:///home/simon/Home/Files/Accounts/Peracs14-15.ods'#file:///home/simon/Home/Files/Accounts/Peracs14-15.ods, which is bizarre. The original path is still there but the range name has been substituted for the path to the file without the range name such that the range name has disappeared. This happens whether "autocomplete" is on or off. Is my poor old computer still haunted by Bill Gates' paper clip?
As I need to create a new sheet at each period end, it would be a lot of work to re-insert all these references with the correct cell references. I know I am missing something obvious, can someone help me?
Platform - Linux Mint 17.3 with xfce, based on Ubuntu 14.04. GUI - xfce V4.10 Application - LibreOffice Version: 220.127.116.11