Path to this page:
Subject: CVS commit: pkgsrc/textproc/R-openxlsx
From: Makoto Fujiwara
Date: 2021-09-08 15:38:36
Message id: 20210908133836.1A072FA97@cvs.NetBSD.org
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
Files: