openxlsx - openxlsx 4.2.7

What's Changed

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

New Contributors

• @michael-dewar made their first contribution in https://github.com/ycphs/openxlsx/pull/487
• @StevenHibble-Concurrence made their first contribution in https://github.com/ycphs/openxlsx/pull/468
• @jistria made their first contribution in https://github.com/ycphs/openxlsx/pull/494

Full Changelog: https://github.com/ycphs/openxlsx/compare/v4.2.6...v4.2.7

- R
Published by JanMarvin almost 2 years ago

openxlsx - openxlsx 4.2.6

What's Changed

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

New Contributors

• @MichaelChirico made their first contribution in https://github.com/ycphs/openxlsx/pull/365
• @jmuhlenkamp made their first contribution in https://github.com/ycphs/openxlsx/pull/382
• @retostauffer made their first contribution in https://github.com/ycphs/openxlsx/pull/409
• @rpcach made their first contribution in https://github.com/ycphs/openxlsx/pull/400
• @bescoto made their first contribution in https://github.com/ycphs/openxlsx/pull/410
• @Moohan made their first contribution in https://github.com/ycphs/openxlsx/pull/421
• @krystian8207 made their first contribution in https://github.com/ycphs/openxlsx/pull/407
• @MKyhos made their first contribution in https://github.com/ycphs/openxlsx/pull/402
• @DavZim made their first contribution in https://github.com/ycphs/openxlsx/pull/418
• @olivroy made their first contribution in https://github.com/ycphs/openxlsx/pull/439
• @nanxstats made their first contribution in https://github.com/ycphs/openxlsx/pull/433
• @grantbrown made their first contribution in https://github.com/ycphs/openxlsx/pull/449

Full Changelog: https://github.com/ycphs/openxlsx/compare/v4.2.5...v4.2.6

- R
Published by JanMarvin almost 2 years ago

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

- R
Published by JanMarvin over 4 years ago

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

- R
Published by ycphs about 5 years ago

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

- R
Published by ycphs over 5 years ago

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

Bug Fixes

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

Internal

• Updated roxygen2 to 7.1.1

- R
Published by ycphs almost 6 years ago

openxlsx - CRAN release

- R
Published by ycphs about 6 years ago

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

- R
Published by ycphs over 6 years ago

openxlsx - CRAN release

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

- R
Published by ycphs over 6 years ago

openxlsx - CRAN release

CRAN release.

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

- R
Published by ycphs over 6 years ago