summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2019-01-16 13:58:23 -0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2019-01-18 11:05:58 +0100
commit074bfa0b64aafdfad465293c689e17230b4ccedc (patch)
treed8eab5b7c3ca3749fd56bb31eb2ad22576471d49
parent3c489aa0b0f2108d1f7bd69a94431921797eedf3 (diff)
tdf#121781 Clarify TZ info in Calc functions
Notify user that TZ are not considered in date & time functions and in date & time formatted cells. Change-Id: I684039ebcc095fe4eefc2bf573df18679dd7f9f3 Reviewed-on: https://gerrit.libreoffice.org/66468 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/01/04060102.xhp2
1 files changed, 2 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060102.xhp b/source/text/scalc/01/04060102.xhp
index 850f0a45fb..ceb61d0484 100644
--- a/source/text/scalc/01/04060102.xhp
+++ b/source/text/scalc/01/04060102.xhp
@@ -98,6 +98,8 @@
<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>
+<note id="par_id651547654187646">Time zone information is not used in Date and Time functions and cells.</note>
+
<paragraph id="par_idN1067A" role="heading" level="2" xml-lang="en-US">Functions</paragraph>
<sort order="asc">