Bug 35655

Summary:	CSV didn't conserved date format initial on four digits
Product:	LibreOffice	Reporter:	Ydy <skerzreks>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INVALID
Severity:	normal
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Ydy 2011-03-25 05:22:15 UTC

Hi,
This text is automaticaly translated french to english with google translating.

Explanation:
1. Create a CSV files and edit the first line like this:
"This is a date",01/02/2003,"Year on 4 digits".
Save the files (CSV extention)

2. Open a new spreadsheet with LibreOffice and import the CSV file.
In the spreadsheet append a new line with new data.

3. Save file and clic on "Conserved file format" in the information box.

4. Reopening CSV file with an editor and look at the date format. 

The digits of the year are 2 digits while the initial format was on 4 digits.

This is a real problem because if the csv file is a configuration file for an other program, this program will not operate correctly.

Comment 1 Björn Michaelsen 2011-12-23 11:42:58 UTC

[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html

Comment 2 Florian Reisinger 2012-08-14 13:57:15 UTC

Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian

Comment 3 Florian Reisinger 2012-08-14 13:58:36 UTC

Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian

Comment 4 Florian Reisinger 2012-08-14 14:03:09 UTC

Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian

Comment 5 Florian Reisinger 2012-08-14 14:05:24 UTC

Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian