Issue 68056

Summary: Datapilot column order
Product: Calc Reporter: romolo <romoloman>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kyoshida, pagalmes.lists
Version: OOo 2.0.3   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
sample calc file none

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 
Hi,

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.

Frank
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).

Frank
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 "issues@openoffice.apache.org".