search

co-analysis / a11ytables

R package: generate best-practice stats spreadsheets for publication
https://co-analysis.github.io/a11ytables/
Other
41 stars 3 forks source link

Apply proper header styles #42

Open matt-dray opened 2 years ago

matt-dray commented 2 years ago

The guidance says that sheet titles should be header H1. I can't see how to do this in {openxlsx}.

Also not sure if Excel can actually distinguish between simply adding H1 markup vs H1 style.

I think you apply H1 by applying it as a style, as per the Home > Cell styles menu:

Screenshot 2022-03-03 at 16 44 11

It's possible that marking-up the cell will invoke the 'H1 cell style' that's default in Excel, which we don't want.

(Thanks for the reminder of this, @phil-hall-moj)

matt-dray commented 2 years ago

Also H2 headers to the subheadings on the cover page, for example.