Ask Your Question

Automatic update of references between Calc documents [closed]

asked 2014-08-27 07:29:56 +0200

Dutchmm gravatar image

updated 2016-03-03 10:56:50 +0200

Alex Kemp gravatar image

Suppose you have workbook A and workbook B - two LO Calc spreadsheet documents. Suppose book A contains a formula along the lines of ='file:///home/mike/Documents/workbook B.ods'#$Sheet1.C9

Now suppose you insert a row above row 9 in Sheet 1 of workbook B

I would have expected the formula in book A to adapt itself to this change. I'm pretty sure that's what I remember happening in Excel, too. Nope! It doesn't change, even if I manually make workbook A update its links to workbook B. It still says:

='file:///home/mike/Documents/workbook B.ods'#$Sheet1.C9 instead of ='file:///home/mike/Documents/workbook B.ods'#$Sheet1.C10

This has bitten me two or three times now. I thought the intersheet references might be disturbed by worksheet protection, but I have eliminated that as a cause. What option do I need to turn on so Calc behaves as I would expect? Or is this a bug I should be reporting?

BTW, this is on LO, on Linux Mint 17

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 10:57:04.420136

1 Answer

Sort by » oldest newest most voted

answered 2014-08-28 11:12:46 +0200

erAck gravatar image

A live update of external references isn't implemented. Also in Excel that works only as long as you have both the linking and the linked document open at the same time.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-08-27 07:29:56 +0200

Seen: 214 times

Last updated: Aug 28 '14