{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Public site","Backend"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Public site","index":0,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,0,4,6],[23,0,23,6]]}
["Test ID","Test name","Test description","Test tags","Pre-conditions","Steps","Result"]
[1,"Double selection of an item","An item should not appears twice in the cart","Priority:1","Preview site should be open\nUser should be logged in","Open an item page\nAdd it to the basket\nAdd it again to the cart\nGo to the cart page","Item should appear only once in the cart with a count of two"]
[2,"Removing an item from the basket","It is possible to remove an item from the cart.\nA confirmation should be displayed.","Priority:1\nCriticity:4","1. Preview site should be open\n2. User should be logged-in\n3. Basket should be empty","1) Open an item page\n2) Add it to the basket\n3) Go to the cart page\n4) Click on the trash icon in front of the item\n5) Answer yes to the pop-up ","1 - cart is empty\n2 - A link appears to undo the action "]
[]
["Registration process"]
[]
[3,"Nominal case","The most common scenario.","Priority:3","Preview site should be open","Click on the “Register” link","The register pop-up appears"]
[null,null,null,"Criticity:42","User should not be logged-in","Fill in email address “joe-ddmmyy@example.com” (ddmmyy is based on today's date)"]
[{"$nulls":5},"Fill password “hello123”","A message saying the password is not strong appears"]
[{"$nulls":5},"Fill password “st0nGP4s3W0RD”","The message dissapears"]
[{"$nulls":5},"Fill password confirmation “st0nGP4s3W0RD”"]
[{"$nulls":5},"Click on the “Register” button","A message appears saying to check email for confirmation link"]
[]
[null,"Existing email","An error appears if the email is in use","Priority:2","Preview site should be open","Click on the “Register” link","The register pop-up appears"]
[null,null,null,"Criticity:16","User is not logged in","Fill in email address “existing@example.com”"]
[{"$nulls":5},"Fill password “st0nGP4s3W0RD”"]
[{"$nulls":5},"Fill password confirmation “st0nGP4s3W0RD”"]
[{"$nulls":5},"Click on “Register” button","The pop-up is still open"]
[{"$nulls":6},"Registration form is still visible and data are kept"]
[{"$nulls":6},"A message says that email is already in use"]
[{"$nulls":6},"A link is provided to go to the login page"]
[{"$nulls":6},"A link is provided to get the password back"]
[]
["Order status"]
[]
[null,"Status can be followed for each order","There is several statuses available:","Priority: 2","Preview site should be open","Add an item in the cart"]
[null,null,"- in preparation",null,"User is logged in","Go to the cart page"]
[null,null,"- sent",null,null,"Validate command"]
[null,null,"- received",null,null,"Go to the “My commands” tab","The new command is displayed"]
[{"$nulls":6},"Its status is “in preparation”"]
[{"$nulls":5},"With another browser, open the backend and notify the command as sent"]
[{"$nulls":5},"Refresh the “My commands” tab","The command status is “sent”"]
[{"$nulls":5},"In the backend, notify the ommand reception"]
[{"$nulls":5},"Refresh the “My commands” tab","The command status is “Received”"]

{"sheet":"Backend","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,0,5,6]]}
["Test ID","Test name","Test description","Test tags","Pre-conditions","Steps","Result"]
[]
[1,"User password is not accessible","The user's password can not be accessed by people using the backend",null,"Log-in as admin/admin in test backend","In the test site, register as a new user"]
[{"$nulls":4},"Open another browser on the test site","In the backend, select the newly created user","Password is not shown"]
[]
["User management"]
[]
[2,"user password can be reseted",null,null,"Log-in as admin/admin in the test backend","Select the user “joe@exmaple.com”"]
[{"$nulls":5},"Click on reset password"]
[{"$nulls":5},"Open the “Latest emails” tab","An email appears sent to “joe@example.com” with a link to reset the password"]