Re: [libreoffice-users] localc 5.1.4.2 - comment and reference issues

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: users+unsubscribe@global.libreoffice.org
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