{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Kódy"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"Kódy","index":0,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Vkládání vzorců do buněk"]
[]
["ID","Výrobek","Cena práce","Cena materiál","Cena celkem","Kurz na Euro"]
[1,"Výrobek 1",20,22]
[2,"Výrobek 2",22,1]
[3,"Výrobek 3",24,11]
[4,"Výrobek 4",32,10,null,null,null,null,null,null,null,null,"i = 1"]
[5,"Výrobek 5",28,14,null,null,null,null,null,null,null,null," Cells(i + 3, 5).Formula = \"=C\" & i + 3 "]
[6,"Výrobek 6",30,15]
[]
[]
[null,null,null,null,null,null,null,"Zapiš vzorec do buňky"]
[null,"Kurz EURO",null,null,null,null,null,null,null,null,null,null,"For i = 1 To 6"]
[null,27,null,null,null,null,null,"Cells(2, 2).Formula = \"=A1\"",null,null,null,null,"  Cells(i + 3, 5).Formula = \"=C\" & i + 3 & \"+D\" & i + 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Next i"]
[null,null,null,null,null,null,null,"Range(\"B4\").Formula = \"=A1\""]
[]
[null,null,null,null,null,null,null,"Odkaz R1C1","Styl odkazu změna"]
[]
[null,null,null,null,null,null,null,"=RC[-1]","Relativní"]
[null,null,null,null,null,null,null,{"$f":"$D$4","v":22},"Absolutní"]
[]
[null,null,null,null,null,null,null,"Poznámka"]
[null,null,null,null,null,null,null,"Range(\"H10\").FormulaR1C1 = \"=RC[-3]\""]
[]
[]
[null,null,null,null,null,null,null,"Zapiš vzorec do buňky dynamicky"]
[]
[]
[null,null,null,null,null,null,null,"k = 1"]
[null,null,null,null,null,null,null,"Range(\"A4\").Formula = \"=D\" & (k)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Zapiš vzorec do buňky dynamicky"]
[]
[null,null,null,null,null,null,null,"Hodnota = \"E2\" "]
[null,null,null,null,null,null,null,"Range(\"I3\").Formula = \"=SUM(D2:\" & Hodnota & \")\""]