The Calc extension “Copy only visible cells” is not working in LibreOffice 5.1.2.2 (on both Kubuntu 14.04 and 16.04). It gives the error message “Filled cells cannot be shifted beyond the sheet.”
I looked at the macro and don’t see what needs to be changed and I’m not sure how to contact whoever wrote the extension. (Edit: I e-mailed the last person to modify the code. The information was at the top of the macro and I had not scrolled all the way up earlier.)
As a work-around, I figured out that I could use filters to replace part of the functionality the extension provides (excluding rows), but not all of it (excluding columns).
If anyone has any ideas on how to get the functionality of copying only visible cells, I would appreciate some input.
Thanks.