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

On 07/23/2016 08:18 PM, Brian Barker wrote:
> 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. 
Whatever label you choose (formula, link or reference) it's about 
replicating cell data from one cell to another.  Deferring to your 
"formula" label, when you set it up using Edit/Paste Special you ARE 
given the option to include/exclude formatting, comments and make it a 
"link" so if these are not to carry over why have those options in the 
first place?

> 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.
Point taken, IMHO it would be rare you'd want linked comments in many to 
one references with those rarities easily worked around.  I can't see 
the need but you could treat those rarities in the same way we do when 
merging multiples cells with data into one.  Or simply default to using 
the first cells format, comment, etc...

> > On spreadsheets with only internal links the "Edit/Links" is ghosted.
>
> Again, that is because these are formulae, not links.
Yes, but there is no Edit/Formulas and I was trying everything before 
posting.

> > 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.
"most people" don't use comments at all, much less linked comments. No 
one I know who does disagrees with this being a deficiency.


> 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