Test Case | Manual Testing

Test Case | Manual Testing

Test run summary

Test Date	QA Tester	Browser	Secondary Device	Passed	Failed	Skipped	Total	Issues
03.06.24	Malkenes	Chrome	Iphone 11	2	4	5	11	#39 #40 #41 #42
05.06.24	Konst	Chrome	Samsung Galaxy S21	2	4	3	9	#52 #54
06.06.24	Malkenes	Chrome	Iphone 11	2	6	11	19	#61 #62 #63 #64 #65
07.06.24	Konst	Chrome	Samsung Galaxy S21	2	6	11	19	#52 #54

Test case

Test Case ID	Objective	Steps	Expected Results	Priority
Test suite | UI/UX
TC_NAV_001	Verify intuitive navigation through the application	1. Open the application 2. Examine navigation menu	1. The navigation menu is easy to locate and use 2. Menu items are clearly labeled and logically organized 3. There are no empty links	P2
TC_NAV_002	Verify intuitive navigation within the spreadsheet.	1. Navigate to the spreadsheet 2. Attempt to navigate inside the spreadsheet with common keyboard shortcuts (example arrows) 3. Attempt to navigate outside the spreadsheet with common keyboard shortcuts (example arrow up in cell A1)	1. The spreadsheet navigation is easy to use 2. Cannot navigate outside spreadsheet	P4
TC_LAYOUT_001	Verify consistency of layout across different spreadsheets	1. Navigate to the spreadsheet 2. Take a snapshot of the spreadsheet 3. Open a different spreadsheet	1. The layout elements are consistent across different spreadsheets 2. Elements such as buttons, forms, and links are consistently positioned on the page	P2
TC_VISUAL_001	Verify clear visual hierarchy of information presentation	1. Scan page elements 2. Assess heading structure 3. Evaluate font styles and sizes 4. Examine color contrast	1. Important information is clearly emphasized and presented in a hierarchical manner 2. Headings effectively guide users to different sections of the page 3. Font styles and sizes help distinguish important content 4. Color contrasts are used effectively to draw attention	P2
TC_VISUAL_002	Verify clear visual cell value	1. Navigate to spreadsheet 2. Enter a long string into any cell 3. Click outside cell 4. Observe spreadsheet layout	1. Spreadsheet layout stays consistent	P2
TC_READABILITY_001	Verify readability of text content in the application	1. Scan text content	1. Text content is presented in a manner that is easy to read and comprehend 2. Lines of text maintain an optimal length for readability 3. Paragraph spacing enhances readability by preventing text from appearing crowded	P2
TC_READABILITY_002	Verify readability of text content in form inputs	1. Scan input element 2. attempt to enter values into them	1. Input value is easy to read	P2
TC_RESPONSIVE_001	Verify responsiveness of the application across different screen sizes	1. Simulate different screen sizes by resizing the browser window	1. The application is responsive and adapts seamlessly to various screen sizes 2. The layout adjusts dynamically, maintaining readability and usability on different screen sizes 3. Media elements are appropriately scaled and displayed without distortion	P3
TC_RESPONSIVE_002	Verify responsiveness of the application across different devices	1. Open the application on secondary device (example phone) 2. Verify that all interactive elements, such as buttons and links, are easily accessible and usable	1. All interactive elements remain accessible and usable	P2
TC_FEEDBACK_001	Verify provision of clear feedback for cell interactions	1. Navigate to the spreadsheet 2. Hover over A1 cell 3. Click A1 cell	1. Application provides clear indication that cells are editable 2. Application provides clear indication that A1 cell is in focus 3. Function editor is displaying functions associated with A1 cell	P2
TC_FEEDBACK_002	Verify provision of clear feedback for user actions	1. Scan page for button elements 2. Initiate an action by clicking the button element 3. Observe feedback	1. Application provides clear and timely feedback for user actions 2. Success feedback is provided when actions are completed successfully 3. Error feedback is provided when actions encounter errors, including guidance on resolution	P2
TC_ACCESIBILITY_001	Verify accessibility features of the application for users with disabilities	1. Activate Wave evaluation tool	1. 0 Errors	P4
TC_SEARCH_001	Verify that users can search for data in the cells of the spreadsheet and that the relevant data is displayed correctly	1. Enter "Im a search test" into a cell outside viewport 2. Navigate to search form 3. Enter "Im a search test" and submit form 4. observe spreadsheet and search form	1. Application provides clear indication that search input matches a cell value 2. Application is able to guide user to matching cell	P3
TC_SEARCH_002	Verify that users can understand search form	1. Open an empty spreadsheet 2. Navigate to search form 3. attempt to submit a search input	1. Application provides clear feedback when there are no search results, including guidence on resolution	P3
Test suite | Offline
TC_OFFLINE_MODE_001	Verify that the applications UI stays consistent in offline mode	1. Take a snapshot of the application with network connection 2. Take a snapshot of the application without network connection 3. Compare snapshots	1. Page elements like fonts, icons and images are present or adequately compensated for	P4
TC_OFFLINE_SAVE_001	Verify that the application saves changes while offline	1. Open the application without network connection 2. Enter "test" into A1 cell 3. Close the application 4. Open the application with network connection	1. A1 Cell value is "test"	P3
Test suite | File Operations
TC_IMPORT_001	Verify that application can import supported files	1. Locate import file button 2. Click import file button 3. import a CSV/JSON file	1. Application provides guidence on what file types can be imported 2. Application provides feedback if file has been succesfully imported 3. Error feedback is provided when import encounter errors, including guidance on resolution	P3
TC_IMPORT_002	Verify that the application cannot import unsupported files	1. Locate import file button 2. Click import file button 3. attempt to import a doc file	1. Error feedback is provided when an unsupported filetype is imported 2. Spreadsheet remains unchanged	P5
TC_EXPORT_001	Verify that the application can export files correctly	1. Locate export file button 2. export file as CSV 3. import file in a common spreadsheet application (Excel/Google sheets)	1. Application provides feedback when an export is succesful or encounters an error 2. Imported file is readable in common spreadsheet applications	P5