From 267c6f2ac71f92999e969232431ba04678e7437e Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Mon, 15 Apr 2024 07:54:39 +0200 Subject: Adding upstream version 4:24.2.0. Signed-off-by: Daniel Baumann --- .../source/text/scalc/guide/datapilot_tipps.xhp | 50 ++++++++++++++++++++++ 1 file changed, 50 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/datapilot_tipps.xhp (limited to 'helpcontent2/source/text/scalc/guide/datapilot_tipps.xhp') diff --git a/helpcontent2/source/text/scalc/guide/datapilot_tipps.xhp b/helpcontent2/source/text/scalc/guide/datapilot_tipps.xhp new file mode 100644 index 0000000000..a1bd507083 --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/datapilot_tipps.xhp @@ -0,0 +1,50 @@ + + + + + +Selecting Pivot Table Output Ranges +/text/scalc/guide/datapilot_tipps.xhp + + + +pivot table function; preventing data overwriting +output ranges of pivot tables + +

Selecting Pivot Table Output Ranges +

+Click the button More in the Pivot Table dialog. The dialog will be extended. +You can select a named range in which the pivot table is to be created, from the Results to box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the Results to box. You can also click on the appropriate cell to have the coordinates entered accordingly. +If you mark the Ignore empty rows check box, they will not be taken into account when the pivot table is created. +If the Identify categories check box is marked, the categories will be identified by their headings and assigned accordingly when the pivot table is created. + +

+ + -- cgit v1.2.3