freeze pane options in write.xlsx outputs to console

awalker89 / openxlsx

R package for .xlsx file reading and writing.

Other

364 stars 79 forks source link

freeze pane options in write.xlsx outputs to console #227

Closed t-kalinowski closed 7 years ago

t-kalinowski commented 7 years ago

small example:

> openxlsx::write.xlsx(mtcars, "mtcars.xlsx",  firstCol = TRUE, firstRow = TRUE)
[1] "<pane ySplit=\"1\" xSplit=\"1\" topLeftCell=\"B2\" activePane=\"bottomRight\" state=\"frozen\"/><selection pane=\"bottomRight\"/>"

as far as I can tell, the resulting file is fine. This probably should be returning the input object invisibly rather than this character string.

awalker89 commented 7 years ago

Thanks for the bug report. a57932a8f5d5dad7657f5d0818ac09f9ed9c04f6 fixes this.