Copying Cell Ranges with Hidden Cells
In your spreadsheet you have hidden a few rows in a cell range. Now you want to copy, delete, or format only the currently visible rows.
The Calc result depends on how the cells have been hidden, either by a filter or manually.
This is what you do |
This is what you get |
|
Case a) Some cells are hidden by applying AutoFilters, standard filters or advanced filters. Now you copy, delete, move, or format a selection of currently visible cells. |
Case a) Only the visible cells of the selection are copied, deleted, moved, or formatted. |
|
Case b) Some cells are hidden using the Hide command Again you copy, delete, move, or format a selection of currently visible cells. |
Case b) All cells of the selection, including the hidden cells, are copied, deleted, moved, or formatted |
With Calc in OpenOffice.org 2 or StarOffice 8, now you will not accidentally delete cells that are temporarily hidden by any filter. This is an improvement compared to OpenOffice.org 1 or StarOffice 7 and before.
Note that pasting cells is not covered by this change.