<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Documentation: Chapter 5 Getting Started with Calc, Page 28, Date and Time Format Change"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122843">122843</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Documentation: Chapter 5 Getting Started with Calc, Page 28, Date and Time Format Change
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Documentation
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>prusselltechgroup@gmail.com
</td>
</tr>
<tr>
<th>CC</th>
<td>olivier.hallot@documentfoundation.org
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>