{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"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":"Sheet1","index":0,"n_rows":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Array Formula Test"]
[]
[null,null,"Formula",null,null,"Expected Values"]
[null,null,{"$f":"SQRT({1,4;9,16})","v":1},2,null,1,2,null,"Test square(2x2) array formula"]
[null,null,3,4,null,3,4,null,"     row 2"]
[]
[null,null,{"$f":"SQRT({1,4,9,16})","v":1},null,null,1,null,null,"Array Formula without range"]
[]
[{"$f":"SIN({0.3,0.4,0.5})","v":0.29552020666133955},0.38941834230865052,0.47942553860420301,null,null,0.29552020666133955,0.38941834230865052,0.47942553860420301,null,"Row with correct size: case 1"]
[]
[null,null,{"$f":"SIN({0.1,0.2,0.3})","v":9.9833416646828155E-2},0.19866933079506122,null,9.9833416646828155E-2,0.19866933079506122,null,null,"Row with small size: case 2"]
[]
[{"$f":"SIN({0.1,0.2,0.3})","v":9.9833416646828155E-2},0.19866933079506122,0.29552020666133955,{"$error":"#N/A"},null,9.9833416646828155E-2,0.19866933079506122,0.29552020666133955,{"$error":"#N/A"},"Row with big size: case 3"]
[]
[]
[null,null,{"$f":"SIN({0.1,0.2,0.3})","v":9.9833416646828155E-2},0.19866933079506122,null,9.9833416646828155E-2,0.19866933079506122,null,"1x3 values for 2x2 range: case 4"]
[null,null,9.9833416646828155E-2,0.19866933079506122,null,9.9833416646828155E-2,0.19866933079506122]
[]
[null,null,{"$f":"SIN({0.1,0.2,0.3;0.4,0.5,0.6;0.7,0.8,0.9})","v":9.9833416646828155E-2},0.19866933079506122,null,9.9833416646828155E-2,0.19866933079506122,null,"3x3 values for 2x2 range:case 5"]
[null,null,0.38941834230865052,0.47942553860420301,null,0.38941834230865052,0.47942553860420301]
[]
[null,null,{"$f":"SIN({0.1,0.2,0.3})","v":9.9833416646828155E-2},null,null,9.9833416646828155E-2,null,null,"1x3 values for  4x1 range"]
[null,null,9.9833416646828155E-2,null,null,9.9833416646828155E-2]
[null,null,9.9833416646828155E-2,null,null,9.9833416646828155E-2]
[null,null,9.9833416646828155E-2,null,null,9.9833416646828155E-2]
[]
[{"$f":"SIN({0.1;0;0.2;0.3})","v":9.9833416646828155E-2},9.9833416646828155E-2,9.9833416646828155E-2,9.9833416646828155E-2,null,9.9833416646828155E-2,9.9833416646828155E-2,9.9833416646828155E-2,9.9833416646828155E-2,"4x1 values for 1x4 range"]
[]
[]
[null,{"$f":"SQRT({1,4;9,16})","v":1},2,{"$error":"#N/A"},null,1,2,{"$error":"#N/A"},"2x2 values for 3x3 range"]
[null,3,4,{"$error":"#N/A"},null,3,4,{"$error":"#N/A"}]
[null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
["Place","Holder",null,null,null,9.9833416646828155E-2,0.19866933079506122,null,"Place(a35-b35) for new ArrayFormula"]
[]
[{"$f":"SIN(A38:C38)","v":0.29552020666133955},0.38941834230865052,0.47942553860420301,null,null,0.29552020666133955,0.38941834230865052,0.47942553860420301,null,"Arguments as reference"]
[0.3,0.4,0.5,null,null,"Arguments for above row"]
[]
[{"$f":"COS(SIN(A41:C41))","v":0.95665076805859539},0.92513004290042766,0.88726005071765257,null,null,0.95665076805859539,0.92513004290042766,0.88726005071765257,null,"Arguments as reference"]
[0.3,0.4,0.5,null,null,"Arguments for above row"]
[]
[2,2,{"$f":"A43:A46*B43:B46","v":4},null,null,4,null,null,"Operation between ranges"]
[3,3,9,null,null,9]
[4,4,16,null,null,16]
[5,5,25,null,null,25]
[]
[2,2,{"$f":"A48:A51*B48","v":4},null,null,4,null,null,"Operation between ranges with different dimensions"]
[3,3,6,null,null,6]
[4,4,8,null,null,8]
[5,5,10,null,null,10]
[]
[]
[{"$f":"MATCH({1,2,3;2,4,8},{1,2,4,7,8})","v":1},2,2,null,null,1,2,2,null,"Function with different type (scalar,array)arguments"]
[2,3,5,null,null,2,3,5]
[]
[]
[1,2,4,5,null,1,2,4,5]
[3,4,6,7,null,3,4,6,7]
[null,null,{"$f":"A58*C58","v":4},null,null,4]
[null,null,{"$f":"A59*C59","v":18},null,null,18]
[null,null,{"$f":"B58*D58","v":10},null,null,10]
[null,null,{"$f":"B59*D59","v":28},null,null,28]
[null,null,{"$f":"A58:B59*C58:D59","v":4},10,null,4,10]
[null,null,18,28,null,18,28]
[]
[null,null,"<END-OF-FUNCTIONS>",null,null,null,null,null,null,"Functions below this row will not be tested automatically"]
[]
[null,null,{"$f":"MyFuncWithoutArraySupport({1,4;9,16})","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,1,4,null,null,"UDF function without Array Support"]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,9,16,null,null,"Excel cannot evaluate it"]
[]
[null,null,{"$f":"MyFuncWithArraySupport({1,4;9,16})","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,1,4,null,null,"UDF function with Array Support"]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,9,16,null,null,"Excel cannot evaluate it"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}