source/text/scalc/guide/cellreferences.xhp | 34 +++++----- source/text/schart/01/wiz_data_range.xhp | 91 +++++++++++++++-------------- 2 files changed, 66 insertions(+), 59 deletions(-)
New commits: commit 52991f1a6f4677758dfeff3f3cd16653f3915620 Author: Olivier Hallot <[email protected]> AuthorDate: Wed Sep 24 10:47:12 2025 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Wed Sep 24 17:05:32 2025 +0200 tdf#129978 Extend documentation for selection of chart data sources + turn ahelp visibility on. + refactor page Change-Id: I6787fc34e698916eeea6f22d0a5ef10ed9f8eabb Reviewed-on: https://gerrit.libreoffice.org/c/help/+/191447 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/guide/cellreferences.xhp b/source/text/scalc/guide/cellreferences.xhp index 3ef6df4ab7..b9677e5e78 100644 --- a/source/text/scalc/guide/cellreferences.xhp +++ b/source/text/scalc/guide/cellreferences.xhp @@ -22,12 +22,12 @@ <meta> <topic id="textscalcguidecellreferencesxml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Referencing a Cell in Another Sheet</title> + <title id="tit">Referencing a Cell in Another Sheet</title> <filename>/text/scalc/guide/cellreferences.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3147436"><bookmark_value>sheet references</bookmark_value> +<bookmark branch="index" id="bm_id3147436"><bookmark_value>sheet references</bookmark_value> <bookmark_value>references; to cells in other sheets/documents</bookmark_value> <bookmark_value>addresses; to cells in other sheets/documents</bookmark_value> <bookmark_value>cells; operating in another document</bookmark_value> @@ -38,24 +38,24 @@ <comment>mw made "sheet references;" a one level entry</comment><comment>MW changed "references;" and added "documents;"</comment> <h1 id="hd_id3147436"><variable id="cellreferences"><link href="text/scalc/guide/cellreferences.xhp">Referencing a Cell in Another Sheet</link> </variable></h1> - <paragraph xml-lang="en-US" id="par_id9663075" role="paragraph">In a sheet cell you can show a reference to a cell in another sheet.</paragraph> - <paragraph xml-lang="en-US" id="par_id1879329" role="paragraph">In the same way, a reference can also be made to a cell from another document provided that this document has already been saved as a file.</paragraph> + <paragraph id="par_id9663075" role="paragraph">In a sheet cell you can show a reference to a cell in another sheet.</paragraph> + <paragraph id="par_id1879329" role="paragraph">In the same way, a reference can also be made to a cell from another document provided that this document has already been saved as a file.</paragraph> <h2 id="hd_id7122409">To Reference a Cell in the Same Document</h2> <list type="ordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id2078005" role="listitem">Open a new, empty spreadsheet. By default, it has only a single sheet named Sheet1. Add a second sheet clicking on <emph>+</emph> button to the left of the sheet tab in the bottom (it will be named Sheet2 by default).</paragraph> + <paragraph id="par_id2078005" role="listitem">Open a new, empty spreadsheet. By default, it has only a single sheet named Sheet1. Add a second sheet clicking on <emph>+</emph> button to the left of the sheet tab in the bottom (it will be named Sheet2 by default).</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id4943693" role="listitem">By way of example, enter the following formula in cell A1 of Sheet1:</paragraph> - <paragraph xml-lang="en-US" id="par_id9064302" role="listitem"> + <paragraph id="par_id4943693" role="listitem">By way of example, enter the following formula in cell A1 of Sheet1:</paragraph> + <paragraph id="par_id9064302" role="listitem"> <item type="literal">=Sheet2.A1</item> </paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id7609790" role="listitem">Click the <emph>Sheet 2</emph> tab at the bottom of the spreadsheet. Set the cursor in cell A1 there and enter text or a number.</paragraph> + <paragraph id="par_id7609790" role="listitem">Click the <emph>Sheet 2</emph> tab at the bottom of the spreadsheet. Set the cursor in cell A1 there and enter text or a number.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id809961" role="listitem">If you switch back to Sheet1, you will see the same content in cell A1 there. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also change.</paragraph> + <paragraph id="par_id809961" role="listitem">If you switch back to Sheet1, you will see the same content in cell A1 there. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also change.</paragraph> </listitem> </list> <tip id="par_id3147338">When referencing a sheet with name containing spaces, use single quotes around the name: <item type="literal">='Sheet with spaces in name'.A1</item></tip> @@ -63,30 +63,30 @@ <h2 id="hd_id9209570">To Reference a Cell in Another Document</h2> <list type="ordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id5949278" role="listitem">Choose <emph>File - Open</emph>, to load an existing spreadsheet document.</paragraph> + <paragraph id="par_id5949278" role="listitem">Choose <emph>File - Open</emph>, to load an existing spreadsheet document.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id8001953" role="listitem">Choose <emph>File - New</emph>, to open a new spreadsheet document. Set the cursor in the cell where you want to insert the external data and enter an equals sign to indicate that you want to begin a formula.</paragraph> + <paragraph id="par_id8001953" role="listitem">Choose <emph>File - New</emph>, to open a new spreadsheet document. Set the cursor in the cell where you want to insert the external data and enter an equals sign to indicate that you want to begin a formula.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id8571123" role="listitem">Now switch to the document you have just loaded. Click the cell with the data that you want to insert in the new document.</paragraph> + <paragraph id="par_id8571123" role="listitem">Now switch to the document you have just loaded. Click the cell with the data that you want to insert in the new document.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id8261665" role="listitem">Switch back to the new spreadsheet. In the input line you will now see how $[officename] Calc has added the reference to the formula for you. </paragraph> + <paragraph id="par_id8261665" role="listitem">Switch back to the new spreadsheet. In the input line you will now see how $[officename] Calc has added the reference to the formula for you. </paragraph> <section id="otherdocref"> - <paragraph xml-lang="en-US" id="par_id5888241" role="listitem">The reference to a cell of another document contains the fully qualified name of the other document between single quotes <literal>(')</literal>, then a hash <literal>#</literal>, then the name of the sheet of the other document, followed by a period and the name or reference of the cell. </paragraph> + <paragraph id="par_id5888241" role="listitem">The reference to a cell of another document contains the fully qualified name of the other document between single quotes <literal>(')</literal>, then a hash <literal>#</literal>, then the name of the sheet of the other document, followed by a period and the name or reference of the cell. </paragraph> <paragraph role="paragraph" id="par_id51672076541215">For example, <switchinline select="sys"><caseinline select="WIN">'file:///C:/Users/user/Documents/Price list.ods'#$'Information SKU'.H51</caseinline><defaultinline>'file:///home/user/Documents/Price list.ods'#$'Information SKU'.H51</defaultinline></switchinline>.</paragraph> <note id="par_id451672076939681">The path and document name URI <emph>must always</emph> be enclosed in single quotes. If the name contains single quotes (') they must be escaped using two single quotes (''). Only a sheet name may not be quoted if it does not contain a space or a character that would be an operator or the name would be pure numeric (for example, '123' must be quoted).</note> </section> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id7697683" role="listitem">Confirm the formula by clicking the green check mark.</paragraph> + <paragraph id="par_id7697683" role="listitem">Confirm the formula by clicking the green check mark.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id7099826" role="listitem">If you drag the box in the lower right corner of the active cell to select a range of cells, $[officename] automatically inserts the corresponding references in the adjacent cells. As a result, the sheet name is preceded with a "$" sign to designate it as an <link href="text/scalc/guide/relativ_absolut_ref.xhp">absolute reference</link>.</paragraph> + <paragraph id="par_id7099826" role="listitem">If you drag the box in the lower right corner of the active cell to select a range of cells, $[officename] automatically inserts the corresponding references in the adjacent cells. As a result, the sheet name is preceded with a "$" sign to designate it as an <link href="text/scalc/guide/relativ_absolut_ref.xhp">absolute reference</link>.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id674459" role="paragraph">If you examine the name of the other document in this formula, you will notice that it is written as a <link href="text/shared/00/00000002.xhp#url">URL</link>. This means that you can also enter a URL from the Internet.</paragraph> + <paragraph id="par_id674459" role="paragraph">If you examine the name of the other document in this formula, you will notice that it is written as a <link href="text/shared/00/00000002.xhp#url">URL</link>. This means that you can also enter a URL from the Internet.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/cellreferences_url.xhp#cellreferences_url"/> <embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> diff --git a/source/text/schart/01/wiz_data_range.xhp b/source/text/schart/01/wiz_data_range.xhp index 0fa6c17319..7163c18719 100644 --- a/source/text/schart/01/wiz_data_range.xhp +++ b/source/text/schart/01/wiz_data_range.xhp @@ -22,53 +22,60 @@ <meta> <topic id="textschart01wiz_data_rangexhp" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Chart Wizard - Data Range</title> + <title id="tit">Chart Wizard - Data Range</title> <filename>/text/schart/01/wiz_data_range.xhp</filename> </topic> </meta> <body> - <bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_RangeChooser/@@nowidget@@" id="bm_@@nowidget@@" localize="false"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id2429578"><bookmark_value>data ranges in charts</bookmark_value> +<bookmark branch="hid/modules/schart/ui/tp_RangeChooser/@@nowidget@@" id="bm_@@nowidget@@" localize="false"/> +<bookmark branch="index" id="bm_id2429578"><bookmark_value>data ranges in charts</bookmark_value> </bookmark><comment>mw added one entry</comment> -<paragraph xml-lang="en-US" id="hd_id8313852" role="heading" level="1"><variable id="wiz_data_range"><link href="text/schart/01/wiz_data_range.xhp">Chart Wizard - Data Range</link> -</variable></paragraph> - <paragraph xml-lang="en-US" id="par_id8829309" role="paragraph">On this page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can select one single source of data range. This range may consist of more than one rectangular range of cells.</paragraph><comment>context menu Data Ranges</comment> -<bookmark xml-lang="en-US" branch="hid/.uno:DataRanges" id="bm_id7543259" localize="false"/> -<paragraph xml-lang="en-US" id="par_id6401867" role="paragraph"><ahelp hid="." visibility="hidden">Opens the Data Ranges dialog where you can edit Data Range and Data Series.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="par_id2025818" role="tip">Use the Chart Wizard - Data Series page if you need more control over the data ranges.</paragraph> - <section id="howtoget"> - <embed href="text/schart/00/00000004.xhp#wiz_ranges"/> - </section> - <paragraph xml-lang="en-US" id="par_id8466139" role="paragraph">This dialog is only available for charts based on a Calc or Writer table.</paragraph> - <embed href="text/shared/00/00000001.xhp#ShiftF1"/> - <h2 id="hd_id1877193">To specify a data range</h2> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id5924863" role="paragraph">Select the data range. Do one of the following:</paragraph> - <paragraph xml-lang="en-US" id="par_id4357432" role="paragraph">Enter the data range in the text box.</paragraph> - <paragraph xml-lang="en-US" id="par_id5626392" role="paragraph">In Calc, an example data range would be "$Sheet1.$B$3:$B$14". Note that a data range may consist of more than one region in a spreadsheet, e.g. "$Sheet1.A1:A5;$Sheet1.D1:D5" is also a valid data range. In Writer, an example data range would be "Table1.A1:E4".</paragraph> - <paragraph xml-lang="en-US" id="par_id1363872" role="paragraph">In Calc, click <emph>Select data range</emph> to minimize the dialog, then drag over a cell area to select the data range.<comment>Hold down the Ctrl key and drag to select multiple ranges. --- see issue 71894</comment></paragraph> - <paragraph xml-lang="en-US" id="par_id6823938" role="paragraph">If you want a data range of multiple cell areas that are not next to each other, enter the first range, then manually add a semicolon at the end of the text box, then enter the other ranges. Use a semicolon as delimiter between ranges.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id1434369" role="paragraph">Click one of the options for data series in rows or in columns.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id7524033" role="paragraph">Check whether the data range has labels in the first row or in the first column or both.</paragraph> - </listitem> - </list> - <paragraph xml-lang="en-US" id="par_id5256508" role="paragraph">In the preview you can see how the final chart will look.</paragraph><comment>data range text box & shrinky</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_RangeChooser/ED_RANGE" id="bm_id2121951" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_RangeChooser/IB_RANGE" id="bm_id4829554" localize="false"/> -<paragraph xml-lang="en-US" id="par_id379650" role="paragraph"><ahelp hid="." visibility="hidden">Enter the data range that you want to include in your chart. To minimize this dialog while you select the data range in Calc, click the <emph>Select data range</emph> button.</ahelp></paragraph><comment>data series in rows</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_RangeChooser/RB_DATAROWS" id="bm_id2901699" localize="false"/> -<paragraph xml-lang="en-US" id="par_id953703" role="paragraph"><ahelp hid="." visibility="hidden">Data series get their data from consecutive rows in the selected range. For scatter charts, the first data series will contain x-values for all series. All other data series are used as y-values, one for each series.</ahelp></paragraph><comment>data series in columns</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_RangeChooser/RB_DATACOLS" id="bm_id5534226" localize="false"/> -<paragraph xml-lang="en-US" id="par_id4496597" role="paragraph"><ahelp hid="." visibility="hidden">Data series get their data from consecutive columns in the selected range. For scatter charts, the first data column will contain x-values for all series. All other data columns are used as y-values, one for each series.</ahelp></paragraph><comment>first row as label</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_RangeChooser/CB_FIRST_ROW_ASLABELS" id="bm_id49134" localize="false"/> -<paragraph xml-lang="en-US" id="par_id2898953" role="paragraph"><ahelp hid="." visibility="hidden">For data series in columns: The first row in the range is used as names for data series. For data series in rows: The first row in the range is used as categories. The remaining rows comprise the data series. If this check box is not selected, all rows are data series.</ahelp></paragraph><comment>first column as label</comment> -<bookmark xml-lang="en-US" branch="hid/modules/schart/ui/tp_RangeChooser/CB_FIRST_COLUMN_ASLABELS" id="bm_id8939481" localize="false"/> -<paragraph xml-lang="en-US" id="par_id7546311" role="paragraph"><ahelp hid="." visibility="hidden">For data series in columns: The first column in the range is used as names for data series. For data series in rows: The first column in the range is used as categories. The remaining columns comprise the data columns. If this check box is not selected, all columns are data columns.</ahelp></paragraph> +<h1 id="hd_id8313852"><variable id="wiz_data_range"><link href="text/schart/01/wiz_data_range.xhp">Chart Wizard - Data Range</link></variable></h1> +<description id="par_id6401867"><ahelp hid=".">Opens the Data Ranges dialog where you can edit Data Range and Data Series.</ahelp></description> +<paragraph id="par_id8829309" role="paragraph">On this page of the <link href="text/schart/01/wiz_chart_type.xhp">Chart Wizard</link> you can select one single source of data range. This range may consist of more than one rectangular range of cells.</paragraph><comment>context menu Data Ranges</comment> +<bookmark branch="hid/.uno:DataRanges" id="bm_id7543259" localize="false"/> +<tip id="par_id2025818">Use the Chart Wizard - Data Series page if you need more control over the data ranges.</tip> +<section id="howtoget"> + <embed href="text/schart/00/00000004.xhp#wiz_ranges"/> +</section> +<paragraph id="par_id8466139" role="paragraph">This dialog is only available for charts based on a Calc or Writer table.</paragraph> +<embed href="text/shared/00/00000001.xhp#ShiftF1"/> +<h2 id="hd_id1877193">To specify a data range</h2> +<list type="ordered"> + <listitem> + <paragraph id="par_id5924863" role="paragraph">Select the data range. Do one of the following:</paragraph> + <paragraph id="par_id4357432" role="paragraph">Enter the data range in the text box.</paragraph> + <paragraph id="par_id5626392" role="paragraph">In Calc, an example data range would be <literal>"$Sheet1.$B$3:$B$14"</literal>. Note that a data range may consist of more than one region in a spreadsheet, e.g. <literal>"$Sheet1.A1:A5;$Sheet1.D1:D5"</literal> is also a valid data range.</paragraph> + <paragraph role="paragraph" id="par_id521758720113741">An example of external data range would be like <literal>'file:///home/user/Documents/Price list.ods'#$'Information SKU'.H51</literal> as described in + <embedvar href="text/scalc/guide/cellreferences.xhp#cellreferences" markup="ignore"/>.</paragraph> + <paragraph id="par_id261758719662677" role="listitem">In Writer, an example data range would be <literal>"Table1.A1:E4"</literal>.</paragraph> + <paragraph id="par_id1363872" role="paragraph">In Calc, click <emph>Select data range</emph> to minimize the dialog, then drag over a cell area to select the data range.<comment>Hold down the Ctrl key and drag to select multiple ranges. --- see issue 71894</comment></paragraph> + <paragraph id="par_id6823938" role="paragraph">If you want a data range of multiple cell areas that are not next to each other, enter the first range, then manually add a semicolon at the end of the text box, then enter the other ranges. Use a semicolon as delimiter between ranges.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id1434369" role="paragraph">Click one of the options for data series in rows or in columns.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id7524033" role="paragraph">Check whether the data range has labels in the first row or in the first column or both.</paragraph> + </listitem> +</list> +<paragraph id="par_id5256508" role="paragraph">In the preview you can see how the final chart will look.</paragraph><comment>data range text box & shrinky</comment> +<bookmark branch="hid/modules/schart/ui/tp_RangeChooser/ED_RANGE" id="bm_id2121951" localize="false"/> +<bookmark branch="hid/modules/schart/ui/tp_RangeChooser/IB_RANGE" id="bm_id4829554" localize="false"/> +<h2 id="hd_id111758721055079">Data Range</h2> +<paragraph id="par_id379650" role="paragraph"><ahelp hid=".">Enter the data range that you want to include in your chart. To minimize this dialog while you select the data range in Calc, click the <emph>Select data range</emph> button.</ahelp></paragraph><comment>data series in rows</comment> +<bookmark branch="hid/modules/schart/ui/tp_RangeChooser/RB_DATAROWS" id="bm_id2901699" localize="false"/> +<h2 id="hd_id571758721127837">Data series in rows</h2> +<paragraph id="par_id953703" role="paragraph"><ahelp hid=".">Data series get their data from consecutive rows in the selected range. For scatter charts, the first data series will contain x-values for all series. All other data series are used as y-values, one for each series.</ahelp></paragraph><comment>data series in columns</comment> +<bookmark branch="hid/modules/schart/ui/tp_RangeChooser/RB_DATACOLS" id="bm_id5534226" localize="false"/> +<h2 id="hd_id771758721174244">Data series in columns</h2> +<paragraph id="par_id4496597" role="paragraph"><ahelp hid=".">Data series get their data from consecutive columns in the selected range. For scatter charts, the first data column will contain x-values for all series. All other data columns are used as y-values, one for each series.</ahelp></paragraph><comment>first row as label</comment> +<bookmark branch="hid/modules/schart/ui/tp_RangeChooser/CB_FIRST_ROW_ASLABELS" id="bm_id49134" localize="false"/> +<h2 id="hd_id371758721212931">First row as label</h2> +<paragraph id="par_id2898953" role="paragraph"><ahelp hid=".">For data series in columns: The first row in the range is used as names for data series. For data series in rows: The first row in the range is used as categories. The remaining rows comprise the data series. If this check box is not selected, all rows are data series.</ahelp></paragraph><comment>first column as label</comment> +<bookmark branch="hid/modules/schart/ui/tp_RangeChooser/CB_FIRST_COLUMN_ASLABELS" id="bm_id8939481" localize="false"/> +<h2 id="hd_id631758721239442">First column as label</h2> +<paragraph id="par_id7546311" role="paragraph"><ahelp hid=".">For data series in columns: The first column in the range is used as names for data series. For data series in rows: The first column in the range is used as categories. The remaining columns comprise the data columns. If this check box is not selected, all columns are data columns.</ahelp></paragraph> <section id="relatedtopics"> <embed href="text/shared/guide/chart_insert.xhp#chart_insert"/> <embed href="text/schart/01/wiz_chart_type.xhp#wiz_chart_type"/>
