<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:vstuart.foote@utsa.edu" title="V Stuart Foote <vstuart.foote@utsa.edu>"> <span class="fn">V Stuart Foote</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Date month and day being reversed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125801">bug 125801</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Component</td>
<td>Calc
</td>
<td>Chart
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>erack@redhat.com
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Date month and day being reversed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125801#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Date month and day being reversed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125801">bug 125801</a>
from <span class="vcard"><a class="email" href="mailto:vstuart.foote@utsa.edu" title="V Stuart Foote <vstuart.foote@utsa.edu>"> <span class="fn">V Stuart Foote</span></a>
</span></b>
<pre>On Windows 10 Home 64-bit en-US with
Version: 6.2.4.2 (x64)
Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Verified user profile set with default Tools -> Options -> Languages Settings
-> Language: Date acceptance patterns of 'M/D/Y;M/D'
Enabling Chart OLE
Selecting and opening the x-axis dialog: on the Scale tab starting date and
ending date show 'MM/DD/YYYY', but on the dialog's Numbers tab the Date ->
Format Code is set to 'DDMMMYY' --which is the format the Chart shows.
With these settings:
using the spin buttons to adjust starting date, the actual date assigned is
erratic--flipping between MMDDYY and DDMMYY format--and looks like subsequent
button spin reparses the date while toggling back. Gets wrong dates as it
passes month threshold.
But, changing the X-Axis Numbers tab Date -> Format Code to 'YY-MM-DD' using
the spin button for the Scale cleanly increments and chart dates are correct
passing month boundaries.
So some weird juxtaposition of Date acceptance patterns and the Date format
used on chart axis?</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>