Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

At 13:36 24/07/2016 -0800, Bill Schultz wrote:
Whatever label you choose (formula, link or reference) it's about replicating cell data from one cell to another.

But there *are* different ways of doing this.

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" ...

You are quite correct, of course: although in this case Paste Special creates what is essentially a formula, it does describe it in its options as a "link". if these are not to carry over why have those options in the first place?

As I'm sure you understand, Paste will generally carry over formatting constructs to the target cell and Paste Special allows you to select which aspects are included. But as soon as you select the Link option in Paste Special, you are creating a formula instead of pasting values, and formatting and comments are no longer included. I can see that this is what you see as a problem.

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.

This is something of a straw man: my comment was in reply to your suggestion about formatting generally, not just comments!

No one I know who does disagrees with this being a deficiency.

I can't dispute that, of course - but this question is surely not settled by counting friends? When I said "most people", I wasn't referring to actual people whose opinions I have sought, but to my understanding of how spreadsheets are used. The sort of circumstance that I imagine is having one sheet or area of a spreadsheet where data is entered or detailed calculations performed and another where the results are drawn together in a report. In this case, there will be formulae (yes, "links" in this case) to harvest results from other areas into the report. In this case, I can appreciate the use for comments, but surely these will be very different in the two places? In the source area, the comment might indicate to the person entering data what the various cells represent and which values are carried over to the report, but in the report itself they would be addressed to the reader of the report and might explain the significance of the values instead. If there were comments in both places, I'd expect them to be very different. And other formatting aspects you mention might well need to be different in the two areas. That was my only point.

But I'm not responsible for spreadsheet software design and content myself with describing what happens and suggesting that I perhaps understand why it is done the way it is. I'm not disputing your right to an alternative opinion.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.