<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 - Date formatting issue when viewing Calc created .xlsx spreadsheet on iPad/iPhone"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126773">126773</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Date formatting issue when viewing Calc created .xlsx spreadsheet on iPad/iPhone
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</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>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>pab49162@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Found an issue with a spreadsheet created and saved as an .xlsx when viewed on
an iOS device (iPad/iPhone) using the device’s default viewer.
The issue is that the day of the month value in a date is displayed as the
number of days since the beginning of the year. For example, February 4 is
displayed as 2/35/19 instead of 2/4/19.
I believe this is a bug in Calc as an .xlsx spreadsheet created in Microsoft
Excel with the same dates displays correctly on an iOS device (iPad/iPhone)
with the device’s default viewer.
This issue has been observed on multiple iPads and iPhones. However, the date
is displayed correctly in Calc, Excel and an Android’s default spreadsheet
viewer.
Attached to this bug are four files. Two files are similar test case .xlsx
spreadsheets – one created using Calc and the other using Microsoft Excel 2013.
The other two files are screenshots of those two .xlsx spreadsheets when
viewed on an iPad with iOS 12.3.1.
The test case Calc spreadsheet was created using
Version: 6.1.5.2
Build ID: 10(Build:2)
CPU threads: 4; OS: Linux 4.12; UI render: default; VCL: gtk3_kde5;
Locale: en-US (en_US.UTF-8); Calc: group threaded
However, I saw this same issue with .xls and .xlsx spreadsheets creating using
a 5.x version of Calc on Windows 10 as well as the current version on Windows
10.
Steps to Reproduce:
1. View attached file Calc-Created-Spreadsheet.xls on a iOS device using
default speadsheet viewer
Actual Results:
1. The spreadsheet will have the the day of the month value in a date is
displayed as the number of days since the beginning of the year.
Expected Results:
1. The spreadsheet should have the the day of the month value in a date is
displayed as the number of days since the beginning of the month and not the
beginning of the year.
Reproducible: Always
User Profile Reset: No
Additional Info:</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>