From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/guide/cellcopy.xhp | 79 +++++++++++++++++++++++ 1 file changed, 79 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/cellcopy.xhp (limited to 'helpcontent2/source/text/scalc/guide/cellcopy.xhp') diff --git a/helpcontent2/source/text/scalc/guide/cellcopy.xhp b/helpcontent2/source/text/scalc/guide/cellcopy.xhp new file mode 100644 index 000000000..23d1a612d --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/cellcopy.xhp @@ -0,0 +1,79 @@ + + + + + + + + + Only Copy Visible Cells + /text/scalc/guide/cellcopy.xhp + + + +cells; copying/deleting/formatting/moving + rows;visible and invisible + copying; visible cells only + formatting;visible cells only + moving;visible cells only + deleting;visible cells only + invisible cells + filters;copying visible cells only + hidden cells +mw changed "cells;" +Only Copy Visible Cells + + Assume you have hidden a few rows in a cell range. Now you want to copy, delete, or format only the remaining visible rows. + $[officename] behavior depends on how the cells were made invisible, by a filter or manually. + + + + Method and Action + + + Result + + + + + Cells were filtered by AutoFilters, standard filters or advanced filters. + Copy, delete, move, or format a selection of currently visible cells. + + + Only the visible cells of the selection are copied, deleted, moved, or formatted. + + + + + Cells were hidden using the Hide command in the context menu of the row or column headers, or through an outline. + Copy, delete, move, or format a selection of currently visible cells. + + + By default, all cells of the selection, including the hidden cells, are copied, deleted, moved, or formatted. Restrict the selection to visible rows choosing Edit - Select - Select Visible Rows Only or to visible columns choosing Edit - Select - Select Visible Columns Only. + + +
+ +
+ + + +
+ + \ No newline at end of file -- cgit v1.2.3