Issue 68565 - AutoFill fails when an element is in more than one Sort List
Summary: AutoFill fails when an element is in more than one Sort List
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-08-13 10:27 UTC by Andrea Pescetti
Modified: 2017-05-20 11:13 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Andrea Pescetti 2006-08-13 10:27:21 UTC 
1. Open a new Calc Document.
2. Tools -> Options -> OOo Calc -> Sort Lists.
3. Create a new list with entries "aa", ""bb", "cc", "dd"; then Add, OK.
4. Write "aa" in A1, "bb" in A2. Select A1-A2 and drag onto A3-A10.
5. Cells A3-A10 are filled with "cc", "dd", "aa", "bb", ... as expected.
6. Tools -> Options -> OOo Calc -> Sort Lists.
7. Create a new list with entries "aa", ""ee", "ii", "oo", "uu"; then Add, OK.
8. Write "aa" in B1, "ee" in B2. Select B1-B2 and drag onto B3-B10.

Expected:
9. Cells B3-B10 are filled with "ii", "oo" and values from the second sort list.

Actual:
9. Cells B3-B10 are filled with "aa" and "ee" repeated.

So OOo gets confused by the element "aa" appearing in two sort lists; if you
remove the first sort list, everything work as expected.

Note that this problem appears in a default Italian install, as "mar", which is
an abbreviation for both "Martedì" (Tuesday) and "Marzo" (March), appears in two
sort lists.

[Found during discussion on issue 68057]
Comment 1 delorea 2006-09-07 19:56:07 UTC 
Confirmed
Comment 2 frank 2006-09-19 14:21:37 UTC 
Hi Eike,

your construction site ?

Frank
Comment 3 ooo 2006-09-25 13:26:00 UTC 
Accepted.
Comment 4 Marcus 2017-05-20 11:13:14 UTC 
Reset assigne to the default "issues@openoffice.apache.org".