{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["AF","Code1-noclue","Code1-withclue","Code2","Code3","Code4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"AF","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Col1","Col2","Col3","Col4","Col5","Col6"]
[null,{"$f":"N(B2)+1","v":1},{"$f":"B3+1","v":2},{"$f":"C3+1","v":3},4,5,6]
[null,{"$f":"N(B3)+1","v":2},{"$f":"B4+1","v":3},4,5,6,7]
[null,3,4,5,6,7,8]
[null,4,5,6,7,8,9]
[null,5,6,7,8,9,10]

{"sheet":"Code1-noclue","index":1,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"What should happen:"]
[null,"Col1","Col2","Col3",null,null,null,"https://docs.microsoft.com/en-us/office/vba/api/excel.autofilter.range"]
[null,1,1,1,null,null,null,"Try moving the table around, chaning it to a range, deleting it etc"]
[null,2,2,2,null,null,null,"Autofilter sheet -->","AF","<--- the name of the sheet that contains the Autofilter"]
[null,3,3,3,null,null,null,"AutofilterAddress","Bug workaround"]
[null,4,4,4,null,null,null,{"$f":"AutofilterAddress($I$5,I7)","v":"B2:G8"},0,{"$f":"\"None: \"&IF(H7<>$H$8,\"Bug visible\",\"Bug invisible\")","v":"None: Bug visible"}]
[null,5,5,5,null,null,null,{"$f":"AutofilterAddress($I$5,1)","v":"B2:G7"},"Bug solved"]

{"sheet":"Code1-withclue","index":2,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"What should happen:"]
[null,"Col1","Col2","Col3",null,null,null,"https://docs.microsoft.com/en-us/office/vba/api/excel.autofilter.range"]
[null,1,1,1]
[null,2,2,2,null,null,null,"Autofilter sheet -->","AF","<--- the name of the sheet that contains the Autofilter"]
[null,3,3,3,null,null,null,"AutofilterAddress","Bug workaround"]
[null,4,4,4,null,null,null,{"$f":"AutofilterAddress($I$5,I7)","v":"B2:G8"},0,{"$f":"\"None: \"&IF(H7<>H15,\"Bug visible\",\"Bug invisible\")","v":"None: Bug visible"}]
[null,5,5,5]
[]
[null,null,null,null,null,null,null,"Ask for a clue"]
[null,null,null,null,null,null,null,"GiveClue",1,"Can't identify let alone solve the bug? Ask for a clue!"]
[null,null,null,null,null,null,null,"Bug Workaround / Solution"]
[null,null,null,null,null,null,null,"Autofilter cell --->",{"$f":"ADDRESS(ROW(AF!B7),COLUMN(AF!B7),4)","v":"B7"},"<--- bottom left of autofilter",{"$f":"ColumnLetter(MIN(COLUMN(AF!$B$2:$G$7)))&MAX(ROW(AF!$B$2:$G$7))","v":"B7"},"<--- Alternative formula"]
[null,null,null,null,null,null,null,"AutofilterAddress","Bug workaround","Description"]
[null,null,null,null,null,null,null,{"$f":"AutofilterAddress($I$5,I15)","v":"B2:G7"},1,"Count non-empty rows"]
[null,null,null,null,null,null,null,{"$f":"AutofilterAddress($I$5,I16)","v":"B2:G7"},2,"_FilterDatabase address"]
[]
[null,null,null,null,null,null,null,"Code2","Code3"]
[null,null,null,null,null,null,null,{"$f":"Code2!$G7","v":"B2:G8"},{"$f":"Code3!$G7","v":"B2:G8"}]
[null,null,null,null,null,null,null,{"$f":"Code2!$G8","v":"B2:G7"},{"$f":"Code3!$G8","v":"B2:G7"}]
[null,null,null,null,null,null,null,{"$f":"Code2!$G9","v":"B2:G7"},{"$f":"Code3!$G9","v":"B2:G7"}]

{"sheet":"Code2","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"See ","https://docs.microsoft.com/en-us/office/vba/api/excel.autofilter.range"]
[null,null,null,null,null,"AF first col",{"$f":"ColumnLetter(MIN(COLUMN(#REF!)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"AF last row",{"$f":"MAX(ROW(#REF!))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,"AF","<--- the name of the sheet that contains the Autofilter"]
[null,null,null,null,null,null,"AutofilterAddress"]
[null,null,null,"Col1","Col2",null,{"$f":"AutofilterAddress($H$5,H7)","v":"B2:G8"},0,"Bug"]
[null,null,null,1,1,null,{"$f":"AutofilterAddress($H$5,H8)","v":"B2:G7"},1,"Non-empty rows workaround"]
[null,null,null,2,2,null,{"$f":"AutofilterAddress($H$5,H9)","v":"B2:G7"},2,"_FilterDatabase workaround"]
[null,null,null,3,3]
[null,null,null,4,4]
[null,null,null,5,5]
[null,null,null,6,6]
[null,null,null,7,7]

{"sheet":"Code3","index":4,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"See ","https://docs.microsoft.com/en-us/office/vba/api/excel.autofilter.range"]
[null,null,null,null,null,"AF first col",{"$f":"ColumnLetter(MIN(COLUMN(#REF!)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"AF last row",{"$f":"MAX(ROW(#REF!))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,"AF","<--- the name of the sheet that contains the Autofilter"]
[null,null,null,null,null,null,"AutofilterAddress"]
[null,null,null,null,null,null,{"$f":"AutofilterAddress($H$5,H7)","v":"B2:G8"},0,"Bug"]
[null,null,null,null,null,null,{"$f":"AutofilterAddress($H$5,H8)","v":"B2:G7"},1,"Non-empty rows workaround"]
[null,null,null,null,null,null,{"$f":"AutofilterAddress($H$5,H9)","v":"B2:G7"},2,"_FilterDatabase workaround"]

{"sheet":"Code4","index":5,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"https://docs.microsoft.com/en-us/office/vba/api/excel.autofilter.range",null,null,"Alternative"]
[null,"Col1","Col2","Col3",null,null,"Autofilter cell --->",{"$f":"ADDRESS(ROW(#REF!),COLUMN(#REF!),4)","v":{"$error":"#REF!"}},"<--- bottom left of autofilter",{"$f":"ColumnLetter(MIN(COLUMN(#REF!)))&MAX(ROW(#REF!))","v":{"$error":"#VALUE!"}}]
[null,1,1,1]
[null,2,2,2,null,null,"Autofilter sheet -->","AF","<--- the name of the sheet that contains the Autofilter"]
[null,3,3,3,null,null,"AutofilterAddress","Bug workaround"]
[null,4,4,4,null,null,{"$f":"AutofilterAddress($H$5,H7)","v":"B2:G8"},0,{"$f":"\"None: \"&IF(G7<>$G$12,\"Bug visible\",\"Bug invisible\")","v":"None: Bug visible"}]
[null,5,5,5]
[]
[]
[null,null,null,null,null,null,"AutofilterAddress","Bug workaround","Description"]
[null,null,null,null,null,null,{"$f":"AutofilterAddress($H$5,H12)","v":"B2:G7"},1,"Count non-empty rows"]
[null,null,null,null,null,null,{"$f":"AutofilterAddress($H$5,H13)","v":"B2:G7"},2,"_FilterDatabase address"]
[]
[null,null,null,null,null,null,"Code2","Code3","Description"]
[null,null,null,null,null,null,{"$f":"Code2!$G7","v":"B2:G8"},{"$f":"Code3!$G7","v":"B2:G8"},{"$f":"\"None: \"&IF(G16<>$G$12,\"Bug visible\",\"Bug invisible\")","v":"None: Bug visible"}]
[null,null,null,null,null,null,{"$f":"Code2!$G8","v":"B2:G7"},{"$f":"Code3!$G8","v":"B2:G7"},"Count non-empty rows"]
[null,null,null,null,null,null,{"$f":"Code2!$G9","v":"B2:G7"},{"$f":"Code3!$G9","v":"B2:G7"},"_FilterDatabase address"]