Bug 122843 - Documentation: Chapter 5 Getting Started with Calc, Page 28, Date and Time Format Change
Summary: Documentation: Chapter 5 Getting Started with Calc, Page 28, Date and Time Fo...
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
6.1.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-01-21 06:39 UTC by russell
Modified: 2019-06-26 02:48 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description russell 2019-01-21 06:39:39 UTC
Page 28 of LO6 - "Chapter 5 Getting Started with Calc" is about data entry from the keyboard, in particular Date and Time. The text from the manual:

============
You can separate the date elements with a slash (/) or a hyphen (–) or use text, for example 10 Oct 2012. The date format automatically changes to the selected format used by Calc.
============

If I enter using mm/dd/yyyy or yyyy/mm/dd the data type is date.  This also corresponds to:

Tools > Options > Language Settings > Languages > Date acceptance patterns

Note: Order of mm, dd, yyyy is important.

Even though yyyy-mm-dd does not appear in the list, if I click Help from this page:

============
Additionally to the date acceptance patterns defined here, every locale accepts input in an ISO 8601 Y-M-D pattern, and since LibreOffice 3.5 that also leads to the YYYY-MM-DD format being applied. Syntax: Y means year, M means month, and D means day, regardless of localization.
============

However, the text says the format 10 Oct 2012 is valid.  When I type 10 Oct 2012 the data type is string not date.  

Unless I'm missing something, I think the "or use text, for example 10 Oct 2012." needs to be removed.

In addition, I'd like to see something mentioned in this area about Locale and Tools > Options > Language Settings > Languages > Date acceptance patterns, and the ISO 8601 format.
Comment 1 Olivier Hallot 2019-06-25 12:39:05 UTC
Bugzilla is not used to report errors in LibreOffice Guides published by the Documentation community.

Errors are reported directly to the documentation mailing list. PLease see this page for joining the doc team for discussions and report your findings:

https://documentation.libreoffice.org/en/join-the-documentation-team/i-want-to-write-technical-books/