[Libreoffice-bugs] [Bug 122843] New: Documentation: Chapter 5 Getting Started with Calc, Page 28, Date and Time Format Change

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Jan 21 06:39:39 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=122843

            Bug ID: 122843
           Summary: Documentation: Chapter 5 Getting Started with Calc,
                    Page 28, Date and Time Format Change
           Product: LibreOffice
           Version: 6.1.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Documentation
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: prusselltechgroup at gmail.com
                CC: olivier.hallot at documentfoundation.org

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190121/aeed6f54/attachment.html>


More information about the Libreoffice-bugs mailing list