{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["List1","List2","Data"],"not_rendered":{"charts":0,"images":12,"macros":0,"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":"List1","index":0,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,1,6,2],[15,1,15,2],[27,1,27,2],[48,1,48,2],[38,1,38,2]]}
[]
[]
[]
[10]
[15]
[]
[null,"Jednoduchý výpočet"]
[null,null,"Range(\"B4\").Formula = \"=A4\"",null,null,null,"Cells(4,2).Formula = \"=A4\""]
[null,null,"Range(\"B5\").FormulaR1C1 = \"=RC[-1]\""]
[]
[null,1]
[null,2]
[null,3]
[null,null,"Celkem"]
[]
[null,"Jednoduchý výpočet - absolutní / relativní"]
[null,null,"Range(\"B14\").Formula = \"=SUM(B11:B13)\" ",null,null,null,"Range(\"B14\").FormulaLocal = \"=SUM(B11:B13)\" "]
[]
[null,null,"Range(\"B14\").FormulaR1C1 = \"=SUM(R[-3]C:R[-1]C)\""]
[]
[]
[null,null,"Range(\"B14\").Formula = \"=SUM($B$11:$B$13)\" "]
[]
[null,null,"Range(\"B14\").FormulaR1C1 = \"=SUM(R11C2:R13C2)\""]
[]
[]
[]
[null,"Jednoduchý výpočet - absolutní / relativní (dynamicky)"]
[]
[null,null,"Hodnota = \"B13\" "]
[null,null,"Range(\"B14\").Formula = \"=SUM(B11:\" & Hodnota & \")\""]
[]
[]
[null,null,"Hodnota1 = \"13\" "]
[null,null,"Hodnota2 = \"2\" "]
[null,null,"Range(\"B14\").FormulaR1C1 = \"=SUM(R11C2:R\" & Hodnota1 & \"C\" & Hodnota & \")\""]
[]
[]
[null,"Jiný list"]
[{"$f":"Data!A3","v":1}]
[{"$f":"Data!A3","v":1},null,"Range(\"A41\").Formula = \"=Data!A3"]
[]
[]
[]
[null,null,"k = 3"]
[null,null,"Range(\"A41\").Formula = \"=Data!A\" & k"]
[]
[]
[null,"Cyklus"]
[]
[null,null,"viz další list"]

{"sheet":"List2","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Prudukt","mat 1","mat 2","mat 3","mat 4","mat 5","Celkem"]
[null,"Výrobek 1",1,2,19,2,19,null,null,null,null,null,null,null,"For i = 1 To 7"]
[null,"Výrobek 2",3,13,3,19,16,null,null,null,null,null,null,null,"Cells(4 + i, 8).FormulaR1C1 = \"=SUM(R\" & 4 + i & \"C3:R\" & 4 + i & \"C7)\""]
[null,"Výrobek 3",9,3,18,7,11,null,null,null,null,null,null,null,"Next i"]
[null,"Výrobek 4",13,14,8,2,11]
[null,"Výrobek 5",5,2,5,3,5,null,null,null,null,null,null,null,"For i = 1 To 7"]
[null,"Výrobek 6",20,17,8,5,5,null,null,null,null,null,null,null,"Cells(4 + i, 8).FormulaR1C1 = \"=SUM(RC[-5]:RC[-1])\""]
[null,"Výrobek 7",15,1,1,8,19,null,null,null,null,null,null,null,"Next i"]

{"sheet":"Data","index":2,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Data"]
[1]
[2]
[3]