At 14:50 23/07/2016 -0700, Bill Noname wrote:
reference (internal to one sheet) issues
if you link =$page1.$A$1 to page2 cell a1 changes to the cell update
immediately but changes to comment content, size or position never
to regardless of global localc general updating setting
That's because what you have here is not a link but a formula.
Formulae evaluate values only and do not carry over other aspects of
a cell - formatting and so on. Remember that your formula,
referencing only a single cell, is a special case of something more
general. What would you want to happen if your formula were instead
=Sheet2.$A$1+Sheet3.$A$1 ? The destination cell couldn't inherit
aspects of formatting from both of two different cells. Note that a
formula such as this, which happens to reference another sheet or
sheets in the same spreadsheet, is no different from one that
operates only within a single sheet.
On spreadsheets with only internal links the "Edit/Links" is ghosted.
Again, that is because these are formulae, not links.
it would be nice to have a hotkey to update INTERNAL links including
row height, comment window content, position and size
You would break most people's idea of how a spreadsheet should
operate if you achieved this.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
