<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - proposal for Paste Special Sticky"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139351">139351</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>proposal for Paste Special Sticky
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>ralacroix@hydro.mb.ca
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>