[Libreoffice-bugs] [Bug 139351] New: proposal for Paste Special Sticky

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139351
           Summary: proposal for Paste Special Sticky
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ralacroix at hydro.mb.ca

Description:
I want to streamline a sequence of Copy and Paste Special operations down to a
single Copy and Paste Special operation by adding a property to each attribute
of a cell called "stickiness", so that the designer of a source range doesn't
need to communicate to the consumer (the one who controls pasting) the sequence
of subranges to copy and the special subset of features to paste. To put it
plainly, in my use-case a large range contains sub-ranges having formulas, some
which are to be pasted verbatim and some which will be pasted as values
computed from lookup tables. I want to do it all at once and I don't want to
write a macro to do this.

Stickiness is picked up from features of the source range by Copy (by default
everything is sticky) and Paste Special Sticky ignores features of the source
range which are not sticky.

The stickiness property is attached to each cell feature: content
(formula/value), font, background colour, numeric format, etc. and cells in the
range can individually have different sets of features which have been marked
as "not sticky", so that the whole source range can be selected and a single
Paste Special Sticky does it all for me. This eliminates a source of error and
repetitious manual work at the same time as it eliminates the need for a macro
to do the same.

When used in a macro, Paste Special Sticky eliminates a lot of code and so
potentially a lot of code maintenance. As such this is a productivity
enhancement for the spreadsheet designer as well as the spreadsheet user.

Steps to Reproduce:
Consider your experience as a user.

Actual Results:
Remember what happened.

Expected Results:
Use your imagination.


Reproducible: Always


User Profile Reset: No



Additional Info:
Enhancement - applies to all new releases.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210101/481e63d9/attachment-0001.htm>