Extensions/Projects/CopyVisiCells

This extension provides an alternative to the 'Select Visible Cells' command in Microsoft Excel. It´s useful to use with subtotals or ranges with hidden columns or rows. To use 'Copy only visible cells', do the following steps:


 * 1) install the extension;
 * 2) restart LibreOffice;
 * 3) open your sheet with hidden rows or columns;
 * 4) select a range;
 * 5) insted the simple copy button, click on 'Copy only visible cells' button;
 * 6) paste in your target document, for example, another sheet or a RTF text table. The hidden rows or columns won´t paste.

Notes:
 * 1) it´s not possible paste especial with 'DDE Link' option in Writer;

Download
https://extensions.libreoffice.org/extension-center/copy-only-visible-cells/releases/

Credits
Developed by Gustavo Pacheco.

Special thanks: Andrew Pitonyak, Stephan Wunderlich, Ryan Nelson, Paolo Mantovani,Christian Junker and Comune di Bologna.

Translations:

English (en) - "Copy only visible cells"

Portuguese - Brazil (pt-br) - "Copiar somente as células visíveis"

Italian - Italia (it) - "Copiare solo le celle visibili"

Spanish (es) - "Copiar sólo las celdas visibles" German (de) - "Kopieren sichtbarer zellen"

French (fr) - "Copier uniquement les cellules visibles"

New contributions:

"Kopiraj le vidne celice" - Martin Srebotnjak - Slovenian - Slovenia (sl)

"Копирай само видимите клетки" - Lyudmil Vasilev - Bulgarian - Bulgaria (bg)

"Kopiera endast synliga celler" - Johnny Rosenberg - Swedish - Sweden (sv)

"Kopier kun synlige celler" - Leif Lodahl - Danish - Denmark (da-dk)

"Kopeeri üksnes nähtavad lahtrid" - Mihkel Tõnnov - Estonian - Estonia (et)

"Csak a látható cellák másolása" - Andras Timar - Hungarian - Hungary - (hu)

"Kopijuoti tik rodomus langelius" - Rimas Kudelis - Lithuanian - Lithuania - (lt)

"Copiar apenas as células visíveis" - Carlos Moreira - Portuguese - Portugal (pt)

Links

 * Copy only visible cells in japanese