Inconsistent conversion of escaped characters (character entities) - `'`, `&`

[aushev]

Describe the bug
When text in the cell contains escaped characters written like ', & etc - some of them are converted (< becomes < etc) while others are not (& remains the same).

To Reproduce
Create an xlsx file with the following text in the cell:
B&J @ 12 O' clock. It's < 3

run the code:

dt1 <- openxlsx::read.xlsx(fn1); 
dt1$col1

Expected behavior
Ideally, should have the content unchanged:
B&J @ 12 O' clock. It's < 3
At worst, should convert all such characters in the same way:
B&J @ 12 O' clock. It's < 3

Screenshots

Note that other packages (openxlsx2, readxl) treat it correctly.

[JanMarvin]

Hi @aushev , thanks for the report, but openxlsx is no longer actively developed. If you want to provide a patch, please go ahead, but otherwise you're advised to use the mentioned alternatives.

[aushev]

ah sorry I didn't realize it, thanks for letting me know