Copy only visible cells

    From The Document Foundation Wiki

    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.


    1. it´s not possible paste especial with 'DDE Link' option in Writer;



    Developed by Gustavo Pacheco.

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


    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)