Subject: CVS commit: pkgsrc/textproc/R-openxlsx
From: Makoto Fujiwara
Date: 2025-01-03 09:09:58
Message id: 20250103080958.9BC0EFC1D@cvs.NetBSD.org

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))

Files:
RevisionActionfile
1.4modifypkgsrc/textproc/R-openxlsx/Makefile
1.5modifypkgsrc/textproc/R-openxlsx/distinfo