Skip to content

openxlsx 4.2.5

Choose a tag to compare

@JanMarvin JanMarvin released this 11 Dec 09:34
a403e72

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)