Issue 68056 - Datapilot column order
Summary: Datapilot column order
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial with 6 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-08-02 01:17 UTC by romolo
Modified: 2017-05-20 11:11 UTC (History)
3 users (show)

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

sample calc file (8.75 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-08-02 01:18 UTC, romolo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description romolo 2006-08-02 01:17:50 UTC
Ordering datapilot columns by cells containing a month name jan,feb... (or in 
italian gen feb)  doesn't work. 
Only alphabetical order is applied even if the source cell is formatted as MMM. 
It should be auspicable in such cases to order even by user defined order lists.
Comment 1 romolo 2006-08-02 01:18:45 UTC
Created attachment 38190 [details]
sample calc file
Comment 2 dprina 2006-08-12 12:01:45 UTC
It can be solved adding the functionally:
Data -> Sort -> Options -> Custom sort order
also in:
Data -> Data Pilot -> Start -> Options -> Options -> Sort by
Comment 3 corandrea 2006-08-14 07:46:44 UTC
*** Issue 68056 has been confirmed by votes. ***
Comment 4 frank 2006-08-23 15:07:49 UTC

this is not a bug and also not an enhancement requeest.

The column Month used in the example is nothing else than text and therefore the
sort in alphabetical order is exactly what should apply. If you enter 01/01/06
instead of gen and 01/02/06 instead of feb and use the options on the month in
the datapilot dialog it will work as you expect.

Comment 5 frank 2006-08-23 15:08:35 UTC
closed invalid
Comment 6 romolo 2006-08-24 07:44:44 UTC
I would not consider asking to allow also custom ordering invalid, it's the 
only plase in which you cannot order by custom list. 
So please reopen and consider the votes instead of closing as invalid.
It's really a big limitation in use.
Comment 7 frank 2006-08-24 11:47:46 UTC
hi Niklas,

the enhancement would be to act like Excel. They sort Months automatically
according to the months list and allways before other data (jan feb xxx).

Comment 8 niklas.nebel 2007-12-04 18:07:25 UTC
retarget 2.x -> 3.x
Comment 9 Marcus 2017-05-20 11:11:06 UTC
Reset assigne to the default "".