Issue 57534

Summary:

Filtering and Sorting not always working in Calc

Product:

Calc

Reporter:

rvolke <rvolke>

Component:

editing

Assignee:

spreadsheet <spreadsheet>

Status:

CLOSED NOT_AN_OOO_ISSUE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues, merschmann, yoshimit

Version:

OOO 2.0 Beta2

Keywords:

oooqa

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Sample file created for testing, exibits the problem	none

Description rvolke 2005-11-08 21:46:08 UTC

When I use OpenOffice Calc to add records to spreadsheets originally created 
with Excel, and then try to filter and/or sort them, many times the rows added 
by using Calc do not filter and/or sort properly.  Is there some way I can 
expand the filtering/sorting range?  I tried selecting all the cells then 
clicking the autofilter but that didn't work either.  I will attach an example 
file.  I have tried getting this to work on versions 109, 125, and the new 2.0 
but so far have been unsuccessful.  I am trying to keep my docs in .xls format 
so that I can send them back and forth to individuals that do not have 
OpenOffice.

Comment 1 rvolke 2005-11-08 21:46:52 UTC

Created attachment 31274 [details]
Sample file created for testing, exibits the problem

Comment 2 merschmann 2005-12-10 16:23:06 UTC

Can confirm on OOo 2.0.1RC4 W2K.
Looks to me if OOo can not handle more than 30 keywords in AutoFilter.

Comment 3 hwoarang 2006-01-02 17:24:54 UTC

As Volkerme said: confirmed.

Hwoarang

Comment 4 frank 2006-01-30 12:06:17 UTC

Hi,

not a bug but a support request. Such questions are answered on the mailinglists
especially users@...

It's a matter of database ranges in conjunction with autofilters. Each
autofilter needs an own database range. Especially if you have defined more than
one in a file. The one in the sample doc is set for  A1:B45 so the filter can
only use data located in this range. To solve this problem, remove the
autofilter, remove the database range by using Data-Define Range or extend the
range in this dialog to cover the range you need. For future extensions insert
rows by selecting the last row and use insert row from the context menu of the
row header.

Frank

Comment 5 frank 2006-01-30 12:06:57 UTC

closed invalid