context("check formatting") library(xml2) library(officer) test_that("shortcut functions", { ft <- flextable(head(mtcars, n = 2)) ft <- bg(x = ft, bg = "red", j = 1, part = "all") ft <- bold(x = ft, bold = TRUE, j = 2, part = "all") ft <- fontsize(x = ft, size = 9, j = 3, part = "all") ft <- italic(x = ft, italic = TRUE, j = 4, part = "all") ft <- color(x = ft, color = "gray", j = 5, part = "all") ft <- padding(x = ft, padding = 5, j = 6, part = "all") ft <- align(x = ft, align = "left", j = 7, part = "all") ft <- border(x = ft, border = fp_border(color = "orange"), j = 8, part = "all") docx_file <- tempfile(fileext = ".docx") doc <- read_docx() doc <- body_add_flextable(doc, value = ft) doc <- print(doc, target = docx_file) main_folder <- file.path(getwd(), "docx_folder") unpack_folder(file = docx_file, folder = main_folder) doc_file <- file.path(main_folder, "/word/document.xml") doc <- read_xml(doc_file) nodes <- xml_find_all(doc, "w:body/w:tbl/w:tr/w:tc[1]/w:tcPr/w:shd") expect_equal(xml_attr(nodes, "fill"), c("FF0000", "FF0000", "FF0000")) nodes <- xml_find_all(doc, "w:body/w:tbl/w:tr/w:tc[2]/w:p/w:r/w:rPr/w:b") expect_length(nodes, 3) nodes <- xml_find_all(doc, "w:body/w:tbl/w:tr/w:tc[3]/w:p/w:r/w:rPr/w:sz") expect_equal(xml_attr(nodes, "val"), c("18", "18", "18")) nodes <- xml_find_all(doc, "w:body/w:tbl/w:tr/w:tc[4]/w:p/w:r/w:rPr/w:i") expect_length(nodes, 3) nodes <- xml_find_all(doc, "w:body/w:tbl/w:tr/w:tc[5]/w:p/w:r/w:rPr/w:color") expect_equal(xml_attr(nodes, "val"), c("BEBEBE", "BEBEBE", "BEBEBE")) nodes <- xml_find_all(doc, "w:body/w:tbl/w:tr/w:tc[6]/w:p/w:pPr/w:spacing") expect_equal(xml_attr(nodes, "after"), rep("100", 3)) expect_equal(xml_attr(nodes, "before"), rep("100", 3)) nodes <- xml_find_all(doc, "w:body/w:tbl/w:tr/w:tc[6]/w:p/w:pPr/w:ind") expect_equal(xml_attr(nodes, "left"), rep("100", 3)) expect_equal(xml_attr(nodes, "right"), rep("100", 3)) nodes <- xml_find_all(doc, "w:body/w:tbl/w:tr/w:tc[7]/w:p/w:pPr/w:jc") expect_equal(xml_attr(nodes, "val"), rep("left", 3)) nodes <- xml_find_all(doc, "w:body/w:tbl/w:tr/w:tc[8]/w:tcPr/w:tcBorders/*") expect_true(all(xml_attr(nodes, "color") == "FFA500")) unlink(main_folder, recursive = TRUE, force = TRUE) }) tab <- data.frame(x = c("Row1", "Row2"), y = c(1, 2)) ft <- flextable(tab) ft <- border_remove(ft) ft <- hline(ft, i = 1:2, j = 2, part = "body") ft <- delete_part(ft, part = "header") test_that("borders with office docs are sanitized", { docx_file <- tempfile(fileext = ".docx") pptx_file <- tempfile(fileext = ".pptx") save_as_docx(ft, path = docx_file) save_as_pptx(ft, path = pptx_file) docx <- read_docx(docx_file) doc <- docx_body_xml(docx) top_nodes <- xml_find_all(doc, "w:body/w:tbl/w:tr/w:tc/w:tcPr/w:tcBorders/w:top") bot_nodes <- xml_find_all(doc, "w:body/w:tbl/w:tr/w:tc/w:tcPr/w:tcBorders/w:bottom") expect_equal(xml_attr(top_nodes, "color"), c("000000", "000000", "000000", "666666")) expect_equal(xml_attr(bot_nodes, "color"), c("000000", "666666", "000000", "666666")) pptx <- read_pptx(pptx_file) slide <- pptx$slide$get_slide(1)$get() top_nodes <- xml_find_all(slide, "//a:tbl/a:tr/a:tc/a:tcPr/a:lnT") bot_nodes <- xml_find_all(slide, "//a:tbl/a:tr/a:tc/a:tcPr/a:lnB") expect_equal(xml_attr(top_nodes, "w"), c("0", "0", "0", "12700")) expect_equal(xml_attr(bot_nodes, "w"), c("0", "12700", "0", "12700")) })