diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-08-24 15:04:36 -0300 |
|---|---|---|
| committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2018-08-27 15:51:09 +0200 |
| commit | 518f86fcc222c145c837f1e2e83e56128a30ed59 (patch) | |
| tree | f4d98fd92087355b0c6ead005de69b2fae4c5bf5 /source/text/scalc/01/04060102.xhp | |
| parent | 1c16bb2afae897a016f1839e9e2abc0591ae8d26 (diff) | |
Review date and time functions help pages
fix some formatting issues
Add note and warning on date parsing
Mute l10n in some tables with constants
Change-Id: I86b4e7651ac89e2d2c8e2e658a8bdfd8f185ab60
Reviewed-on: https://gerrit.libreoffice.org/59582
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source/text/scalc/01/04060102.xhp')
| -rw-r--r-- | source/text/scalc/01/04060102.xhp | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060102.xhp b/source/text/scalc/01/04060102.xhp index 66cd568d57..850f0a45fb 100644 --- a/source/text/scalc/01/04060102.xhp +++ b/source/text/scalc/01/04060102.xhp @@ -91,7 +91,12 @@ <paragraph id="hd_id757469" role="heading" level="2" xml-lang="en-US">Two digits years</paragraph> <paragraph id="par_id3149720" role="paragraph" xml-lang="en-US">In <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph> </caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - General</emph> you find the area <emph>Year (two digits)</emph>. This sets the period for which two-digit information applies. Note that changes made here have an effect on some of the following functions.</paragraph> +<section id="datenumberinfo"> <paragraph id="par_id3150654" role="note" xml-lang="en-US">When entering dates as part of formulas, slashes or dashes used as date separators are interpreted as arithmetic operators. Therefore, dates entered in this format are not recognized as dates and result in erroneous calculations. To keep dates from being interpreted as parts of formulas use the DATE function, for example, DATE(1954;7;20), or place the date in quotation marks and use the ISO 8601 notation, for example, "1954-07-20". Avoid using locale dependent date formats such as "07/20/54", the calculation may produce errors if the document is loaded under different locale settings.</paragraph> +</section> +<section id="datenumberwarn"> + <paragraph xml-lang="en-US" id="par_id571535118151091" role="tip">Unambiguous conversion is possible for ISO 8601 dates and times in their extended formats with separators. If a <emph>#VALUE!</emph> error occurs, then unselect <emph>Generate #VALUE! error</emph> in <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline> <emph>- %PRODUCTNAME Calc - Formula</emph>, button <emph>Details...</emph> in section "Detailed Calculation Settings", <emph>Conversion from text to number</emph> list box.</paragraph> +</section> <paragraph id="par_idN1067A" role="heading" level="2" xml-lang="en-US">Functions</paragraph> <sort order="asc"> |