The Free and Open Productivity Suite
Apache OpenOffice 4.1.7 released


Test Case AOOTest-324: CoreFunction(Filter-)Standard Filter)_Copy result to [Version : 2]
Author:undefined - 12/03/2014 03:00:22


#:Step actions:Expected Results:

Create a spreadsheet document then create below data in range A1:C24.


Month Product Sales
Jan A 1200
Jan A 1500
Jan A 1800
Jan A 1600
Jan B 1200
Jan B 1500
Jan B 1800
Feb A 1300
Feb A 1900
Feb B 2100
Feb B 2000
Feb C 1500
Feb C 1700
Feb B 1800
Feb B 1900
Mar B 1400
Mar B 1500
Mar C 1200
Mar C 1200
Mar A 1800
Mar A 1400
Mar A 1600
Mar C 1300


Data successfully created in the new spreadsheet




Select the whole data range then Select main menu 'Data->Filter->Standard Filter'

Pop up 'Standard Filter' dialog


Set the Filtering options in 'Operator', 'Field name', 'Condition' and 'Value' as:

Operator    Field Name    Condition   Value

    --              Month              <>             Jan

   AND         Product             ==              A




Click 'OK' button to close 'Standard Filter' dialog

Results should be displayed at the original area.


Click Undo/Redo several times

The prevous actions could be undo/redo successfully


Execution type:Manual
Test Focus:
Feature first available at which release:
Automation script name:
Testsuite set:
Requirements None
Keywords: None

Apache Events

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.