michael-m52

writeFormula with HYPERLINK creates unparseable XML: read.xlsx doesn't read "Text to display" from a file created by openxlsx

14

**Describe the bug** This happens when read.xslx encounters a HYPERLINK formula. If the xlsx being read is a normal Excel file, the corresponding cell in the data.frame has the "friendly...

createWorkbook "Created" date is offset by timezone difference

3

**Describe the bug** The "Created" date and time that appears in the Info section is out by the timezone offset. It is 5pm here now, when I ran the code,...

loadWorkbook does not retain Headers and Footers that have "escape code" formatting

12

**Describe the bug** 1) There is an open feature request on another branch to be able to format Headers and Footers: https://github.com/awalker89/openxlsx/issues/369 2) A user has suggested a workaround using...

**Describe the bug** This bug first appears in 4.2.4 and is still in 4.2.5 NA is specified in the documentation as "skip position", but it is actually being sent to...