Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.11

 

Test Case AOOTest-325: create an instant filter with VLOOK formula with the sample file [Version : 2]
Author:undefined - 12/03/2014 03:16:42
Summary:

Preconditions:

#:Step actions:Expected Results:
2

Create a new spreadsheet document and input 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 1200
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 spreadsheet

 

3

Apply standard filter on column B from menu 'Data -> Filter -> AutoFilter'

 

Auto Filter successfully apply to column B

 

4

Select any product from filter drop down list.

 


It can work properly without any crash.

 

 

5

Save to ODS format, reload and resave to XLS format, reload

Then close and reopen from MS Excel

The spreadsheet can be successfully load/save to the specified format

Excel can also successfully load the XLS file

 

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

Apache Software Foundation

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

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