XLConnect 1.0.6 now available from CRAN and from our GitHub repository.
We are pleased to announce the release of XLConnect 1.0.6. This release is mainly a maintenance release and comes with the following changes:
overwriteFormulaCells
parameter to writeNamedRegion
, appendNamedRegion
, writeWorkSheet
(#173)setForceFormulaRecalculation
/ getForceFormulaRecalculation
for R >= 4.2.0 (#170)While the addition of the overwriteFormulaCells
parameter seems like a new implementation, it is actually an adjustment due to updates in the underlying Apache POI:
appendNamedRegion
, writeNamedRegion
and writeWorksheet
will once again overwrite formula cells.overwriteFormulaCells
as FALSE
when calling said functions.