[Libreoffice-ux-advise] New "Clone cells" option (for "Paste Only") in Calc

Daniel Mania daniel.mania at umb.no
Wed May 23 05:24:51 PDT 2012

Hello everyone!

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 mailing list