diff options
Diffstat (limited to 'source/text/scalc/guide/numbers_text.xhp')
| -rw-r--r-- | source/text/scalc/guide/numbers_text.xhp | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/source/text/scalc/guide/numbers_text.xhp b/source/text/scalc/guide/numbers_text.xhp index e63054fb0c..80085077c4 100644 --- a/source/text/scalc/guide/numbers_text.xhp +++ b/source/text/scalc/guide/numbers_text.xhp @@ -33,7 +33,7 @@ <bookmark_value>date formats;conversion</bookmark_value> <bookmark_value>converting;text, into numbers</bookmark_value> </bookmark> - <h1 id="hd_id0908200901265171"><variable id="numbers_text"><link href="text/scalc/guide/numbers_text.xhp" name="Converting Text to Numbers">Converting Text to Numbers</link></variable></h1> + <h1 id="hd_id0908200901265171"><variable id="numbers_text"><link href="text/scalc/guide/numbers_text.xhp">Converting Text to Numbers</link></variable></h1> <section id="text"> <paragraph xml-lang="en-US" id="par_id0908200901265127" role="paragraph">Defaults settings in Calc converts text inside cells to the respective numeric values if an unambiguous conversion is possible. If no conversion is possible, Calc returns a #VALUE! error.</paragraph> <paragraph xml-lang="en-US" id="par_id0908200901265196" role="paragraph"><emph>Only integer numbers including exponent are converted</emph>, and ISO 8601 dates and times in their extended formats with separators. Anything else, like fractional numbers with decimal separators or dates other than ISO 8601, is not converted, as the text string would be locale dependent. Leading and trailing blanks are ignored.</paragraph> @@ -81,12 +81,12 @@ <paragraph role="paragraph" id="par_id611567607779380"><literal>=SUM("1E2";1)</literal> returns #VALUE! because SUM() and some others that iterate over number sequences explicitly check the argument type.</paragraph> </section> <h2 id="hd_id871567772424915">Changing the default text to number conversion settings</h2> - <paragraph role="paragraph" id="par_id111567772433803">The text to number conversion can be customized in the <link href="text/shared/optionen/detailedcalculation.xhp" name="detailed_link">Detailed Calculation Settings</link> option.</paragraph> + <paragraph role="paragraph" id="par_id111567772433803">The text to number conversion can be customized in the <link href="text/shared/optionen/detailedcalculation.xhp">Detailed Calculation Settings</link> option.</paragraph> <section id="relatedtopics"> <embed href="text/shared/optionen/detailedcalculation.xhp#detailed_heading"/> <embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> <embed href="text/scalc/guide/integer_leading_zero.xhp#integer_leading_zero"/> - <paragraph xml-lang="en-US" id="par_id0908200901265544" role="paragraph"><link href="text/shared/01/05020300.xhp" name="Format - Cells - Numbers">Format - Cells - Numbers</link></paragraph> + <paragraph xml-lang="en-US" id="par_id0908200901265544" role="paragraph"><link href="text/shared/01/05020300.xhp">Format - Cells - Numbers</link></paragraph> <embed href="text/scalc/guide/format_value.xhp#format_value"/> </section> </body> |