add_formatted_worksheet
now removes hexadecimal and octal code for record separator and unit separator before writing to Excel. These have to be removed, else the Excel sheet cannot be read properly.
-
Updated README including installation guide.
-
standardised help for all functions.
-
Created
append_text_line
for appending a line with explanatory text to a data frame before writing it to Excel. -
Created
style_text_line
to style a line in an Excel sheet based on text content in one cell.
-
Updated documentation (help, README and CONTRIBUTING).
-
Improved argument checking of functions formatting Excel workbooks.
theme_NVI
colour for axis text is corrected to grey65.
theme_NVI
has got a thinner horizontal line.
- Vignette: "Create graphs for NVI".
theme_NVI
for use withggplot2
is included. The theme is in accord with NVI's graphical profile.
- Corrected installation instruction in README.
- Solved problems with installation.
-
add_formatted_worksheet
includes the argumentFUN
. -
style_background_per_column styles cell background in Excel sheet based on column name. The rule decide which columns to style.
-
added palettes with colours in accord with the graphical profile, i.e. palette_NVI_profile, palette_table_blue, palette_table_grey and palette_graph.
- Vignette: "Contribute to NVIpretty".
- fixed error if
colwidths
=FALSE
.
- Standard column width changed to 10.71
- corrected difficulties installing NVIpretty due to missing information on imported package NVIdb.
- Corrected copyright holder to Norwegian Veterinary Institute.
add_formatted_worksheet
: ifcolwidths
=TRUE
and nocolwidths
were defined in column_standard table, the column widths is set to 10.78. The column width is also set to 10.78 ifcolwidths
=FALSE
.
add_formatted_worksheet
: the parametercolwidths
accepts the parameter "auto" for automatic sizing of column width.
- In
add_formatted_worksheet
the parameterscollabels
andcolwidths
now accepts the parameterFALSE
.
- corrected column width and
dbsource
inadd_formatted_worksheet
.
add_formatted_worksheet
is a wrapper aroundopenxslx::addWorksheet
that adds a worksheet header with bold text, changes column names to standard labels and includes standard column widths according to colnames. Standardization is based onNVIdb::standardize_columns
.