head 1.5; access; symbols pkgsrc-2026Q3:1.5.0.4 pkgsrc-2026Q3-base:1.5 pkgsrc-2026Q2:1.5.0.2 pkgsrc-2026Q2-base:1.5 pkgsrc-2026Q1:1.4.0.10 pkgsrc-2026Q1-base:1.4 pkgsrc-2025Q4:1.4.0.8 pkgsrc-2025Q4-base:1.4 pkgsrc-2025Q3:1.4.0.6 pkgsrc-2025Q3-base:1.4 pkgsrc-2025Q2:1.4.0.4 pkgsrc-2025Q2-base:1.4 pkgsrc-2025Q1:1.4.0.2 pkgsrc-2025Q1-base:1.4 pkgsrc-2024Q4:1.3.0.28 pkgsrc-2024Q4-base:1.3 pkgsrc-2024Q3:1.3.0.26 pkgsrc-2024Q3-base:1.3 pkgsrc-2024Q2:1.3.0.24 pkgsrc-2024Q2-base:1.3 pkgsrc-2024Q1:1.3.0.22 pkgsrc-2024Q1-base:1.3 pkgsrc-2023Q4:1.3.0.20 pkgsrc-2023Q4-base:1.3 pkgsrc-2023Q3:1.3.0.18 pkgsrc-2023Q3-base:1.3 pkgsrc-2023Q2:1.3.0.16 pkgsrc-2023Q2-base:1.3 pkgsrc-2023Q1:1.3.0.14 pkgsrc-2023Q1-base:1.3 pkgsrc-2022Q4:1.3.0.12 pkgsrc-2022Q4-base:1.3 pkgsrc-2022Q3:1.3.0.10 pkgsrc-2022Q3-base:1.3 pkgsrc-2022Q2:1.3.0.8 pkgsrc-2022Q2-base:1.3 pkgsrc-2022Q1:1.3.0.6 pkgsrc-2022Q1-base:1.3 pkgsrc-2021Q4:1.3.0.4 pkgsrc-2021Q4-base:1.3 pkgsrc-2021Q3:1.3.0.2 pkgsrc-2021Q3-base:1.3 pkgsrc-2021Q2:1.2.0.16 pkgsrc-2021Q2-base:1.2 pkgsrc-2021Q1:1.2.0.14 pkgsrc-2021Q1-base:1.2 pkgsrc-2020Q4:1.2.0.12 pkgsrc-2020Q4-base:1.2 pkgsrc-2020Q3:1.2.0.10 pkgsrc-2020Q3-base:1.2 pkgsrc-2020Q2:1.2.0.8 pkgsrc-2020Q2-base:1.2 pkgsrc-2020Q1:1.2.0.4 pkgsrc-2020Q1-base:1.2 pkgsrc-2019Q4:1.2.0.6 pkgsrc-2019Q4-base:1.2 pkgsrc-2019Q3:1.2.0.2 pkgsrc-2019Q3-base:1.2; locks; strict; comment @# @; 1.5 date 2026.05.26.13.59.19; author mef; state Exp; branches; next 1.4; commitid WtNqXPnzjiZbwkHG; 1.4 date 2025.01.03.08.09.58; author mef; state Exp; branches; next 1.3; commitid xJNLVMBYjG0KU0EF; 1.3 date 2021.09.08.13.38.35; author mef; state Exp; branches; next 1.2; commitid kzOOeeQCipTLI98D; 1.2 date 2019.08.08.19.53.57; author brook; state Exp; branches; next 1.1; commitid K2VPfA0XCw7xfgyB; 1.1 date 2019.07.31.13.48.46; author brook; state Exp; branches; next ; commitid EEABVn7GX1fQwcxB; desc @@ 1.5 log @(textproc/R-openxlsx) Fix build against R 4.6.0 @ text @# $NetBSD: Makefile,v 1.4 2025/01/03 08:09:58 mef Exp $ R_PKGNAME= openxlsx R_PKGVER= 4.2.7.1 CATEGORIES= textproc MAINTAINER= pkgsrc-users@@NetBSD.org COMMENT= Read, write and edit XLSX files LICENSE= mit DEPENDS+= R-zip>=2.0.3:../../archivers/R-zip DEPENDS+= R-stringi-[0-9]*:../../textproc/R-stringi # Packages suggested but not available: 'formula.tools' TEST_DEPENDS+= R-curl-[0-9]*:../../www/R-curl TEST_DEPENDS+= R-knitr-[0-9]*:../../print/R-knitr TEST_DEPENDS+= R-testthat-[0-9]*:../../devel/R-testthat TEST_DEPENDS+= R-roxygen2-[0-9]*:../../devel/R-roxygen2 TEST_DEPENDS+= R-rmarkdown-[0-9]*:../../textproc/R-rmarkdown USE_LANGUAGES= c c++ # only for ifne in patches/patch-src_Makevars USE_TOOLS+= gmake .include "../../math/R/Makefile.extension" .include "../../devel/R-Rcpp/buildlink3.mk" .include "../../mk/bsd.pkg.mk" @ 1.4 log @(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)) @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.3 2021/09/08 13:38:35 mef Exp $ d23 2 @ 1.3 log @(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 @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.2 2019/08/08 19:53:57 brook Exp $ d4 1 a4 1 R_PKGVER= 4.2.4 d14 3 @ 1.2 log @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 @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.1 2019/07/31 13:48:46 brook Exp $ d4 1 a4 1 R_PKGVER= 4.1.0.1 d12 6 @ 1.1 log @R-openxlsx: initial commit. Simplifies the creation of Excel .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of 'Rcpp', read/write times are comparable to the 'xlsx' and 'XLConnect' packages with the added benefit of removing the dependency on Java. @ text @d1 1 a1 1 # $NetBSD$ d3 3 a5 1 CATEGORIES= textproc R a7 1 HOMEPAGE= ${R_HOMEPAGE_BASE}/openxlsx/ a10 3 R_PKGNAME= openxlsx R_PKGVER= 4.1.0.1 @