[Libreoffice-ux-advise] New "Clone cells" option (for "Paste Only") in Calc
daniel.mania at umb.no
Wed May 23 05:24:51 PDT 2012
There is one option missing in Calc, and that is "Clone". By that I mean
pasting a 1:1 copy without changing formulas or anything, so that the
newly pasted cells will have the exact same formulas and output as the
source cells, independent of the new location.
A "clone" function would be valuable to use different formulas on the
same source cells. E.g. one could calculate the average of some data,
copy those "average cells" to the next row and replace "AVERAGE" with
"STDEV" to have standard deviation without much additional work. These
"easy" tasks can become very difficult when the source data is spread
throughout a sheet or even worse different sheets.
With joy I saw the new "Paste Only" in Calc, which is a very useful
shortcut to "Paste Special". "Clone cells" would also be a nice addition
More information about the Libreoffice-ux-advise