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
Summary: calc sheet created & running on AOO 3.3.0 doesn't work on AOO 3.4.1 - Filter ...
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.4.1
Hardware: All Windows Vista
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-04-21 04:28 UTC by decraven
Modified: 2013-04-21 15:39 UTC (History)
2 users (show)

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

Dealer Statements (258.82 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-04-21 04:28 UTC, decraven
no flags Details
filter_problem (112.99 KB, image/png)
2013-04-21 13:40 UTC, Oliver Brinzing
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description decraven 2013-04-21 04:28:57 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.
Comment 1 Oliver Brinzing 2013-04-21 13:40:27 UTC
Created attachment 80570 [details]
Comment 2 Oliver Brinzing 2013-04-21 13:43:37 UTC
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.
Comment 3 decraven 2013-04-21 15:39:05 UTC
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?