{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Zadanie","Lista ","przywracanie"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Zadanie","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,1,2,7],[4,1,29,7]]}
[]
[null,"Rejestrowanie makr"]
[null,"Magdalena Bazylak"]
[]
[null,"W arkuszu \"Lista\" znajduje się lista studentów, którzy nie odebrali legitymacji na semestr letni 2018/2019, oraz dwa przyciski. \nZakładamy, że system uczelni zawsze generuje listy w jednakowym formacie, jednak jest on niewygodny (zawiera 4 kolumny, a imiona są w jednej komórce z nazwiskami co stwarza problemy).\n\nPo naciśnięciu przycisku \"rozdzielanie\", makro:\n- rozdzieli imiona i nazwiska,\n- posortuje kolumny według nazwiska -> roku -> kierunku,\n- ustawi szerokości kolumn,\n- ponumeruje posortowane imiona i nazwiska\n- doda formatowanie tabeli.\n\nPo naciśnięciu przycisku \"przywracanie\" makro przywróci listę do stanu początkowego.\n\nW oknie dialogowym po wciśnięciu przycisku \"rozdzielanie\", \nnależy zaznaczyć \"OK\".\n"]

{"sheet":"Lista ","index":1,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Lista studentów, którzy nie podbili legitymacji na semestr letni 2018/2019"]
["Imię i nazwisko","Kierunek","Rok","Semestr"]
["Ignacy Chrobot","FM",3,6]
["Tomasz Kot","FiR",3,6]
["Adrian Paśnik","FM",1,2]
["Olaf Pszczółkowski","GT",1,2]
["Michał Krzemiński","LOG",1,2]
["Tadeusz Czernicki","LOG",2,4]
["Karol Matys","ZS",1,2]
["Kacper Olejnik","LOG",3,6]
["Anna Pękalska","LOG",2,4]
["Adam Tabor","FiR",1,2]
["Anna Podgajna","FM",2,4]
["Amanda Cichoń","FM",1,2]
["Estera Mądra","LOG",3,6]
["Alicja Nowakowska","ZS",1,2]
["Jolanta Pałubicka","GT",2,4]
["Aleksandra Piekarz","ZS",1,2]
["Karol Antkiewicz","FM",1,2]
["Monika Hernik","GT",1,2]
["Marcin Koryciński","LOG",1,2]
["Jakub Melin","LOG",2,4]
["Izabela Kulpa","ZS",1,2]
["Kinga Mrozik","LOG",2,4]
["Konrad Szelc","ZS",1,2]
["Kaja Derlatka","FM",3,6]
["Franciszek Faliński","LOG",2,4]
["Wiktoria Gzyms","FM",1,2]
["Grzegorz Smoliński","GT",1,2]
["Filip Zdrzałek","LOG",1,2]
["Ewelina Górniak","LOG",2,4]
["Jonasz Kobierski","ZS",1,2]

{"sheet":"przywracanie","index":2,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Lista studentów, którzy nie podbili legitymacji na semestr letni 2018/2019"]
["Imię i nazwisko","Kierunek","Rok","Semestr"]
["Ignacy Chrobot","FM",3,6]
["Tomasz Kot","FiR",3,6]
["Adrian Paśnik","FM",1,2]
["Olaf Pszczółkowski","GT",1,2]
["Michał Krzemiński","LOG",1,2]
["Tadeusz Czernicki","LOG",2,4]
["Karol Matys","ZS",1,2]
["Kacper Olejnik","LOG",3,6]
["Anna Pękalska","LOG",2,4]
["Adam Tabor","FiR",1,2]
["Anna Podgajna","FM",2,4]
["Amanda Cichoń","FM",1,2]
["Estera Mądra","LOG",3,6]
["Alicja Nowakowska","ZS",1,2]
["Jolanta Pałubicka","GT",2,4]
["Aleksandra Piekarz","ZS",1,2]
["Karol Antkiewicz","FM",1,2]
["Monika Hernik","GT",1,2]
["Marcin Koryciński","LOG",1,2]
["Jakub Melin","LOG",2,4]
["Izabela Kulpa","ZS",1,2]
["Kinga Mrozik","LOG",2,4]
["Konrad Szelc","ZS",1,2]
["Kaja Derlatka","FM",3,6]
["Franciszek Faliński","LOG",2,4]
["Wiktoria Gzyms","FM",1,2]
["Grzegorz Smoliński","GT",1,2]
["Filip Zdrzałek","LOG",1,2]
["Ewelina Górniak","LOG",2,4]
["Jonasz Kobierski","ZS",1,2]