{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["List1","List2","VBA automaticky","Záhlaví a zápatí","List3"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":1,"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":108,"n_cols":17,"rows_kept":108,"cut":false,"hidden":false,"merged":[[0,0,0,8],[3,10,3,16],[1,0,1,8],[107,0,107,8],[24,1,24,6],[50,1,50,6],[62,1,62,6],[76,1,76,6],[93,1,93,6]]}
["Ukázky kódu tisk - Excel VBA"]
["http://office.lasakovi.com"]
[null,null,null,null,null,null,null,null,null,null,"Začátek"]
[null,null,null,null,null,"Náhled před tiskem",null,null,null,null,"Ukázková oblast pro Tisk"]
[null,null,null,null,null,"ActiveSheet.PrintOut Preview:=True"]
[]
[null,null,null,null,null,"Náhled před tiskem"]
[null,null,null,null,null,"ActiveSheet.PageSetup.PrintArea = \"$K$3:$Q$13\""]
[null,null,null,null,null,"ActiveSheet.PrintOut Preview:=True"]
[]
[]
[null,null,null,null,null,"ActiveSheet.Select"]
[null,null,null,null,null,"ActiveSheet.PageSetup.PrintArea = Selection",null,null,null,null,null,null,null,null,null,null,"konec"]
[null,null,null,null,null,"ActiveSheet.PrintOut Preview:=True"]
[]
[null,null,null,null,null,"Náhled list 2"]
[null,null,null,null,null,"Worksheets(\"List2\").PrintPreview"]
[]
[null,null,null,null,null,"Náhled list 3"]
[null,null,null,null,null,"List 3 je skrytý!"]
[null,null,null,null,null,"    Sheets(\"List3\").Visible = True"]
[null,null,null,null,null,"    Worksheets(\"List3\").PrintPreview"]
[null,null,null,null,null,"    Sheets(\"List3\").Visible = False"]
[]
[null,"Záhlaví zápatí"]
[]
[null,null,null,null,null,"With ActiveSheet.PageSetup"]
[null,null,null,null,null,"    .LeftHeader = Range(\"K30\").Value"]
[null,null,null,null,null,"    .CenterHeader = Range(\"K31\").Text"]
[null,null,null,null,null,"    .RightHeader = Range(\"K32\").Formula",null,null,null,null,"Vlevo","Value"]
[null,null,null,null,null,"End With",null,null,null,null,"střed","Text"]
[null,null,null,null,null,"ActiveSheet.PrintOut Preview:=True",null,null,null,null,"Vpravo","Formula"]
[]
[null,null,null,null,null,"With ActiveSheet.PageSetup"]
[null,null,null,null,null,"    .LeftFooter = \"&K0000FF&P\"",null," Stránka &P z &N"]
[null,null,null,null,null,"    .CenterFooter = \"Text zadaný přímo\""]
[null,null,null,null,null,"    .RightFooter = ActiveWorkbook.Name"]
[null,null,null,null,null,"End With"]
[null,null,null,null,null,"ActiveSheet.PrintOut Preview:=True"]
[null,"Jde vlastně o lichou stránku!"]
[null,null,null,null,null,"With ActiveSheet.PageSetup"]
[null,null,null,null,null,"    .LeftHeader = \"\""]
[null,null,null,null,null,"    .CenterHeader = \"\""]
[null,null,null,null,null,"    .RightHeader = \"\""]
[null,null,null,null,null,"    "]
[null,null,null,null,null,"    .LeftFooter = \"\""]
[null,null,null,null,null,"    .CenterFooter = \"\""]
[null,null,null,null,null,"    .RightFooter = \"\""]
[null,null,null,null,null,"End With"]
[]
[null,"List - nastavení"]
[]
[null,null,null,null,null,"With ActiveSheet.PageSetup"]
[null,null,null,null,null,"     .PrintTitleRows = \"$1:$1\""]
[null,null,null,null,null,"     .PrintTitleColumns = \"$A:$A\""]
[null,null,null,null,null,"End With"]
[]
[null,null,null,null,null,"Černobíle"]
[null,null,null,null,null,"        .BlackAndWhite = True"]
[]
[]
[]
[null,"Stránka"]
[]
[null,null,null,null,null,"ActiveSheet.PageSetup.Orientation = xlLandscape '2"]
[null,null,null,null,null,"ActiveSheet.PrintOut Preview:=True"]
[]
[]
[null,null,null,null,null,"ActiveSheet.PageSetup.Orientation = xlPortrait  '1"]
[null,null,null,null,null,"ActiveSheet.PrintOut Preview:=True"]
[]
[]
[]
[null,null,null,null,null,"       ActiveSheet.PageSetup.PaperSize = xlPaperA4"]
[]
[]
[null,"Okraje"]
[]
[null,null,null,null,null,"    With ActiveSheet.PageSetup"]
[null,null,null,null,null,"        .LeftMargin = Application.InchesToPoints(1.7)"]
[null,null,null,null,null,"        .RightMargin = Application.InchesToPoints(1.7)"]
[null,null,null,null,null,"        .TopMargin = Application.InchesToPoints(1.7)"]
[null,null,null,null,null,"        .BottomMargin = Application.InchesToPoints(1.7)"]
[null,null,null,null,null,"        .HeaderMargin = Application.InchesToPoints(1.3)"]
[null,null,null,null,null,"        .FooterMargin = Application.InchesToPoints(1.3)"]
[null,null,null,null,null,"    End With"]
[]
[null,null,null,null,null,"With ActiveSheet.PageSetup"]
[null,null,null,null,null,"    .CenterHorizontally = True"]
[null,null,null,null,null,"    .CenterVertically = True"]
[null,null,null,null,null,"End With"]
[]
[]
[null,"Tiskárna"]
[]
[null,null,null,null,null,"ActiveSheet.Select"]
[null,null,null,null,null,"ActiveSheet.PageSetup.PrintArea = Selection"]
[null,null,null,null,null,"ActiveSheet.PrintOut Preview:=True, From:=2, To:=3"]
[]
[]
[null,null,null,null,null,"Application.Dialogs(xlDialogPrinterSetup).Show"]
[]
[]
[]
[null,null,null,null,null,"ActiveSheet.PrintOut"]
[]
[]
["Vytvořeno: 2013"]

{"sheet":"List2","index":1,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,8],[4,0,4,8],[1,0,1,8],[7,0,7,8]]}
["Ukázky kódu tisk - Excel VBA"]
["http://office.lasakovi.com"]
[]
[]
["List 2"]
[]
[]
["Vytvořeno: 2013"]

