https://bugs.freedesktop.org/show_bug.cgi?id=68108
Priority: medium
Bug ID: 68108
Keywords: regression
Assignee: [email protected]
Summary: FORMATTING: LibreOffice Calc - Date Sorting Issue
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 84049
--> https://bugs.freedesktop.org/attachment.cgi?id=84049&action=edit
Sample spreadsheet with date column to be imported using the process above.
Problem description:
LibreOffice Calc does not sort date fields properly regardless of the format of
the column if the spreadsheet is imported using the default (Standard) column
formats. This behavoir does not occur in v3.5.7.2 on Ubuntu or v3.4.1 on
Windows XP. It only appears to occur on Windows 7 / v4.1.0.4.
Steps to reproduce:
1. Double-click to open the attached spreadsheet (1 column of dates)
2. Ensure that the following is set:
- Character Set is Western 1280 or Unicode (UTF-8)
- Separator = Comma
- Quoted field as text = OFF
- Detect special numbers = ON
- DO NOT change any column types
3. Click on the column heading, select Sort. Ensure the following:
- Sort by Field Name 'Date', ascending
- Under Options,
'Range contains column labels' = ON
'Include formats' = ON (doesn't seem to matter)
'Enable natural sort' = OFF (doesn't seem to matter)
4. Click OK
On a Windows 7 machine with 4.1.0.4, it will sort as text
EX: 01/01/2000
01/01/2010
02/01/2000
02/01/2010
...
Ubuntu / Windows XP with the 3.x base, it will sort properly.
To get it to work in Windows 7, you MUST select DATE(M/D/Y) as a column format
when doing the initial import (step 2). Follow all the other steps and it will
sort as dates.
Current behavior:
Sorts values as text or numeric, but not date. It appears to put a ' in front
of the date field in Windows 7 only.
Expected behavior:
Sort dates as date and not text.
Operating System: Windows 7
Version: 4.1.0.4 release
Last worked in: 3.4 all versions
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
