Issue 28581

Summary:	sort column with dates and NULL change some dates with spreadsheet
Product:	Calc	Reporter:	dprina <davideprina>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1.1
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description dprina 2004-04-30 20:41:44 UTC

Open a new spreadsheet
write some date in the same column with one or more space between dates, sort
with one sort button (not the menu command) and you have some dates translated
from gregorian date to julian date (all the dates after a blank cell)

example: 
1) write this 4 lines in column A
*********
01/01/11
01/10/22

02/08/20
*********

2) Select column A

3) push the A->Z sort button

4) what you have is the following four rows:
**********
01/01/11
02/08/20
44835

***********

If you use the sort in the date menu you don't have this error.
The error is that the date 01/10/22 is translated as number (julian date), so if
you convert it to date you have the correct one 01/10/22 (gregorian date)

I have tested it with:
OOo 1.1.1 italian version on Windows
OOo 1.1.1-2 italian version on Debina GNU/Linux

Ciao
Davide

Comment 1 frank 2004-05-03 12:18:43 UTC

Hi Eike,

if the empty cell is formatted as date, this problem never arises. Nevertheless
this has to be considered as bug.

Frank

Comment 2 ooo 2004-05-04 13:37:30 UTC

Not simply a bug. The difference between the button behavior and sorting via
dialog is that no formats are moved with the sorted data when using the button,
in the dialog you may choose the behavior under options. The reason is, that not
only number formats are considered to be formats, but also borders, backgrounds,
font attributes and other cell attributes. Not all of them are desired to change
when sorting.

=> enhancement, exact behavior to be specified, reassigning to the User
Experience team.

btw, Dprina: the numbers you see are not Julian day numbers, but serialized date
values, days since "null" date, the null date may be specified under
Tools.Options.Spreadsheet.Calculcate for compatibility with other spreadsheet
applications.

Eike

Comment 3 falko.tesch 2005-10-20 20:22:08 UTC

FT: Re-assigned to requirement default user

Comment 4 ace_dent 2008-05-16 01:40:50 UTC

OpenOffice.org Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 2+ years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
http://download.openoffice.org/index.html
or consider trying the new OOo 3 BETA (still in testing):
http://download.openoffice.org/3.0beta/
 
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
http://www.openoffice.org/issues/query.cgi
 
Many thanks,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html