Log message:
(textproc/R-openxlsx) Updated 4.2.4 to 4.2.7.1

# openxlsx 4.2.7.1

* It's now possible to insert a hyperlinked image by passing a URL,
  relative or absolute file path, or mailto string to the new
  `address` parameter of `insertImage()`.

# openxlsx 4.2.7

* Fixed warning on `dataValidation(..., type = "list")`
  ([#342](https://github.com/ycphs/openxlsx/issues/342))

* Added optional argument to `loadWorkbook` to decide if empty/blank
  cells should be converted to NA_character_ (the default) or left
  blank as is

* `saveWorkbook()` now succeeds when called after the user has set
  column widths for a range of columns (e.g. 1:2), saved the workbook,
  then set column widths for a new range that is inclusive of the
  previous one (e.g. 1:5)
  ([#493](https://github.com/ycphs/openxlsx/issues/493)).

## Improvements

* Improve detectDates
  ([#288](https://github.com/ycphs/openxlsx/issues/288))

* Preserve window size and position, also `getWindowSize()` and
  `setWindowSize()`
  ([466](https://github.com/ycphs/openxlsx/pull/466))

# openxlsx 4.2.6

* Fix external links
  ([#410](https://github.com/ycphs/openxlsx/pull/410))

* Do not add unneccessary sheetPr node
  ([#409](https://github.com/ycphs/openxlsx/pull/409))

* Add support for `namedRegion`s having dots and other special
  characters ([#338](https://github.com/ycphs/openxlsx/issues/338)).

* Add type blanks and not blanks to conditional formatting
  ([#311](https://github.com/ycphs/openxlsx/pull/311))

# openxlsx 4.2.5

## Fixes

* `openxlsx_setOp()` now works with named list
  ([#215](https://github.com/ycphs/openxlsx/issues/215))

* `loadWorkbook()` imports `inlineStr`. Values remain `inlineStr` when
  writing the workbook with `saveWorkbook()`. Similar `read.xlsx` and
  `readWorkbook` import `inlineStr`.

* `read.xlsx()` no longer changes random seed
  ([#183](https://github.com/ycphs/openxlsx/issues/183))

* fixed a regression that caused fonts to be read in incorrectly
  ([#207](https://github.com/ycphs/openxlsx/issues/207))

* add option to save as read only recommended
  ([#201](https://github.com/ycphs/openxlsx/issues/201))

* fixed writing hyperlink formulas
  ([#200](https://github.com/ycphs/openxlsx/issues/200))

* `write.xlsx()` now throws an error if it doesn't have write
  permissions ([#190](https://github.com/ycphs/openxlsx/issues/190))

* `write.xlsx()` now again uses the default of `overwrite = TRUE` for
  saving files ([#249](https://github.com/ycphs/openxlsx/issues/249))

* `as.character.formula()` exported to warn about potential conflicts
  with other packages
  ([#312](https://github.com/ycphs/openxlsx/issues/312),
  [#315](https://github.com/ycphs/openxlsx/pull/315))

## Improvements

* `options()` are more consistently set in functions (see:
  [#289](https://github.com/ycphs/openxlsx/issues/262))

* `Workbook$show()` no longer fails when called in a 0 sheet
  workbook([#240](https://github.com/ycphs/openxlsx/issues/240))

* `read.xlsx()` again accepts `.xlsm` files
([#205](https://github.com/ycphs/openxlsx/issues/205),
[#209](https://github.com/ycphs/openxlsx/issues/209))

* `makeHyperlinkString()` does no longer require a sheet argument
  ([#57](https://github.com/ycphs/openxlsx/issues/57),
  [#58](https://github.com/ycphs/openxlsx/issues/58))

* improvements in how `openxlsx` creates temporary directories (see
  [#262](https://github.com/ycphs/openxlsx/issues/262))

* `writeData()` calls `force(x)` to evaluate the object before options
  are set ([#264](https://github.com/ycphs/openxlsx/issues/264))

* `createComment()` now correctly handles `integers` in `width` and
  `height` ([#275](https://github.com/ycphs/openxlsx/issues/275))

* `setStyles()` accepts `halign="justify"`
  ([#305](https://github.com/ycphs/openxlsx/issues/305))

Log message:
textproc: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

Unfetchable distfiles (fetched conditionally?):
./textproc/convertlit/distinfo clit18src.zip

Log message:
textproc: Remove SHA1 hashes for distfiles

Log message:
(textproc/R-openxlsx) Updated 4.1.0.1 to 4.2.4, make test passes

# development  openxlsx 4.2.4

## Fixes

* `Write.xlsx()` now successfully passes `withFilter`
  ([#151](https://github.com/ycphs/openxlsx/issues/151))
* code clean up PR [#168](https://github.com/ycphs/openxlsx/pull/168)
* removal of unused variables PR
  [#168](https://github.com/ycphs/openxlsx/pull/168)

## New features

* adds `buildWorkbook()` to generate a `Workbook` object from a
  (named) list or a data.frame
  ([#192](https://github.com/ycphs/openxlsx/issues/192),
  [#187](https://github.com/ycphs/openxlsx/issues/187))
  * this is now recommended rather than the `write.xlsx(x, file) ; wb
    <- read.xlsx(file)` functionality before
  * `write.xlsx()` is now a wrapper for `wb <- buildWorkbook(x);
    saveWorkbook(x, file)`
  * parameter checking from `write.xlsx()` >> `buildWorkbook()` are
    now held off until passed to `writeData()`, `writeDataTable()`,
    etc
  * `row.names` is now deprecated for `writeData()` and
    `writeDataTable()`; please use `rowNames` instead
* `read.xlsx()` now checks for the file extension `.xlsx`; previously
  it would throw an error when the file was `.xls` or `.xlm` files

* memory allocation improvements
* global options added for `minWidth` and `maxWidth`

* `write.xlsx()` >> `buildWorkbook()` can now handle `colWidths`
  passed as either a single element or a `list()`

* Added ability to change positioning of summary columns and rows.
  * These can be set with the `summaryCol` and `summaryRow` arguments
    in `pageSetup()`.

* `activeSheet` allows to set and get the active (displayed) sheet of a worbook.

* Adds new global options for workbook formatting
  ([#165](https://github.com/ycphs/openxlsx/issues/165); see
  `?op.openxlsx`)

# openxlsx 4.2.3

## New Features

* Most of functions in openxlsx now support non-ASCII arguments
  better. More specifically, we can use non-ASCII strings as names or
  contents for `createNamedRegion()`
  ([#103](https://github.com/ycphs/openxlsx/issues/103)),
  `writeComment()`, `writeData()`, `writeDataTable()` and
  `writeFormula()`. In addition, openxlsx now reads comments and
  region names that contain non-ASCII strings correctly on
  Windows. Thanks to @shrektan for the PR
  [#118](https://github.com/ycphs/openxlsx/pull/118).

* `setColWidths()` now supports zero-length `cols`, which is
  convinient when `cols` is dynamically provided
  [#128](https://github.com/ycphs/openxlsx/issues/128). Thanks to
  @shrektan for the feature request and the PR.

## Fixes for Check issues

* Fix to pass the tests for link-time optimization type mismatches

* Fix to pass the checks of native code (C/C++) based on static code
  analysis

## Bug Fixes

* Grouping columns after setting widths no longer throws an error
  ([#100](https://github.com/ycphs/openxlsx/issues/100))

* Fix inability to save workbook more than once
  ([#106](https://github.com/ycphs/openxlsx/issues/106))

* Fix `loadWorkbook()` sometimes importing incorrect column attributes

# openxlsx 4.2.2

## New Features

* Added features for `conditionalFormatting` to support also 'contains
  not', 'begins with' and 'ends with'

* Added return value for `saveWorkbook()` the default value for
  `returnValue` is `FALSE`
  ([#71](https://github.com/ycphs/openxlsx/issues/71))

* Added Tests for new parameter of `saveWorkbook()`

## Bug Fixes

* Solved CRAN check errors based on the change disussed in
  [PR#17277](https://bugs.r-project.org/bugzilla3/show_bug.cgi?id=17277)

# openxlsx 4.2.0

## New Features

* Added `groupColumns()`, `groupRows()`, `ungroupColumns()`, and
  `ungroupRows()` to group/ugroup columns/rows
  ([#32](https://github.com/ycphs/openxlsx/issues/32))

## Bug Fixes

* Allow xml-sensitve characters in sheetnames
  ([#78](https://github.com/ycphs/openxlsx/issues/78))

## Internal

* Updated roxygen2 to 7.1.1

# openxlsx 4.1.5.1

## Bug Fixes

*  fixed issue [#68](https://github.com/ycphs/openxlsx/issues/68])

# openxlsx 4.1.5

## New Features

*  Add functions to get and set the creator of the xlsx file

*  add function to set the name of the user who last modified the xlsx file

## Bug Fixes

*  Fixed NEWS hyperlink

*  Fixed writing of mixed EST/EDT datetimes

* Added description for `writeFormula()` to use only english function
   names

*  Fixed validateSheet for special characters

## Internal

*  applied the tidyverse-style to the package `styler::style_pkg()`

*  include tests for `cloneWorksheet`

# openxlsx 4.1.4

## New Features

* Added `getCellRefs()` as
   function. [#7](https://github.com/ycphs/openxlsx/issues/7)

*  Added parameter for customizing na.strings

## Bug Fixes

*  Use `zip::zipr()` instead of `zip::zip()`.

* Keep correct visibility option for
   loadWorkbook. [#12](https://github.com/ycphs/openxlsx/issues/12])

* Add space surrounding "wrapText"
   [#17](https://github.com/ycphs/openxlsx/issues/17)

* Corrected Percentage, Accounting, Comma, Currency class on column
   level

*  update to rogygen2 7.0.0

# openxlsx 4.1.3

## New Features

*  Added a `NEWS.md` file to track changes to the package.
*  Added `pkgdown` to create site.

## Bug Fixes

*  Return values for cpp changed to R_NilValue for r-devel tests

*  Added empty lines at the end of files

# openxlsx 4.1.2

*  Changed maintainer

# openxlsx 4.1.1

## New Features

* `sep.names` allows choose other separator than '.' for variable
   names with a blank inside

* Improve handling of non-region names in `getNamedRegions` and add
   related test

Log message:
Update all R packages to canonical form.

The canonical form [1] of an R package Makefile includes the
following:

- The first stanza includes R_PKGNAME, R_PKGVER, PKGREVISION (as
  needed), and CATEGORIES.

- HOMEPAGE is not present but defined in math/R/Makefile.extension to
  refer to the CRAN web page describing the package.  Other relevant
  web pages are often linked from there via the URL field.

This updates all current R packages to this form, which will make
regular updates _much_ easier, especially using pkgtools/R2pkg.

[1] http://mail-index.netbsd.org/tech-pkg/2019/08/02/msg021711.html