[Libreoffice-ux-advise] [Bug 139351] proposal for Paste Special Sticky

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139351

--- Comment #5 from Robert Lacroix <ralacroix at hydro.mb.ca> ---
I am a software professional and I would contribute the changes to LO-Calc
myself if I didn't have so much work already. I imagine what I'll be doing in 5
years isn't very different from what I'm doing for salary so this feature might
appear here earlier than that. But I'm not discouraging anyone from taking on
this project before I get around to it, it looks like fun.

Thanks for the example. I must apologize - in an effort to generalize the
concept of stickiness and simplify my example use case, I didn't describe
clearly enough what I am doing. I copy a range from one sheet to another within
the same document file, inserting a new row into a table at the destination. A
pivot table summarizing that destination range computes values which are used
in the source range's calculations. I want to paste from the source range some
formulas and some values and some formatting as a template at row insertion
time. I could get away with inserting all as values into the destination if the
source was the only origin for data at the destination, but it's not. The
sequence of copy/pastes is mundane manual work in a few steps, but I wouldn't
dream of turning this document over to an unsophisticated user without a macro
codifying the source and destinations and the types of pasting to do.

The stickiness property described is a UX feature that does away with
maintaining macro details for the specifics and the sequence of
copy-and-paste-special operations, as it all gets done in one go with the
sticky bits in each individual cell's properties directing Paste Special Sticky
what to do with the cell at the destination.

This proposal is about generalizing the approach so that every user-modifiable
property of a cell can become sticky or not, changeable with the cell
properties dialog. Use of Paste Special Sticky in a macro would be as simple as
using Paste - the macro can ignore the internal structure of the source range.

An added note about Paste Special Sticky: stickiness of properties is
propagated by Paste, but not by Paste Special Sticky. The latter does not
change the stickiness of properties at the destination.

I understand that enhancement requests can take a long time if they don't get
flagged as GSoC projects. More comment is welcome.

-- 
You are receiving this mail because:
You are on the CC list for the bug.