Apache OpenOffice (AOO) Bugzilla – Issue 122113
calc sheet created & running on AOO 3.3.0 doesn't work on AOO 3.4.1 - Filter range & AutoFilter not working properly
Last modified: 2013-04-21 15:39:05 UTC
Created attachment 80564 [details] Dealer Statements The attached sheet is used to generate monthly dealer statements from monthly sales invoices. It uses defined monthly filter ranges, the AutoFilter & defined print ranges to select each dealer's monthly sales and totals which is then printed as a Monthly Statement for each dealer. 1. To use, the dealer information on each invoice is entered in a row of the sheet, for all invoices for the month. 2. All unused Empty Rows are deleted. 3. Check that the proper filter range is selected: Data > Select Range > Month_Filter_Range 4. Enable the AutoFilter on the Labels Row. 5. Filter on the Dealer name in cloumn D. This will hide all but the selected dealers sales and the Totals row, and show the selected dealer's sales, the Dealer's Totals Line, and the summary box at the bottom. This works using AOO 3.3.0 and Jre6U35. However, when using AOO 3.4.1 and Jre7U21 or Jre6U35. In step 5: when the dealer is selected the filter range terminates after the selected dealers last invoice row, which ignores the selected Month_Filter_Range. This hide all rows below the filtered dealers last invoice row, including both total rows. This makes the sheet unusable! I'm running on Windows Vista SP2 fully updated.
Created attachment 80570 [details] filter_problem
i can see the problem: with OO 3.2: January_Filter_Range is $January.$A$4:$L$49 and with AOO 3.4.1: January_Filter_Range is $January.$A$4:$L$50 it seems AOO 3.4.1 extends the filter range automatically, and ignores user definition? have a look at the attachment, if you add an empty row between "Totals" and "Dealer Totals" and set the January_Filter_Range to $January.$A$4:$L$49 it should work.
brinzing - thanks for the comment you are right. you can work around the problem. however, i think the point is that AOO 3.4.1 doesn't work properly. why does it ignore the user definition range and use its own? why do we have to work around a problem that didn't exist in AOO 3.3.0?