Skip to main content

Test Scenarios for Excel Export Functionality

1. The file should get exported in the proper file extension.
2. The file name for the exported Excel file should be as per the standards e.g. if the file name is using the timestamp, it should get replaced properly with an actual timestamp at the time of exporting the file.
3. Check for date format if exported Excel file contains the date columns.
4. Check number formatting for numeric or currency values. Formatting should be the same as shown on the page.
5. The exported file should have columns with proper column names.
6. Default page sorting should be carried in the exported file as well.
7. Excel file data should be formatted properly with header and footer text, date, page numbers etc. values for all pages.
8. Check if the data displayed on a page and exported Excel file is the same.
9. Check export functionality when pagination is enabled.
10. Check if export button is showing proper icon according to the exported file type E.g. Excel file icon for xls files
11. Check export functionality for files with a very large size.
12. Check export functionality for pages containing special characters. Check if these special characters are exported properly in the Excel file.

Comments

Popular posts from this blog

Software Testing Documents

Software Testing Documents- I) Test Policy (Company Level Document) 1) Test Definition              (Verification & Validation) 2) Testing Process (Proper planning before starts testing) 3) Testing Standards 4) Testing Measurements (QAM, TTM, PCM) 5) Risks 6) Approvals 7) Comments 8) Revision History -------------------------------------------------------- II) Test Strategy (Company Level Document) Table of Contents 1.0    Introduction 2.0    Objective 3.0    Scope of the Document 4.0    Test Approach 4.1              Introduction 4.2              Functional and Usability Issues 5.0        Phases of Testing 5.1        ...

Introduction to Apache JMeter

Apache JMeter is a great open source application with awesome testing abilities. Web Server is a platform which carries loads of numbers of applications and users, so that it is necessary to know that how does it works or performs means; how effective it is to handle simultaneous users or applications. For example; how the “Gmail” supporting server will perform when numbers of users simultaneous access the Gmail account – basically have to do performance testing using performance testing tools like JMeter, Loadrunner etc. To check the high performance of the application or server, do high performance testing using JMeter for exceptional results. Before understanding Overview of JMeter , let us have a look on three testing approach, Performance Test : This test provides the best possible performance of the system or application under a given configuration of infrastructure. Very fast, it also highlights the change need to be made before application goes into prod...

Testing Artifacts

TEST PLAN Fundamentals TEST PLAN DEFINITION A Software Test Plan is a document describing the testing scope and activities. It is the basis for formally testing any software/product in a project. ISTQB Definition test plan : A document describing the scope, approach, resources and schedule of intended test activities. It identifies amongst others test items, the features to be tested, the testing tasks, who will do each task, degree of tester independence, the test environment, the test design techniques and entry and exit criteria to be used, and the rationale for their choice,and any risks requiring contingency planning. It is a record of the test planning process. master test plan : A test plan that typically addresses multiple test levels. phase test plan : A test plan that typically addresses one test phase. TEST PLAN TYPES One can have the following types of test plans: Master Test Plan: A single high-level te...