From 0ecc00617e7b93d3869ea7d77c777ebe47db9896 Mon Sep 17 00:00:00 2001 From: Bogdan Buzea Date: Mon, 25 Nov 2024 19:41:03 +0100 Subject: tdf#131332: Replace custom date formats with ISO 8601 Change-Id: I350334e689e6116465bbca4821e21a3046c0ce9c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/177293 Reviewed-by: Olivier Hallot Tested-by: Jenkins --- source/text/shared/optionen/01060500.xhp | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'source/text') diff --git a/source/text/shared/optionen/01060500.xhp b/source/text/shared/optionen/01060500.xhp index 563494411f..60dbcd7ea6 100644 --- a/source/text/shared/optionen/01060500.xhp +++ b/source/text/shared/optionen/01060500.xhp @@ -33,8 +33,8 @@ iterative references in spreadsheets recursions in spreadsheets dates; default (Calc) - dates; start 1900/01/01 (Calc) - dates; start 1904/01/01 (Calc) + dates; start 1900-01-01 (Calc) + dates; start 1904-01-01 (Calc) case sensitivity;comparing cell contents (Calc) decimal places displayed (Calc) precision as shown (Calc) @@ -128,14 +128,14 @@ Select the start date for the internal conversion from days to numbers. -

12/30/1899 (default)

- Sets 12/30/1899 as day zero. +

1899-12-30 (default)

+ Sets 1899-12-30 as day zero. -

01/01/1900 (StarCalc 1.0)

- Sets 1/1/1900 as day zero. Use this setting for StarCalc 1.0 spreadsheets containing date entries. +

1900-01-01 (StarCalc 1.0)

+ Sets 1900-01-01 as day zero. Use this setting for StarCalc 1.0 spreadsheets containing date entries. -

01/01/1904

- Sets 1/1/1904 as day zero. Use this setting for spreadsheets that are imported in a foreign format. +

1904-01-01

+ Sets 1904-01-01 as day zero. Use this setting for spreadsheets that are imported in a foreign format.

Case sensitive

Specifies whether to distinguish between upper and lower case in texts when comparing cell contents. -- cgit