diff options
author | Bogdan Buzea <buzea.bogdan@libreoffice.org> | 2024-11-25 20:17:27 +0100 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-11-27 12:49:33 +0100 |
commit | ce42a420ae28518aae72e72e06a8d3d8a3f33cc8 (patch) | |
tree | 32c2d93a9320ae0c8331f9f6fceceecca7a6db2c | |
parent | ade9473eb6bb45b83d49c2e77f9448ac638e4425 (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.xhp | 4 | ||||
-rw-r--r-- | source/text/shared/optionen/01040500.xhp | 2 |
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"> |