{"sheet":"VBA automaticky","index":2,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null," With ActiveSheet.PageSetup"]
[null,"        .LeftHeader = \"Zahlaví liché\""]
[null,"        .CenterHeader = \"\""]
[null,"        .RightHeader = \"\""]
[null,"        .LeftFooter = \"\""]
[null,"        .CenterFooter = \"\""]
[null,"        .RightFooter = \"\""]
[null,"        .LeftMargin = Application.InchesToPoints(0.708661417322835)"]
[null,"        .RightMargin = Application.InchesToPoints(0.708661417322835)"]
[null,"        .TopMargin = Application.InchesToPoints(0.78740157480315)"]
[null,"        .BottomMargin = Application.InchesToPoints(0.78740157480315)"]
[null,"        .HeaderMargin = Application.InchesToPoints(0.31496062992126)"]
[null,"        .FooterMargin = Application.InchesToPoints(0.31496062992126)"]
[null,"        .PrintHeadings = False"]
[null,"        .PrintGridlines = False"]
[null,"        .PrintComments = xlPrintNoComments"]
[null,"        .CenterHorizontally = False"]
[null,"        .CenterVertically = False"]
[null,"        .Orientation = xlPortrait"]
[null,"        .Draft = False"]
[null,"        .PaperSize = xlPaperA4"]
[null,"        .FirstPageNumber = xlAutomatic"]
[null,"        .Order = xlDownThenOver"]
[null,"        .BlackAndWhite = False","čenobíle"]
[null,"        .Zoom = 100"]
[null,"        .PrintErrors = xlPrintErrorsDisplayed"]
[null,"        .OddAndEvenPagesHeaderFooter = True"]
[null,"        .DifferentFirstPageHeaderFooter = True"]
[null,"        .ScaleWithDocHeaderFooter = True"]
[null,"        .AlignMarginsHeaderFooter = True"]
[null,"        .EvenPage.LeftHeader.Text = \"Záhlaví sudé\""]
[null,"        .EvenPage.CenterHeader.Text = \"\""]
[null,"        .EvenPage.RightHeader.Text = \"\""]
[null,"        .EvenPage.LeftFooter.Text = \"\""]
[null,"        .EvenPage.CenterFooter.Text = \"\""]
[null,"        .EvenPage.RightFooter.Text = \"\""]
[null,"        .FirstPage.LeftHeader.Text = \"Záhlaví první stránka\""]
[null,"        .FirstPage.CenterHeader.Text = \"\""]
[null,"        .FirstPage.RightHeader.Text = \"\""]
[null,"        .FirstPage.LeftFooter.Text = \"\""]
[null,"        .FirstPage.CenterFooter.Text = \"\""]
[null,"        .FirstPage.RightFooter.Text = \"\""]
[null,"    End With"]

{"sheet":"Záhlaví a zápatí","index":3,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Podrobněji o tisku záhlaví  a zápatí"]
[]
[null,"Sub Date_Time()"]
[null,"    ActiveSheet.PageSetup.CenterHeader = \"&D  &B&ITime:&I&B&T\""]
[null,"End Sub"]
[]
[]
[]
[null,"Format code","Description"]
[null,"&L","Left aligns the characters that follow."]
[null,"&C","Centers the characters that follow."]
[null,"&R","Right aligns the characters that follow."]
[null,"&E","Turns double-underline printing on or off."]
[null,"&X","Turns superscript printing on or off."]
[null,"&Y","Turns subscript printing on or off."]
[null,"&B","Turns bold printing on or off."]
[null,"&I","Turns italic printing on or off."]
[null,"&U","Turns underline printing on or off."]
[null,"&S","Turns strikethrough printing on or off."]
[null,"&\"fontname\"","Prints the characters that follow in the specified font. Be sure to include the double quotation marks."]
[null,"&nn","Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points."]
[null,"&color","Prints the characters in the specified color. User supplies a hexidecimal color value."]
[null,"VBA code","Description"]
[null,"&D","Prints the current date."]
[null,"&T","Prints the current time."]
[null,"&F","Prints the name of the document."]
[null,"&A","Prints the name of the workbook tab."]
[null,"&P","Prints the page number."]
[null,"&P+number","Prints the page number plus the specified number."]
[null,"&P-number","Prints the page number minus the specified number."]
[null,"&&","Prints a single ampersand."]
[null,"&N","Prints the total number of pages in the document."]
[null,"&Z","Prints the file path."]
[null,"&G","Inserts an image."]

{"sheet":"List3","index":4,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,0,0,8],[1,0,1,8],[4,0,4,8],[7,0,7,8]]}
["Ukázky kódu tisk - Excel VBA"]
["http://office.lasakovi.com"]
[]
[]
["List 3 skrytý"]
[]
[]
["Vytvořeno: 2013"]