summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBogdan Buzea <buzea.bogdan@libreoffice.org>2024-11-25 20:17:27 +0100
committerOlivier Hallot <olivier.hallot@libreoffice.org>2024-11-27 12:49:33 +0100
commitce42a420ae28518aae72e72e06a8d3d8a3f33cc8 (patch)
tree32c2d93a9320ae0c8331f9f6fceceecca7a6db2c
parentade9473eb6bb45b83d49c2e77f9448ac638e4425 (diff)
tdf#131332: Replace custom date formats with ISO 8601
Change-Id: I2f17cb9ffc9704c229f4c2f6dd9c6fb8e0531f42 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/177297 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/guide/year2000.xhp4
-rw-r--r--source/text/shared/optionen/01040500.xhp2
2 files changed, 3 insertions, 3 deletions
diff --git a/source/text/scalc/guide/year2000.xhp b/source/text/scalc/guide/year2000.xhp
index 94001610dd..59d02bc314 100644
--- a/source/text/scalc/guide/year2000.xhp
+++ b/source/text/scalc/guide/year2000.xhp
@@ -18,7 +18,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textscalcguideyear2000xml" indexer="include" status="PUBLISH">
@@ -42,7 +42,7 @@
<paragraph role="listitem" id="par_id3154011" xml-lang="en-US">Under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - General</emph> you can define the century that is used when you enter a year with only two digits. The default is 1930 to 2029.</paragraph>
</listitem>
</list>
-<paragraph role="paragraph" id="par_id3150010" xml-lang="en-US">This means that if you enter a date of 1/1/30 or higher, it will be treated internally as 1/1/1930 or higher. All lower two-digit years apply to the 20xx century. So, for example, 1/1/20 is converted into 1/1/2020.</paragraph>
+<paragraph role="paragraph" id="par_id3150010" xml-lang="en-US">This means that if you enter a date of "1/1/30" or higher, it will be treated internally as 1930-01-01 or higher. All lower two-digit years apply to the 20xx century. So, for example, "1/1/20" is converted into 2020-01-01.</paragraph>
</section>
<section id="relatedtopics">
<embed href="text/scalc/guide/calc_date.xhp#calc_date"/>
diff --git a/source/text/shared/optionen/01040500.xhp b/source/text/shared/optionen/01040500.xhp
index 37117e109f..e7749062d3 100644
--- a/source/text/shared/optionen/01040500.xhp
+++ b/source/text/shared/optionen/01040500.xhp
@@ -76,7 +76,7 @@
<section id="number_recognition">
<paragraph role="paragraph" id="par_id3149481"><ahelp hid="modules/swriter/ui/opttablepage/numformatting">Specifies that numbers entered into a text table cell are recognized and formatted as numbers.</ahelp> Table cells in %PRODUCTNAME Writer can recognize a number when it is represented in one of the number formats available in categories of Numbers, Percent, Currency, Date, Time, Scientific, Fraction and Boolean.</paragraph>
-<paragraph role="paragraph" id="par_id871520543043646">The recognized number is displayed with default number format for table cells, and sets the cell format to the recognized category. For example, if a number is recognized as Date, the cell format category is set to Date. You can set a specific number format for the cell, for example, a date entered as <item type="input">8/3/2018</item> displays as Thursday March 8, 2018 when the cell number format is set to "Friday, December 31, 1999" in the Number Format dialog.</paragraph>
+<paragraph role="paragraph" id="par_id871520543043646">The recognized number is displayed with default number format for table cells, and sets the cell format to the recognized category. For example, if a number is recognized as Date, the cell format category is set to Date. You can set a specific number format for the cell, for example, a date entered as <item type="input">2018-03-08</item> displays as Thursday March 8, 2018 when the cell number format is set to "Friday, December 31, 1999" in the Number Format dialog.</paragraph>
<note id="par_id451520542990536">Recognized Date and Time numbers are converted to internal date and time serial values. Percent numbers are converted internally to their numeric values. Boolean values are converted internally to 0 or 1.</note>
<section id="number_recognition_failed_or_off">