Issue 28581 - sort column with dates and NULL change some dates with spreadsheet
Summary: sort column with dates and NULL change some dates with spreadsheet
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-04-30 20:41 UTC by dprina
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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)

1) write this 4 lines in column A


2) Select column A

3) push the A->Z sort button

4) what you have is the following four rows:


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

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.

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

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 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:
or consider trying the new OOo 3 BETA (still in testing):
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:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~