{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dataset","VBA Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Remove Conditional Formatting but Keep the Format"]
[]
[null,"Product Name","Unit Price ","Quantity","Price "]
[null,"Banana",10.5,45,472.5]
[null,"Apples Green",19,60,228]
[null,"Oranges",9,56,504]
[null,"Sweet Melon",100,36,3600]
[null,"Lemon",10.5,62,651]
[null,"Carrot",1.77,33,58.41]
[null,"Whole Wheat",3.49,87,303.63]
[null,"Chocolate Chip",1.87,58,108.46]
[null,"Arrowroot",2.1800000000000002,38,82.84]
[null,"Potato Chips",1.35,28,37.799999999999997]

{"sheet":"VBA Code","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"VBA Code to Remove Conditional Formatting but Keep the Format"]
[]
[null,"Product Name","Unit Price ","Quantity","Price "]
[null,"Banana",10.5,45,{"$f":"C5*D5","v":472.5}]
[null,"Apples Green",19,12,{"$f":"C6*D6","v":228}]
[null,"Oranges",9,56,{"$f":"C7*D7","v":504}]
[null,"Sweet Melon",100,36,{"$f":"C8*D8","v":3600}]
[null,"Lemon",10.5,62,{"$f":"C9*D9","v":651}]
[null,"Carrot",1.77,33,58.41]
[null,"Whole Wheat",3.49,87,303.63]
[null,"Chocolate Chip",1.87,58,108.46]
[null,"Arrowroot",2.1800000000000002,38,82.84]
[null,"Potato Chips",1.35,60,37.799999999999997]