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

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

> ...so 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: 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