Copy only visible cells
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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:
- install the extension;
- restart LibreOffice;
- open your sheet with hidden rows or columns;
- select a range;
- insted the simple copy button, click on 'Copy only visible cells' button;
- paste in your target document, for example, another sheet or a RTF text table. The hidden rows or columns won´t paste.
Notes:
- 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)