Changing the look with a template

The default template

The package ships one template. It is A4 with one-inch margins and Arial 11 point text.

library(convertxlsform)

default_template <- system.file("templates", "convertxlsform.docx",
                                package = "convertxlsform")
basename(default_template)
#> [1] "convertxlsform.docx"

The template is built by the script dev/make_template.R in the source repository. Read it to see every value the default styles use.

Start your own template from a copy of the default one, so that every style the package looks for is already there.

my_template <- file.path(tempdir(), "my_template.docx")
file.copy(default_template, my_template, overwrite = TRUE)
#> [1] TRUE

The styles convertxlsform uses

Each part of the paper form is written with one paragraph style. The style names are the names shown in Word and LibreOffice.

The answer options, answer lines and grids are Word tables, so they do not take a paragraph style. The template also defines cxf Choice, which the current version does not use.

If your template lacks one of these styles, that part of the form uses Normal with the package’s built-in spacing, so a template made from scratch still works. Keep the style names exactly as written above, including spaces and capital letters.

What a style controls

convertxlsform sets the font and size of all text directly, from the font_family and font_size options, and sets the colour of headings, hints, skip logic and the repeat banner. Those settings win over the template. What the template controls is the paragraph:

• space before and after, and line spacing;
• indents and alignment;
• shading and borders;
• “keep with next” and other page-break rules;
• the text colour of questions and notes.

So to change the font of the whole form, use font_family. To put a light rule above each question and give the repeat banner a different background, change the cxf Question and cxf Banner styles.

Changing the styles in Word or LibreOffice

In Microsoft Word:

1. Open your copy of the template.
2. Open the Styles pane (Home tab, the small arrow in the corner of the Styles group).
3. Right-click a style, for example cxf Question, and choose Modify.
4. Use Format > Paragraph for spacing and indents, and Format > Border for borders and shading.
5. Save the file as a Word document (.docx).

In LibreOffice Writer:

1. Open your copy of the template.
2. Press F11 to open the Styles deck and choose Paragraph Styles (with “All Styles” in the list at the bottom).
3. Right-click a style and choose Edit Style. The Indents & Spacing, Borders and Area tabs hold the settings.
4. Save with File > Save As, keeping the Word 2007-365 (.docx) format.

Do not rename the styles, and delete the sample text if you add any: the body of the template is not copied into the form.

Changing the styles in R

The officer package, which convertxlsform uses to write Word files, can change the styles too. The code below gives each question a thin grey rule above it and more space, makes question labels dark blue, and gives the repeat banner a pale yellow background.

library(officer)

tpl <- read_docx(my_template)
tpl <- docx_set_paragraph_style(
  tpl, style_id = "cxfQuestion", style_name = "cxf Question",
  base_on = "Normal",
  fp_p = fp_par(keep_with_next = TRUE, padding.top = 12, padding.bottom = 4,
                border.top = fp_border(color = "#BFBFBF", width = 0.5)),
  fp_t = fp_text_lite(color = "#00205B")
)
tpl <- docx_set_paragraph_style(
  tpl, style_id = "cxfBanner", style_name = "cxf Banner",
  base_on = "Normal",
  fp_p = fp_par(shading.color = "#FFF2CC", keep_with_next = TRUE,
                padding.top = 6, padding.bottom = 4),
  fp_t = fp_text_lite(bold = TRUE)
)
print(tpl, target = my_template)

Check that the styles are there with styles_info().

st <- styles_info(read_docx(my_template))
st[startsWith(st$style_name, "cxf"), c("style_id", "style_name")]
#>       style_id   style_name
#> 26 cxfQuestion cxf Question
#> 27     cxfHint     cxf Hint
#> 28    cxfLogic    cxf Logic
#> 29   cxfChoice   cxf Choice
#> 30     cxfNote     cxf Note
#> 31   cxfBanner   cxf Banner

Converting with your template

Pass the template with template. The example form ships with the package.

path <- system.file("extdata", "all_types", "all_types.xlsx",
                    package = "convertxlsform")
docx <- convertxlsform(path,
                       output = file.path(tempdir(), "all_types_custom.docx"),
                       template = my_template, overwrite = TRUE,
                       verbose = FALSE)
basename(docx)
#> [1] "all_types_custom.docx"
file.exists(docx)
#> [1] TRUE

From the terminal, the same conversion is:

Rscript -e 'convertxlsform::cli()' all_types.xlsx --template my_template.docx

Options that override the template

These options are applied to every document, whatever the template says:

For example, a letter-size form in Calibri 10 point with narrow margins, keeping the paragraph styles of your template:

docx_letter <- convertxlsform(
  path, output = file.path(tempdir(), "all_types_letter.docx"),
  template = my_template, page_size = "letter", margins_in = 0.75,
  font_family = "Calibri", font_size = 10, overwrite = TRUE, verbose = FALSE
)
basename(docx_letter)
#> [1] "all_types_letter.docx"

Header, footer and logo

The header (the form title and version) and the footer (the form ID, the date and the page number) are written by convertxlsform, and they replace any header or footer in the template. A logo placed in the template’s header is therefore not kept.

To add a logo, convert the form first, then open the Word file, double-click the header area and insert the picture (Insert > Pictures in Word, Insert > Image in LibreOffice). The header text convertxlsform wrote stays in place, so you can put the logo beside it. Make the PDF from the edited file, either from Word or LibreOffice with Save as PDF, or with docx_to_pdf():

docx_to_pdf(docx)

Next steps

• The “Getting started” vignette covers languages, the outline and PDF output.
• ?convertxlsform describes every option.