Import file with formula shows `&` instead of `&`

[aster-hu]

I have a spreadsheet that contains formula which generates value with special character &. However when importing the file using read.xlsx, all & become &

A sample of spreadsheet sample_data.xlsx.

This is what it looks like in excel	colA	colB
colB is text	US & Canada
colB is formula (=B2)	US & Canada

Note: the 2nd observation in colB is a formula =B2

# import
df <- openxlsx::read.xlsx("sample_data.xlsx")
df

This is what the result shows in R:	colA	colB
colB is text	US & Canada
colB is formula (=B2)	US & Canada

[github-actions[bot]]

This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 7 days with no activity.