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. To copy visible cells only, execute the following easy steps. Select the range A1:A4. On the Home tab, in the Editing group, click Find & Select. Click Go To Special. Click Visible cells only and click OK. Excel selects the visible cells. Press Ctrl + c to copy the range. Select cell A6 and press Ctrl + v to paste the range. Copy Visible Cells Only. Copying cells in a filtered table will only copy the visible cells by default, but if you have hidden rows or columns (as opposed to filtered), then Excel will copy the hidden ones too. For example, you can see in the data below that row 3 is hidden.
-->Copies the range to the specified range or to the Clipboard.
Note
Interested in developing solutions that extend the Office experience across multiple platforms? Check out the new Office Add-ins model. Office Add-ins have a small footprint compared to VSTO Add-ins and solutions, and you can build them by using almost any web programming technology, such as HTML5, JavaScript, CSS3, and XML.
Syntax
expression.Copy (Destination)
expression A variable that represents a Range object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Destination | Optional | Variant | Specifies the new range to which the specified range will be copied. If this argument is omitted, Microsoft Excel copies the range to the Clipboard. |
Return value
Variant
Example
The following code example copies the formulas in cells A1:D4 on Sheet1 into cells E5:H8 on Sheet2.
The following code example inspects the value in column D for each row on Sheet1. If the value in column D equals A, the entire row is copied onto SheetA in the next empty row. If the value equals B, the row is copied onto SheetB.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Tags: CalcExtensions
Rating:
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.
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.
How To Copy Only Visible Cells In Filtered Excel
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.
Homepage: http://wiki.documentfoundation.org/PT-BR/Extensions/Projects/CopyVisiCells/en
Release List
Copy Visible Cells In Microsoft Excel Spreadsheet
- ReleaseDescriptionCompatibilityOperating SystemsLicenseRelease notes
- 2.0The code was completely refactored for LibreOffice 5.2.x.5.2Linux, Windows, macOSLGPLDownload
- 1.2Added 5.0 and 5.1 compatibility. Important: this version is not 5.2 compatible.5.0Linux, Windows, macOSLGPLDownload
- 1.1Big ranges copy bug fixed.4.1LGPLDownload
- 1.0.5New Catalan and Dutch translations.3.3LGPLDownload