Bug 138357 - convert problem opening xlsx file in Calc with calender
Summary: convert problem opening xlsx file in Calc with calender
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-11-20 06:34 UTC by Nicolaas Turubassa
Modified: 2020-11-22 07:22 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Excel file gets mixed up when opening directly in Calc. (35.08 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-11-20 06:39 UTC, Nicolaas Turubassa 		Details
calendar issue in Calc explained (59.46 KB, application/pdf)
2020-11-20 08:05 UTC, Nicolaas Turubassa 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Nicolaas Turubassa 2020-11-20 06:34:28 UTC 
Description:
When I open an Excel file (xlsx)in Calc. the calender in the file gets mixed up.
I have to covert/save it in Excel first as an ods file. Using this extra step before opening the file in Calc. the file is not mixed up, and is showing the everything correctly.  

Actual Results:
In Calc. the spreadsheet dis showing the calander days incorrectly.

Expected Results:
The spreadsheet should have shown the calender days correctly as it's shown in the Excel file after opening it directly in Calc.


Reproducible: Always


User Profile Reset: No



Additional Info:
I want to add the excel file as an attachment, but I don't see an option to do that. Hopefully after I click on the 'Submit Bug Report'.
Comment 1 Nicolaas Turubassa 2020-11-20 06:39:51 UTC 
Created attachment 167408 [details]
Excel file gets mixed up when opening directly in Calc.

This calender days in theexcel file gets mixed ip when opening directly in Calc.
Comment 2 zcrhonek 2020-11-20 07:48:51 UTC 
Hello,
please write exactly what is wrong. Also printscreen from excel might help. Thank you
Comment 3 Nicolaas Turubassa 2020-11-20 08:05:21 UTC 
Created attachment 167411 [details]
calendar issue in Calc explained

See pdf attachment for explanation issue.
Hopefully this will help.
Comment 4 Timur 2020-11-20 15:12:41 UTC 
See if duplicate ofb ug 129980.
Comment 5 Nicolaas Turubassa 2020-11-21 10:24:05 UTC 
Hi all,

I found the reason why the calendar in the Excel spreadsheet got mixed up when opening directly in Calc. It's because the owner of the excel spreadsheet entered a wrong date in cel B3, B29, B55, AI3, A142 and AI68.
In all these cells the owner entered 1-1-1900 as a date, instead of 1-1-2021, 1-3-2021 etc. etc..
(Don't ask me why the owner did that.)

So, there is no issue anymore.


Regards,
Nicolaas
Comment 6 QA Administrators 2020-11-22 04:34:51 UTC Comment hidden (obsolete)