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/01/04070400.xhp | 69 ++++++++++++++++++++++++++ 1 file changed, 69 insertions(+) create mode 100644 helpcontent2/source/text/scalc/01/04070400.xhp (limited to 'helpcontent2/source/text/scalc/01/04070400.xhp') diff --git a/helpcontent2/source/text/scalc/01/04070400.xhp b/helpcontent2/source/text/scalc/01/04070400.xhp new file mode 100644 index 000000000..3cc0ad738 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/04070400.xhp @@ -0,0 +1,69 @@ + + + + + + + + +Define Label Range +/text/scalc/01/04070400.xhp + + + +sheets; defining label ranges +label ranges in sheets + + + + +Define Label Range + +Opens a dialog in which you can define a label range. + +
+ +
+ +The cell contents of a label range can be used like names in formulas - $[officename] recognizes these names in the same manner that it does the predefined names of the weekdays and months. These names are automatically completed when typed into a formula. In addition, the names defined by label ranges will have priority over names defined by automatically generated ranges. +You can set label ranges that contain the same labels on different sheets. $[officename] first searches the label ranges of the current sheet and, following a failed search, the ranges of other sheets. + + +Range +Displays the cell reference of each label range. In order to remove a label range from the list box, select it and then click Delete. + + +Contains column labels +Includes column labels in the current label range. + +Contains row labels +Includes row labels in the current label range. + +For data range +Sets the data range for which the selected label range is valid. To modify it, click in the sheet and select another range with the mouse. + + +Add +Adds the current label range to the list. + +
+ +
+ + -- cgit v1.2.3