https://issues.apache.org/ooo/show_bug.cgi?id=122113
Bug ID: 122113
Issue Type: DEFECT
Summary: calc sheet created & running on AOO 3.3.0 doesn't work
on AOO 3.4.1 - Filter range & AutoFilter not working
properly
Classification: Application
Product: Calc
Version: AOO 3.4.1
Hardware: All
OS: Windows Vista
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: editing
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 80564
--> https://issues.apache.org/ooo/attachment.cgi?id=80564&action=edit
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
