Apache OpenOffice (AOO) Bugzilla – Issue 57534
Filtering and Sorting not always working in Calc
Last modified: 2006-01-30 12:06:57 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.
Created attachment 31274 [details] Sample file created for testing, exibits the problem
Can confirm on OOo 2.0.1RC4 W2K. Looks to me if OOo can not handle more than 30 keywords in AutoFilter.
As Volkerme said: confirmed. Hwoarang
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
closed invalid