test_that("Page setup", { wb <- wb_workbook() wb$add_worksheet("s1") wb$add_worksheet("s2") wb$page_setup( sheet = "s1", orientation = "landscape", scale = 100, left = 0.1, right = 0.1, top = 0.75, bottom = 0.75, header = 0.1, footer = 0.1, fit_to_width = TRUE, fit_to_height = TRUE, paper_size = 1, summary_row = "below", summary_col = "right" ) wb$page_setup( sheet = 2, orientation = "landscape", scale = 100, left = 0.1, right = 0.1, top = 0.75, bottom = 0.75, header = 0.1, footer = 0.1, fit_to_width = TRUE, fit_to_height = TRUE, paper_size = 1, summary_row = "below", summary_col = "right" ) expect_equal(wb$worksheets[[1]]$pageSetup, wb$worksheets[[2]]$pageSetup) v <- gsub(" ", "", wb$worksheets[[1]]$pageSetup, fixed = TRUE) expect_true(grepl('paperSize="1"', v)) expect_true(grepl('orientation="landscape"', v)) expect_true(grepl('fitToWidth="1"', v)) expect_true(grepl('fitToHeight="1"', v)) pr <- wb$worksheets[[1]]$sheetPr # SheetPr will be a character vector of length 2; the first entry will # be for pageSetupPr, inserted by `fitToWidth`/`fitToHeight`. expect_true(grepl('', pr[2], fixed = TRUE)) }) test_that("page_breaks", { temp <- temp_xlsx() wb <- wb_workbook() wb$add_worksheet("Sheet 1") wb$add_data(sheet = 1, x = iris) wb$add_page_break(sheet = 1, row = 10) wb$add_page_break(sheet = 1, row = 20) wb$add_page_break(sheet = 1, col = 2) rbrk <- c("", "" ) cbrk <- "" expect_equal(wb$worksheets[[1]]$rowBreaks, rbrk) expect_equal(wb$worksheets[[1]]$colBreaks, cbrk) wb$save(temp) wb2 <- wb_load(temp) expect_equal( wb$worksheets[[1]]$colBreaks, wb2$worksheets[[1]]$colBreaks ) expect_equal( wb$worksheets[[1]]$rowBreaks, wb2$worksheets[[1]]$rowBreaks ) })