openxlsx 4.2.7

What's Changed

• [tests] fix broken skip_if_not_installed() by @JanMarvin in #481
• Preserve window size and position, also get and set (Clean Version) by @michael-dewar in #487
• fix warning thrown in (un)groupRows. closes #485 by @JanMarvin in #488
• silence -Wformat warning by @JanMarvin in #482
• PRs that were forgotten in development by @JanMarvin in #483
• Add pair_rc() to improve row/column pair lookups by @StevenHibble-Concurrence in #468
• Fix resaving workbook after resetting col widths by @jistria in #494
• 4.2.7 by @JanMarvin in #495

New Contributors

• @michael-dewar made their first contribution in #487
• @StevenHibble-Concurrence made their first contribution in #468
• @jistria made their first contribution in #494

Full Changelog: v4.2.6...v4.2.7

openxlsx 4.2.6

What's Changed

• Add type blanks and not blanks to conditional formatting. fixes #179 by @vkatti in #311
• add missing } by @MichaelChirico in #365
• Use lintr 3.0.0 style & linters by @MichaelChirico in #366
• Bugfix/fix vignette examples by @jmuhlenkamp in #382
• fix: Avoid adding an IP when not needed by @retostauffer in #409
• fixed typo - workbok -> workbook by @rpcach in #400
• Fix for content type and external link XML by @bescoto in #410
• fix warning in extLinksXML. closes #293 by @JanMarvin in #302
• Fix typos in bug_report.md by @Moohan in #421
• Add support for special characters within namedRegion. by @krystian8207 in #407
• Introduce Warning for table col name exceeding 255 chars by @MKyhos in #402
• adds functionality to delete a single column in the workbook by @DavZim in #418
• Remove dependency on roxygen2 by @olivroy in #439
• Improve offline testing by @nanxstats in #433
• Coerce matrix to data.frame in writexlsx.R by @grantbrown in #449
• adds as.character.formula() by @jmbarbone in #315
• Fix rdevel segfaults by @JanMarvin in #472
• Fix rdevel segfaults2 by @JanMarvin in #473
• Fix cran notes by @JanMarvin in #477
• fix loading "loadExample.xlsx" by @JanMarvin in #478
• Prepare 4.2.6 by @JanMarvin in #479

New Contributors

• @MichaelChirico made their first contribution in #365
• @jmuhlenkamp made their first contribution in #382
• @retostauffer made their first contribution in #409
• @rpcach made their first contribution in #400
• @bescoto made their first contribution in #410
• @Moohan made their first contribution in #421
• @krystian8207 made their first contribution in #407
• @MKyhos made their first contribution in #402
• @DavZim made their first contribution in #418
• @olivroy made their first contribution in #439
• @nanxstats made their first contribution in #433
• @grantbrown made their first contribution in #449

Full Changelog: v4.2.5...v4.2.6

openxlsx 4.2.5

Fixes

• openxlsx_setOp() now works with named list (#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)
• fixed a regression that caused fonts to be read in incorrectly (#207)
• add option to save as read only recommended (#201)
• fixed writing hyperlink formulas (#200)
• write.xlsx() now throws an error if it doesn't have write permissions (#190)
• write.xlsx() now again uses the default of overwrite = TRUE for saving files (#249)

Improvements

• options() are more consistently set in functions (see: #289)
• Workbook$show() no longer fails when called in a 0 sheet workbook(#240)
• read.xlsx() again accepts .xlsm files (#205,
  #209)
• makeHyperlinkString() does no longer require a sheet argument (#57, #58)
• improvements in how openxlsx creates temporary directories (see #262)
• writeData() calls force(x) to evaluate the object before options are set (#264)
• createComment() now correctly handles integers in width and height (#275)
• setStyles() accepts halign="justify" (#305)

openxlsx 4.2.4

Fixes

• write.xlsx() now successfully passes withFilter (#151)
• code clean up PR #168
• removal of unused variables PR #168

New features

• adds buildWorkbook() to generate a Workbook object from a (named) list or a data.frame (#192, #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; see ?op.openxlsx)

openxlsx 4.2.3

openxlsx 4.2.3

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)

• Fix inability to save workbook more than once (#106)

• Fix loadWorkbook() sometimes importing incorrect column attributes

openxlsx 4.2.2

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])(#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)

Bug Fixes

• Allow xml-sensitve characters in sheetnames (#78)

Internal

• Updated roxygen2 to 7.1.1

CRAN release

v4.1.5

Merge branch 'master' of https://github.com/ycphs/openxlsx

openxlsx 4.1.4

• Use zip::zipr() instead of zip::zip().

• Keep correct visibility option for loadWorkbook. #12

• Added getCellRefs as function. #7

• update to rogygen2 7.0.0

• Added parameter for customizing na.strings

• Add space surrounding "wrapText" #17

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

CRAN release

Update for new r-devel (return values for for Rcpp)

CRAN release

CRAN release.

Added Pull requests from former fork and submitted successfully to CRAN, because the package had the status orphaned.