{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Cut Error","Area Size","Merged Cell","Conditional Formatting","Clipboard","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Dataset","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Daily Sales- Fruits Section"]
[]
[null,"Product","Customer","Quantity","Unit Price","Amount"]
[null,"Apple","Jonas",25,3,75]
[null,"Orange","Harry",14,3,42]
[null,"Guava","Nick",15,4,60]
[null,"Coconut","Sara",5,6,30]
[null,"Apricot","John",20,5,100]
[null,"Watermelon","Leon",8,7,56]
[null,"Jackfruit","Tom",25,6,150]
[null,"Kiwi","Hardy",12,9,108]
[null,"Lemon","Mark",6,3,18]
[null,"Avocado","Chris",10,10,100]

{"sheet":"Cut Error","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Cut Error for Multiple Selections"]
[]
[null,"Product","Customer","Quantity","Unit Price","Amount"]
[null,"Apple","Jonas",25,3,{"$f":"D5*E5","v":75}]
[null,"Orange","Harry",14,3,{"$f":"D6*E6","v":42}]
[null,"Guava","Nick",15,4,{"$f":"D7*E7","v":60}]
[null,"Coconut","Sara",5,6,{"$f":"D8*E8","v":30}]
[null,"Apricot","John",20,5,{"$f":"D9*E9","v":100}]
[null,"Watermelon","Leon",8,7,{"$f":"D10*E10","v":56}]
[null,"Jackfruit","Tom",25,6,{"$f":"D11*E11","v":150}]
[null,"Kiwi","Hardy",12,9,108]
[null,"Lemon","Mark",6,3,18]
[null,"Avocado","Chris",10,10,100]

{"sheet":"Area Size","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Cut and Paste Area Size Doesn't Match"]
[]
[null,"Product","Customer","Quantity","Unit Price","Amount"]
[null,"Apple","Jonas",25,3,{"$f":"D5*E5","v":75}]
[null,"Orange","Harry",14,3,{"$f":"D6*E6","v":42}]
[null,"Guava","Nick",15,4,60]
[null,"Coconut","Sara",5,6,30]
[null,"Apricot","John",20,5,100]
[null,"Watermelon","Leon",8,7,56]
[null,"Jackfruit","Tom",25,6,150]
[null,"Kiwi","Hardy",12,9,108]
[null,"Lemon","Mark",6,3,18]
[null,"Avocado","Chris",10,10,100]

{"sheet":"Merged Cell","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Cut and Paste Problem for Merged Cell"]
[]
[null,"Product","Customer","Quantity","Unit Price","Amount"]
[null,"Apple","Jonas",25,3,{"$f":"D5*E5","v":75}]
[null,"Orange","Harry",14,3,{"$f":"D6*E6","v":42}]
[null,"Guava","Nick",15,4,60]
[null,"Coconut","Sara",5,6,30]
[null,"Apricot","John",20,5,100]
[null,"Watermelon","Leon",8,7,56]
[null,"Jackfruit","Tom",25,6,150]
[null,"Kiwi","Hardy",12,9,108]
[null,"Lemon","Mark",6,3,18]
[null,"Avocado","Chris",10,10,100]

{"sheet":"Conditional Formatting","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Conditional Formatting Stops Cut and Paste"]
[]
[null,"Product","Customer","Quantity","Unit Price","Amount"]
[null,"Apple","Jonas",25,3,{"$f":"D5*E5","v":75}]
[null,"Orange","Harry",14,3,{"$f":"D6*E6","v":42}]
[null,"Guava","Nick",15,4,60]
[null,"Coconut","Sara",5,6,30]
[null,"Apricot","John",20,5,100]
[null,"Watermelon","Leon",8,7,56]
[null,"Jackfruit","Tom",25,6,150]
[null,"Kiwi","Hardy",12,9,108]
[null,"Lemon","Mark",6,3,18]
[null,"Avocado","Chris",10,10,100]

{"sheet":"Clipboard","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Collecting too Many Items on Clipboard"]
[]
[null,"Product","Customer","Quantity","Unit Price","Amount"]
[null,"Apple","Jonas",25,3,75]
[null,"Orange","Harry",14,3,42]
[null,"Guava","Nick",15,4,60]
[null,"Coconut","Sara",5,6,30]
[null,"Apricot","John",20,5,100]
[null,"Watermelon","Leon",8,7,56]
[null,"Jackfruit","Tom",25,6,150]
[null,"Kiwi","Hardy",12,9,108]
[null,"Lemon","Mark",6,3,18]
[null,"Avocado","Chris",10,10,100]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Applying VBA Code to Reset Cells"]
[]
[null,"Product","Customer","Quantity","Unit Price","Amount"]
[null,"Apple","Jonas",25,3,{"$f":"D5*E5","v":75}]
[null,"Orange","Harry",14,3,{"$f":"D6*E6","v":42}]
[null,"Guava","Nick",15,4,60]
[null,"Coconut","Sara",5,6,30]
[null,"Apricot","John",20,5,100]
[null,"Watermelon","Leon",8,7,56]
[null,"Jackfruit","Tom",25,6,150]
[null,"Kiwi","Hardy",12,9,108]
[null,"Lemon","Mark",6,3,18]
[null,"Avocado","Chris",10,10,100]