{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Blad1","Data_for_testing"],"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":"Blad1","index":0,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,{"$f":"+COUNTA(A:A)","v":9}]
[null,null,null,null,null,null,{"$f":"+COUNTA(B:B)","v":35}]
[null,null,null,null,null,null,{"$f":"+\"A\"&10+G1","v":"A19"}]
[null,null,null,null,null,null,{"$f":"+\"A\"&G1+8&\":D\"&G2+11","v":"A17:D46"},"<<   Range to be sorted"]
[]
[null,null,null,null,null,null,null,"I want that to refer to cell \"G4\" for the correct range to be sorted."]
["Stukslijst Koper",null,null,null,null,null,null,"The current range \"A17: D46\" is not always the same"]
[null,null,null,null,null,null,null,"I tried several solutions but these didn't work"]
[16,"B001x0900","PVC",10]
[8,"B007x0200","pe",9]
[1,"D003xB001x0500","K5566",10]
[1,"x-ag0,6mm","X-PVC",3]
[1,"D007xB001x1120","NULL"]
[]
["Stukslijst Compensatie"]
[]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[2,"KX001x1300","PE",2.6]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[3,"KX001x1300","PE",4.5]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]

{"sheet":"Data_for_testing","index":1,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Stukslijst Compensatie"]
[]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[2,"KX001x1300","PE",2.6]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[3,"KX001x1300","PE",4.5]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]
[null,"NULL","NULL"]