AllLangHelp_scalc.mk | 1 source/auxiliary/scalc.tree | 1 source/text/scalc/01/04060109.xhp | 10 - source/text/scalc/guide/r1c1syntax.xhp | 117 ++++++++++++++++++++ source/text/scalc/guide/relativ_absolut_ref.xhp | 2 source/text/shared/optionen/01060900.xhp | 7 - source/text/shared/optionen/detailedcalculation.xhp | 21 ++- 7 files changed, 144 insertions(+), 15 deletions(-)
New commits: commit 2750b2da1cb361a67c0e5c4b8cec8033aa76e45f Author: Olivier Hallot <[email protected]> AuthorDate: Sat Oct 25 20:20:37 2025 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Sun Oct 26 11:21:37 2025 +0100 tdf#166639 R1C1 syntax needs an article Change-Id: Iabfd9cdfafab14750db535cb7e2516c69b9af2b5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/193000 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index c745404409..93bedda859 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -489,6 +489,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/guide/print_landscape \ helpcontent2/source/text/scalc/guide/print_title_row \ helpcontent2/source/text/scalc/guide/printranges \ + helpcontent2/source/text/scalc/guide/r1c1syntax \ helpcontent2/source/text/scalc/guide/relativ_absolut_ref \ helpcontent2/source/text/scalc/guide/remove_duplicates \ helpcontent2/source/text/scalc/guide/rename_table \ diff --git a/source/auxiliary/scalc.tree b/source/auxiliary/scalc.tree index 51c9c24fdd..d98ba82c7a 100644 --- a/source/auxiliary/scalc.tree +++ b/source/auxiliary/scalc.tree @@ -175,6 +175,7 @@ </node> <node id="0811" title="References"> <topic id="scalc/text/scalc/guide/relativ_absolut_ref.xhp">Addresses and References, Absolute and Relative</topic> + <topic id="scalc/text/scalc/guide/r1c1syntax.xhp">R1C1 Reference Syntax</topic> <topic id="scalc/text/scalc/guide/cellreferences.xhp">Referencing a Cell in Another Document</topic> <topic id="scalc/text/scalc/guide/cellreferences_url.xhp">References to Other Sheets and Referencing URLs</topic> <topic id="scalc/text/scalc/guide/cellreference_dragdrop.xhp">Referencing Cells by Drag-and-Drop</topic> diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 63e1ced65a..34cdfef0d7 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -44,11 +44,11 @@ <h2 id="hd_id3146968">ADDRESS</h2> <paragraph id="par_id3155762" role="paragraph"><ahelp hid="HID_FUNC_ADRESSE">Returns a cell address (reference) as text, according to the specified row and column numbers.</ahelp> You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1). You can also specify the name of the sheet.</paragraph> <section id="r1c1"> - <paragraph id="par_id1027200802301348" role="paragraph">For interoperability the ADDRESS and INDIRECT functions support an optional parameter to specify whether the R1C1 address notation instead of the usual A1 notation should be used.</paragraph> + <paragraph id="par_id1027200802301348" role="paragraph">For interoperability the ADDRESS and INDIRECT functions support an optional parameter to specify whether the <link href="text/scalc/guide/r1c1syntax.xhp">R1C1</link> address notation instead of the usual A1 notation should be used.</paragraph> <paragraph id="par_id1027200802301445" role="paragraph">In ADDRESS, the parameter is inserted as the fourth parameter, shifting the optional sheet name parameter to the fifth position.</paragraph> <paragraph id="par_id102720080230153" role="paragraph">In INDIRECT, the parameter is appended as the second parameter.</paragraph> - <paragraph id="par_id102720080230151" role="paragraph">In both functions, if the argument is inserted with the value 0, then the R1C1 notation is used. If the argument is not given or has a value other than 0, then the A1 notation is used. </paragraph> - <paragraph id="par_id1027200802301556" role="paragraph">In case of R1C1 notation, ADDRESS returns address strings using the exclamation mark '!' as the sheet name separator, and INDIRECT expects the exclamation mark as sheet name separator. Both functions still use the dot '.' sheet name separator with A1 notation.</paragraph> + <paragraph id="par_id102720080230151" role="paragraph">In both functions, if the argument is inserted with the value 0, then the <link href="text/scalc/guide/r1c1syntax.xhp">R1C1</link> notation is used. If the argument is not given or has a value other than 0, then the A1 notation is used. </paragraph> + <paragraph id="par_id1027200802301556" role="paragraph">In case of <link href="text/scalc/guide/r1c1syntax.xhp">R1C1</link> notation, ADDRESS returns address strings using the exclamation mark '!' as the sheet name separator, and INDIRECT expects the exclamation mark as sheet name separator. Both functions still use the dot '.' sheet name separator with A1 notation.</paragraph> <paragraph id="par_id1027200802301521" role="paragraph">When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth parameter will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted.</paragraph> <paragraph id="par_id1027200802301650" role="paragraph">When storing a document in ODF 1.0/1.1 format, if ADDRESS functions have a fourth parameter, that parameter will be removed.</paragraph> <note id="par_id102720080230162">Do not save a spreadsheet in the old ODF 1.0/1.1 format if the ADDRESS function's new fourth parameter was used with a value of 0.</note> @@ -67,7 +67,7 @@ <paragraph id="par_id3146096" role="paragraph">3: row (relative); column (absolute) ($A1)</paragraph> <paragraph id="par_id3153334" role="paragraph">4: relative (A1)</paragraph> <paragraph id="par_id1027200802465915" role="paragraph"> - <emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used.</paragraph> + <emph>A1</emph> (optional) - if set to 0, the <link href="text/scalc/guide/r1c1syntax.xhp">R1C1</link> notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used.</paragraph> <paragraph id="par_id3153962" role="paragraph"> <emph>Sheet</emph> represents the name of the sheet. It must be placed in double quotes.</paragraph> <h3 id="hd_id3147299">Example:</h3> @@ -221,7 +221,7 @@ <paragraph id="par_id3154317" role="paragraph"> <emph>Ref</emph> represents a reference to a cell or an area (in text form) for which to return the contents.</paragraph> <paragraph id="par_id1027200802470312" role="paragraph"> - <emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used.</paragraph> + <emph>A1</emph> (optional) - if set to 0, the <link href="text/scalc/guide/r1c1syntax.xhp">R1C1</link> notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used.</paragraph> <note id="par_idN10CAE">If you open an Excel spreadsheet that uses indirect addresses calculated from string functions, the sheet addresses will not be translated automatically. For example, the Excel address in INDIRECT("[filename]sheetname!"&B1) is not converted into the Calc address in INDIRECT("filename#sheetname."&B1).<comment>UFI: for #i34465#</comment></note> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3150608" role="paragraph"> diff --git a/source/text/scalc/guide/r1c1syntax.xhp b/source/text/scalc/guide/r1c1syntax.xhp new file mode 100644 index 0000000000..84a8d3eff1 --- /dev/null +++ b/source/text/scalc/guide/r1c1syntax.xhp @@ -0,0 +1,117 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + + <meta> + <topic id="textscalcguider1c1syntaxxhp" indexer="include" status="PUBLISH"> + <title id="tit">R1C1 Syntax</title> + <filename>/text/scalc/guide/r1c1syntax.xhp</filename> + </topic> +</meta> +<body> + +<bookmark branch="index" id="bm_id221761432823940"> + <bookmark_value>references;R1C1 syntax</bookmark_value> + <bookmark_value>R1C1 syntax;references</bookmark_value> +</bookmark> +<section id="r1c1"> + <h1 id="hd_id581761424980501"><variable id="h1"><link href="text/scalc/guide/r1c1syntax.xhp">R1C1 Reference Syntax for Calc Formulas</link></variable></h1> + <description id="par_id71761424980505">Calc supports both R1C1 and the more widely used A1 notation for cell references.</description> +</section> +<paragraph role="paragraph" id="par_id841761425689779">The R1C1 notation is enabled in %PRODUCTNAME Calc options.</paragraph> +<section id="howtoget"> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id201761425493792">Choose <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Formula - Syntax</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id681761425632852">On the <menuitem>Tools</menuitem> tab, Choose <menuitem>Options - %PRODUCTNAME Calc - Formula - Syntax</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_keyboard"/> + <paragraph role="paragraph" id="par_id751761425479328"><keycode>Alt + F12</keycode>, then <menuitem>%PRODUCTNAME Calc - Formula - Syntax</menuitem>.</paragraph> +</section> +<h2 id="hd_id351761428592153">The R1C1 notation</h2> +<paragraph role="paragraph" id="par_id921761428600825">In the A1 notation, columns are labeled with letters and rows with numbers, whereas the R1C1 notation uses numbers for both columns and rows.</paragraph> +<note id="par_id241761428608425">In R1C1 notation, %PRODUCTNAME Calc displays columns headers as numbers.</note> +<paragraph role="paragraph" id="par_id201761428614033">Therefore, the cell A1 correspond to R1C1, which means row 1 and column 1, and cell A2 correspond to R2C1, that is, row 2 column 1.</paragraph> +<paragraph role="paragraph" id="par_id211761428618385">The real difference comes when writing formulas and use a reference to other cells.</paragraph> +<paragraph role="paragraph" id="par_id131761428622872">In R1C1 notation, cell references are based on their position relative to the active cell.</paragraph> +<paragraph role="paragraph" id="par_id131761428627632">For example, if you reference cell B5 from cell A1, the R1C1 notation displays it as R[4]C[1], indicating four rows down and one column to the right of the active cell.</paragraph> +<paragraph role="paragraph" id="par_id731761428632803">However, if the active cell is C3, the same cell (B5) is referenced as R[2]C[-1], meaning two rows down and one column to the left.</paragraph> +<h2 id="hd_id341761428636872">Use of brackets in R1C1 notation</h2> +<paragraph role="paragraph" id="par_id771761428641224">Brackets indicate the relative offset from the active cell.</paragraph> +<paragraph role="paragraph" id="par_id991761428645367">Positive numbers in brackets represent an offset to the right for columns and downward for rows.</paragraph> +<paragraph role="paragraph" id="par_id681761428648568">Negative numbers in brackets represent an offset to the left for columns and upward for rows.</paragraph> +<note id="par_id191761430190197">If there is no offset for a row or column (i.e., the offset is zero), the zero is omitted in R1C1 notation. For example, a reference to a cell in the same row but two columns to the left is written as RC[-2].</note> +<h2 id="hd_id311761428653016">Absolute and relative references in R1C1 notation</h2> +<paragraph role="paragraph" id="par_id371761428660951">Relative and absolute references are preserved in the R1C1 notation. The table below summarizes the equivalence. The current cell is R3C3 (C3)</paragraph> +<table id="tab_id521761428215456"> + <tablerow> + <tablecell> + <paragraph id="par_id981761428215458" role="tablehead">A1 notation</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id301761428215461" role="tablehead">R1C1 notation</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id261761428215463" role="tablehead">Type of reference</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id791761428215466" role="tablecontent" localize="false" >A1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id81761428215468" role="tablecontent" localize="false" >R[-2]C[-2]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id251761428215471" role="tablecontent">Relative reference</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id821761428317451" role="tablecontent" localize="false" >$A1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id191761428317453" localize="false" role="tablecontent">R[-2]C1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id741761428317455" role="tablecontent">Relative row and absolute column</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id241761428396522" role="tablecontent">A$1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id681761428396524" localize="false" role="tablecontent">R1C[-2]</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id341761428396527" localize="false" role="tablecontent">Absolute row and relative column</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id461761428504774" localize="false" role="tablecontent">$A$1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id291761428504776" localize="false" role="tablecontent">R1C1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id521761428504779" localize="false" role="tablecontent">Absolute reference</paragraph> + </tablecell> + </tablerow> +</table> +<h2 id="hd_id431761430561339">Range expressions in R1C1 notation</h2> +<paragraph role="paragraph" id="par_id161761430576814">As in A1 notation, the range operators work the same way. For example, a formula in cell R1C1 that sums rows 1 to 10 in column 3 is written as =SUM(RC[2]:R[9]C[2]).</paragraph> +<paragraph role="paragraph" id="par_id961761431599251">To calculate the sum of all values in columns 4 to 7, write =SUM(C[3]:C[6]) in R2C1.</paragraph> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id331761431262572" localize="false"><embedvar href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref" markup="ignore"/></paragraph> + <paragraph role="paragraph" id="par_id451761433151307" localize="false"><embedvar href="text/shared/optionen/01060900.xhp#h1" markup="ignore"/></paragraph> +</section> +</body> +</helpdocument> diff --git a/source/text/scalc/guide/relativ_absolut_ref.xhp b/source/text/scalc/guide/relativ_absolut_ref.xhp index e302c97141..936dc45c34 100644 --- a/source/text/scalc/guide/relativ_absolut_ref.xhp +++ b/source/text/scalc/guide/relativ_absolut_ref.xhp @@ -42,6 +42,7 @@ </bookmark> <h1 id="hd_id3156423"><variable id="relativ_absolut_ref"><link href="text/scalc/guide/relativ_absolut_ref.xhp">Addresses and References, Absolute and Relative</link> </variable></h1> +<description id="par_id911761434050095">Describes the differences between absolute and relative reference in Calc cell address.</description> <h2 id="hd_id191672069640769">Cell references</h2> <paragraph role="paragraph" id="par_id451672069651941">An individual cell is fully identified by the sheet it belongs, the column identifier (letter) located along the top of the columns and a row identifier (number) found along the left-hand side of the spreadsheet. On spreadsheets read from left to right, the complete reference for the upper left cell of the sheet is <emph>Sheet.A1</emph>.</paragraph> <h2 id="hd_id211672069771744">Cell ranges</h2> @@ -67,5 +68,6 @@ <section id="relatedtopics"> <embed href="text/scalc/guide/value_with_name.xhp#value_with_name"/><comment>mw changed link target from "address_byname" to "value_with_name"</comment><embed href="text/scalc/guide/address_auto.xhp#address_auto"/> </section> +<paragraph role="paragraph" id="par_id131761432078640" localize="false"><embedvar href="text/scalc/guide/r1c1syntax.xhp#h1" markup="ignore"/></paragraph> </body> </helpdocument> diff --git a/source/text/shared/optionen/01060900.xhp b/source/text/shared/optionen/01060900.xhp index 2856075478..5e6d919f05 100644 --- a/source/text/shared/optionen/01060900.xhp +++ b/source/text/shared/optionen/01060900.xhp @@ -45,8 +45,8 @@ </bookmark> <bookmark branch="hid/modules/scalc/ui/optformula/OptFormula" id="bm_id3149095" localize="false"/> <bookmark branch="hid/modules/scalc/ui/optformula/@@nowidget@@" id="@@nowidget@@" localize="false"/> - <h1 id="hd_id3145071"><link href="text/shared/optionen/01060900.xhp">Formula</link></h1> - <paragraph id="par_id3147576" role="paragraph"><ahelp hid=".">Defines formula syntax options and loading options for %PRODUCTNAME Calc.</ahelp></paragraph> + <h1 id="hd_id3145071"><variable id="h1"><link href="text/shared/optionen/01060900.xhp">Formula Options</link></variable></h1> + <description id="par_id3147576"><ahelp hid=".">Defines formula syntax options and loading options for Calc.</ahelp></description> </section> <section id="howtoget"> <embed href="text/shared/00/00000406.xhp#exopfo"/> @@ -63,7 +63,7 @@ <paragraph id="par_id3147530" role="listitem"><emph>Excel A1</emph> - This is the default of Microsoft Excel. The reference will be <item type="input">=Sheet2!C4</item></paragraph> </listitem> <listitem> - <paragraph id="par_id3153061" role="listitem"><emph>Excel R1C1</emph> - This is the relative row/column addressing, known from Microsoft Excel. The reference will be <item type="input">=Sheet2!R[3]C[2]</item></paragraph> + <paragraph id="par_id3153061" role="listitem"><emph>Excel</emph> <link href="text/scalc/guide/r1c1syntax.xhp"><emph>R1C1</emph></link> - This is the relative row/column addressing, known from Microsoft Excel. The reference will be <input>=Sheet2!R[3]C[2]</input></paragraph> </listitem></list> <h3 id="hd_id31493992">Use English function names</h3> <paragraph id="par_id4155419" role="paragraph">In %PRODUCTNAME Calc function names can be localized. By default, the check box is off, which means the localized function names are used. Checking this check box will swap localized function names with the English ones. This change takes effect in all of the following areas: formula input and display, function wizard, and formula tips. You can of course uncheck it to go back to the localized function names.</paragraph> @@ -120,6 +120,7 @@ </list> <section id="relatedtopics"> <paragraph id="par_id200920171902249043" role="paragraph"><link href="text/scalc/01/04060107.xhp">Array formulas</link></paragraph> + <paragraph role="paragraph" id="par_id131761432078640" localize="false"><embedvar href="text/scalc/guide/r1c1syntax.xhp#h1" markup="ignore"/></paragraph> </section> </body> </helpdocument> diff --git a/source/text/shared/optionen/detailedcalculation.xhp b/source/text/shared/optionen/detailedcalculation.xhp index f5d09372e3..38cd8766dc 100644 --- a/source/text/shared/optionen/detailedcalculation.xhp +++ b/source/text/shared/optionen/detailedcalculation.xhp @@ -11,13 +11,13 @@ <meta> <topic id="detailedcalculation" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">Detailed Calculation</title> + <title id="tit">Detailed Calculation</title> <filename>/text/shared/optionen/detailedcalculation.xhp</filename> </topic> </meta> <body> - <bookmark xml-lang="en-US" branch="index" id="bm_id3146799"> + <bookmark branch="index" id="bm_id3146799"> <bookmark_value>string;conversion to number settings</bookmark_value> <bookmark_value>string conversion to number options</bookmark_value> <bookmark_value>string;conversion to date settings</bookmark_value> @@ -33,13 +33,19 @@ <bookmark_value>Calc A1;cell reference syntax in strings</bookmark_value> </bookmark> <section id="detailed_calculation"> - <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/formulacalculationoptions/FormulaCalculationOptions" id="bm_id2745673" localize="false"/> - <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/formulacalculationoptions/@@nowidget@@" id="@@nowidget@@" localize="false"/> + <bookmark branch="hid/modules/scalc/ui/formulacalculationoptions/FormulaCalculationOptions" id="bm_id2745673" localize="false"/> + <bookmark branch="hid/modules/scalc/ui/formulacalculationoptions/@@nowidget@@" id="@@nowidget@@" localize="false"/> <h1 id="hd_id371535153017185"><variable id="detailed_heading"><link href="text/shared/optionen/detailedcalculation.xhp">Detailed Calculation Settings</link></variable></h1> - <paragraph id="par_id461535153017196" role="paragraph"><variable id="variable name"><ahelp hid=".">Sets the rules for conversion from strings values to numeric values, string values to cell references, and strings values to date and time values. This affects built-in functions such as INDIRECT that takes a reference as a string value or date and time functions that takes arguments as string values in local or ISO 8601 formats.</ahelp></variable></paragraph> + <description id="par_id531761433356780"><variable id="desc"><ahelp hid=".">Sets the rules for conversion from strings values to numeric values, string values to cell references, and strings values to date and time values.</ahelp></variable></description> + <paragraph role="paragraph" id="par_id651761433392516">This affects built-in functions such as INDIRECT that takes a reference as a string value or date and time functions that takes arguments as string values in local or ISO 8601 formats.</paragraph> </section> <section id="howtoget"> - <paragraph role="paragraph" id="par_id2752992"><variable id="sam01">Menu <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Formula</emph>, and in section <emph>Detailed Calculation Settings</emph> press <emph>Details...</emph> button.</variable></paragraph> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id201761425493792">Choose <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Formula</menuitem>, select <menuitem>Custom</menuitem> in Detailed Calculation settings, press <menuitem>Details</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id681761425632852">On the <menuitem>Tools</menuitem> tab, Choose <menuitem>Options - %PRODUCTNAME Calc - Formula</menuitem>, select <menuitem>Custom</menuitem> in Detailed Calculation settings, press <menuitem>Details</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_keyboard"/> + <paragraph role="paragraph" id="par_id751761425479328"><keycode>Alt + F12</keycode>, then <menuitem>%PRODUCTNAME Calc - Formula</menuitem>, select <menuitem>Custom</menuitem> in Detailed Calculation settings, press <menuitem>Details</menuitem>.</paragraph> </section> <h2 id="par_id4238715">Contents to Numbers</h2> <h3 id="par_id8277230">Conversion from text to number</h3> @@ -63,7 +69,7 @@ <paragraph role="listitem" id="par_id300912"><emph>Excel A1</emph></paragraph> </listitem> <listitem> - <paragraph role="listitem" id="par_id9534592"><emph>Excel R1C1</emph></paragraph> + <paragraph role="listitem" id="par_id9534592"><emph>Excel</emph> <link href="text/scalc/guide/r1c1syntax.xhp"><emph>R1C1</emph></link></paragraph> </listitem> <listitem> <paragraph id="par_id811567770857290" role="listitem"><emph>Calc A1 | Excel A1</emph></paragraph> @@ -74,6 +80,7 @@ <section id="relatedtopics"> <paragraph role="paragraph" id="par_id191535211862982"><link href="text/scalc/01/04060102.xhp">Date and time functions</link></paragraph> <paragraph role="paragraph" id="par_id261535211868627"><link href="text/scalc/01/04060109.xhp#Section6">INDIRECT function</link></paragraph> + <paragraph role="paragraph" id="par_id131761432078640" localize="false"><embedvar href="text/scalc/guide/r1c1syntax.xhp#h1" markup="ignore"/></paragraph> </section> </body> </helpdocument>
