https://bugs.freedesktop.org/show_bug.cgi?id=47508
Bug #: 47508
Summary: FILTER: Advanced Filter Macro worked in 3.4.5, but not
in 3.5.1
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.1 Release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Problem description:
Advanced_Filter Macro copied ALL the data on Data Sheet to Copy_OutPut_Sheet.
In v3.4.5 and prior, only Filtered Data are copied to the Copy_Output_Sheet
Steps to reproduce:
1. Define Advanced_Filter Macro based on Proforma Macro from Chapter 13 "Calc
as a Simple Database", Page 16, Listing 7.
2. Database Range and Criteria Range are tailored:
oDataRange=oDataSheet.getCellRangebyName(A1:J1500)
oCritRange=oCritSheet.getCellRangebyName(A1:A2)
There is just 1 Field (Cell A1) and 1 Criteria (Cell A2).
Filter_Descriptor are tailored to Copy Output_Data to CopyOutSheet Cell A1:
xx.Column= 0
xx.Row= 0
oFiltDesc.OoutputPosition= xx
3. Run Macro
Current behavior:
- ALL the data on oDataSheet are copied to CopyOutSheet
Expected behavior:
- in 3.4.5 and prior version, the Filtered Data are copied to CopyOutSheet
Platform (if different from the browser):
- Linux
Browser: Mozilla/5.0 (X11; Linux i686; rv:10.0) Gecko/20100101 Firefox/10.0
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
