On 07/23/2016 08:18 PM, Brian Barker wrote:
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
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.
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...
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.
Yes, but there is no Edit/Formulas and I was trying everything before
On spreadsheets with only internal links the "Edit/Links" is ghosted.
Again, that is because these are formulae, not links.
"most people" don't use comments at all, much less linked comments. No
one I know who does disagrees with this being a deficiency.
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.
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy