{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["dataset1","dataset2","dataset","single","range","cell output","rows and columns","diy"],"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":"dataset1","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Unhide from All Worksheet"]
[]
[null,"Smartphone","Purchase Date","Price"]
[null,"Samsung S20+","2021-02-01",799]
[null,"Iphone 13 Pro Max","2021-08-05",1600]
[null,"OnePlus 9 Pro","2021-07-21",1100]
[null,"OnePlus Nord 2","2021-05-15",400]
[null,"Honor X9","2022-03-11",260]
[null,"Samsung S22+","2022-04-14",999]
[null,"Google Pixel 6","2022-01-10",900]
[null,"Vivo X Note","2021-11-29",940]
[null,"Red Magic 7 Pro","2021-10-20",740]
[null,"Huawei Mate 30 Pro","2022-01-01",946]
[null,"Asus ROG 5","2021-02-28",800]

{"sheet":"dataset2","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Unhide Rows by VBA"]
[]
[null,"Smartphone","Purchase Date","Price"]
[null,"Samsung S20+","2021-02-01",799]
[null,"Iphone 13 Pro Max","2021-08-05",1600]
[null,"OnePlus 9 Pro","2021-07-21",1100]
[null,"OnePlus Nord 2","2021-05-15",400]
[null,"Honor X9","2022-03-11",260]
[null,"Samsung S22+","2022-04-14",999]
[null,"Google Pixel 6","2022-01-10",900]
[null,"Vivo X Note","2021-11-29",940]
[null,"Red Magic 7 Pro","2021-10-20",740]
[null,"Huawei Mate 30 Pro","2022-01-01",946]
[null,"Asus ROG 5","2021-02-28",800]

{"sheet":"dataset","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Unhide Rows by VBA"]
[]
[null,"Smartphone","Purchase Date","Price"]
[null,"Samsung S20+","2021-02-01",799]
[null,"Iphone 13 Pro Max","2021-08-05",1600]
[null,"OnePlus 9 Pro","2021-07-21",1100]
[null,"OnePlus Nord 2","2021-05-15",400]
[null,"Honor X9","2022-03-11",260]
[null,"Samsung S22+","2022-04-14",999]
[null,"Google Pixel 6","2022-01-10",900]
[null,"Vivo X Note","2021-11-29",940]
[null,"Red Magic 7 Pro","2021-10-20",740]
[null,"Huawei Mate 30 Pro","2022-01-01",946]
[null,"Asus ROG 5","2021-02-28",800]

{"sheet":"single","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Unhide from Single Worksheet"]
[]
[null,"Smartphone","Purchase Date","Price"]
[null,"Samsung S20+","2021-02-01",799]
[null,"Iphone 13 Pro Max","2021-08-05",1600]
[null,"OnePlus 9 Pro","2021-07-21",1100]
[null,"OnePlus Nord 2","2021-05-15",400]
[null,"Honor X9","2022-03-11",260]
[null,"Samsung S22+","2022-04-14",999]
[null,"Google Pixel 6","2022-01-10",900]
[null,"Vivo X Note","2021-11-29",940]
[null,"Red Magic 7 Pro","2021-10-20",740]
[null,"Huawei Mate 30 Pro","2022-01-01",946]
[null,"Asus ROG 5","2021-02-28",800]

{"sheet":"range","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Unhide Within a Range"]
[]
[null,"Smartphone","Purchase Date","Price"]
[null,"Samsung S20+","2021-02-01",799]
[null,"Iphone 13 Pro Max","2021-08-05",1600]
[null,"OnePlus 9 Pro","2021-07-21",1100]
[null,"OnePlus Nord 2","2021-05-15",400]
[null,"Honor X9","2022-03-11",260]
[null,"Samsung S22+","2022-04-14",999]
[null,"Google Pixel 6","2022-01-10",900]
[null,"Vivo X Note","2021-11-29",940]
[null,"Red Magic 7 Pro","2021-10-20",740]
[null,"Huawei Mate 30 Pro","2022-01-01",946]
[null,"Asus ROG 5","2021-02-28",800]

{"sheet":"cell output","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Unhide Based on a Cell Output"]
[]
[null,"Smartphone","Purchase Date","Price","Price Range"]
[null,"Samsung S20+","2021-02-01",799,{"$f":"AND(D5>=600, D5<=900)","v":true}]
[null,"Iphone 13 Pro Max","2021-08-05",1600,{"$f":"AND(D6>=600, D6<=900)","v":false}]
[null,"OnePlus 9 Pro","2021-07-21",1100,false]
[null,"OnePlus Nord 2","2021-05-15",400,false]
[null,"Honor X9","2022-03-11",260,false]
[null,"Samsung S22+","2022-04-14",999,false]
[null,"Google Pixel 6","2022-01-10",900,true]
[null,"Vivo X Note","2021-11-29",940,false]
[null,"Red Magic 7 Pro","2021-10-20",740,true]
[null,"Huawei Mate 30 Pro","2022-01-01",946,false]
[null,"Asus ROG 5","2021-02-28",800,true]

{"sheet":"rows and columns","index":6,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Unhide Rows by VBA"]
[]
[null,"Smartphone","Purchase Date","Price"]
[null,"Samsung S20+","2021-02-01",799]
[null,"Iphone 13 Pro Max","2021-08-05",1600]
[null,"OnePlus 9 Pro","2021-07-21",1100]
[null,"OnePlus Nord 2","2021-05-15",400]
[null,"Honor X9","2022-03-11",260]
[null,"Samsung S22+","2022-04-14",999]
[null,"Google Pixel 6","2022-01-10",900]
[null,"Vivo X Note","2021-11-29",940]
[null,"Red Magic 7 Pro","2021-10-20",740]
[null,"Huawei Mate 30 Pro","2022-01-01",946]
[null,"Asus ROG 5","2021-02-28",800]

{"sheet":"diy","index":7,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Do It Yourself"]
[]
[null,"Smartphone","Purchase Date","Price"]
[null,"Samsung S20+","2021-02-01",799]
[null,"Iphone 13 Pro Max","2021-08-05",1600]
[null,"OnePlus 9 Pro","2021-07-21",1100]
[null,"OnePlus Nord 2","2021-05-15",400]
[null,"Honor X9","2022-03-11",260]
[null,"Samsung S22+","2022-04-14",999]
[null,"Google Pixel 6","2022-01-10",900]
[null,"Vivo X Note","2021-11-29",940]
[null,"Red Magic 7 Pro","2021-10-20",740]
[null,"Huawei Mate 30 Pro","2022-01-01",946]
[null,"Asus ROG 5","2021-02-28",800]