Bug 130222 - XLS and XLSX date format lost
Summary: XLS and XLSX date format lost
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-01-27 13:19 UTC by Jonny Grant
Modified: 2020-01-28 22:10 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 Jonny Grant 2020-01-27 13:19:46 UTC 
Easy to reproduce, please verify in latest version of Calc
Ubuntu doesn't have a newer version, I don't install any other package.

1. Create an XLS file
2. Set date as "27 Jan 2020" change the format to D MMM YYYY
3. Fill down 3 cells
4. Delete A2, A3
5. Save the file as XLS or XLSX
6. Open the file, and enter "27 Jan 2020" in A2.
7. Observe the date format was lost, it shows 27/1/2020

This bug seems to be a regression, it worked well for years.

Works fine in ODS
Comment 1 Durgapriyanka 2020-01-27 16:03:34 UTC 
Thank you for reporting the bug. I can not reproduce the bug in

Version: 6.4.0.0.alpha1+ (x86)
Build ID: ec7374ff84c71edfbb30d6e4dc5b486b6df7107f
CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-11-10_21:37:30
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
	

and in

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 2 Roman Kuznetsov 2020-01-28 21:42:27 UTC 
Jonny, please write info from Help-About dialog here as it made it Comment 1
Comment 3 Jonny Grant 2020-01-28 21:45:56 UTC 
(In reply to Roman Kuznetsov from comment #2)
> Jonny, please write info from Help-About dialog here as it made it Comment 1

Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); Calc: group



Can someone confirm this please?
Comment 4 Roman Kuznetsov 2020-01-28 22:04:01 UTC 
(In reply to Jonny Grant from comment #3)
> (In reply to Roman Kuznetsov from comment #2)
> > Jonny, please write info from Help-About dialog here as it made it Comment 1
> 
> Version: 6.0.7.3
> Build ID: 1:6.0.7-0ubuntu0.18.04.10
> CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
> Locale: en-GB (en_GB.UTF-8); Calc: group
> 
> 
> 
> Can someone confirm this please?

Jonny, you use old LibreOffice version and your LibreOffice is from Ubuntu repo. 
Current stable version is 6.3.4.2.
Please download latest LibreOffice version from libreoffice.org/download and install it (read README file in archive), then try retest your problem
Comment 5 Jonny Grant 2020-01-28 22:10:36 UTC 
Ok, let's close this. Sorry I only use official ubuntu packages. You're welcome to encourage them to take a newer package.