Copy only visible cells

70 0

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.

Project Description

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 (or Edit -> Copy only visible cells menu);

6. paste in your target document, for example, another sheet or a RTF text table.

The hidden rows or columns won´t paste.

Note: it´s not possible paste especial with 'DDE Link' option in Writer.

Available on 16 languages: Bulgarian, Catalan, Danish, Dutch, English (default language), Estonian, French, German, Hungarian, Italian, Lithuanian, Portuguese (Brazil), Portuguese (Portugal), Slovenian, Spanish and Swedish. Special thanks: Andrew Pitonyak, Stephan Wunderlich, Ryan Nelson, Sheila Tozatti, Paolo Mantovani, Christian Junker and Comune di Bologna.

Category/Categories

Calc Extension

Homepage of the Project

http://wiki.documentfoundation.org/PT-BR/Extensions/Projects/CopyVisiCells/en

Current Release

Copy only visible cells - 2.0

Released Jan 03, 2017 — tested with:

LibreOffice 5.2,

The code was completely refactored for LibreOffice 5.2.x.
More about this release…

copyvisiblecells-2.0.oxt
All platforms
File size: 32 kb

All Releases

Version

Released

Platform(s)

Compatibility

Description

License(s)

Status

2.0

Jan 03, 2017
  • All platforms
  • LibreOffice 5.2
The code was completely refactored for LibreOffice 5.2.x.
  • LGPL-v3+ (GNU Lesser General Public License Version 3 and later)
final

1.2

Jan 03, 2017
  • All platforms
  • LibreOffice 5.0
  • LibreOffice 5.1
Added 5.0 and 5.1 compatibility. Important: this version is not 5.2 compatible.
  • LGPL-v3+ (GNU Lesser General Public License Version 3 and later)
final

1.1

Mar 07, 2014
    • LibreOffice 4.1
    • LibreOffice 4.2
    Big ranges copy bug fixed.
    • LGPL-v3+ (GNU Lesser General Public License Version 3 and later)
    final

    1.0.5

    Nov 18, 2011
      • LibreOffice 3.3
      • LibreOffice 3.4
      New Catalan and Dutch translations.
      • LGPL-v2.1 (GNU Lesser General Public License Version 2.1)
      final

      Legal Disclaimer and Limitations for Downloads

      The Document Foundation has not reviewed, and cannot review, all of the material, including computer software, available on or by means of The Document Foundation's
      websites, and cannot therefore be responsible for that material's content, use or effects. By operating its websites, The Document Foundation does not represent or imply that it endorses the material there available, or that it believes such material to be accurate, useful or nonharmful. You are responsible for taking precautions as necessary to protect yourself and your computer systems from viruses, worms, Trojan horses and other harmful or destructive content. The Document Foundation's websites may contain content that is offensive, indecent or otherwise objectionable, as well as content containing technical inaccuracies, typographical mistakes and other errors. The Document Foundation's websites may also contain material that violates the privacy or publicity rights, or infringes the proprietary rights, of third parties, or the downloading, copying or use of which is subject to additional terms and conditions, stated or unstated. The Document Foundation disclaims any responsibility for any harm resulting from the use by The Document Foundation's visitors of The Document Foundation's websites, or from any downloading by those visitors of content available on or by means of The Document Foundation's websites.

      Changes

      Content contained on The Document Foundation's websites, including these Legal Disclaimers and Limitations, may be changed at the sole discretion of The Document Foundation and without notice. You are bound by any such updates or changes, and so should periodically review these Legal Disclaimers and Limitations.

      If you believe any file is present on the site contrary to any TDF rule or applicable law, please supply full details to info@documentfoundation.org for impartial consideration.