{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["AutoComplete for Formula","AutoComplete from Other Column","Applying VBA","AutoComplete from Another Sheet"],"not_rendered":{"charts":0,"images":2,"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":"AutoComplete for Formula","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Utilizing AutoComplete for Formula"]
[]
[null,"Fruit Name","Text (without Comma)"]
[null,"Orange, Banana",{"$f":"SUBSTITUTE(B5,\",\",\"\")","v":"Orange Banana"}]
[null,"Pineapple, Cherry",{"$f":"SUBSTITUTE(B6,\",\",\"\")","v":"Pineapple Cherry"}]
[null,"Guava, Grape","Guava Grape"]
[null,"Banana, Apple","Banana Apple"]
[null,"Mango, Orange","Mango Orange"]

{"sheet":"AutoComplete from Other Column","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using AutoComplete from Another Row"]
[]
[null,"Fruit Name"]
[null,"Orange, Banana"]
[null,"Pineapple, Cherry"]
[null,"Guava, Grape"]
[null,"Banana, Apple"]
[null,"Mango, Orange"]
[null,"Pineapple, Cherry"]

{"sheet":"Applying VBA","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Applying VBA"]
[]
[null,"Fruit Name"]
[null,"Orange, Banana"]
[null,"Pineapple, Cherry"]
[null,"Guava, Grape"]
[null,"Banana, Apple"]
[null,"Mango, Orange"]

{"sheet":"AutoComplete from Another Sheet","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using AutoComplete from Another Sheet"]
[]
[null,"Fruit Name"]
[null,{"$f":"'AutoComplete from Other Column'!B5","v":"Orange, Banana"}]
[null,{"$f":"'AutoComplete from Other Column'!B6","v":"Pineapple, Cherry"}]
[null,{"$f":"'AutoComplete from Other Column'!B7","v":"Guava, Grape"}]
[null,{"$f":"'AutoComplete from Other Column'!B8","v":"Banana, Apple"}]
[null,{"$f":"'AutoComplete from Other Column'!B9","v":"Mango, Orange"}]