[Libreoffice-bugs] [Bug 126773] New: Date formatting issue when viewing Calc created .xlsx spreadsheet on iPad/iPhone

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 126773
           Summary: Date formatting issue when viewing Calc created .xlsx
                    spreadsheet on iPad/iPhone
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: pab49162 at hotmail.com

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:

-- 
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/20190808/7ed6f9fa/attachment.html>