Workbook Title does not allow ampersand "&" #1690

New Issue

2019-11-26T14:28:10Z

karlbecker commented

2019-11-26 14:28:10 +00:00

(Migrated from github.com)

Hello!
I recently found an issue with setting a Workbook's Title to text that has an ampersand & in it.

When I do that, I get this nasty error when trying to open the Excel doc:

The Excel doc happened to have & in the name, too, but that didn't seem to be the root of the problem. Instead, things started working fine once I got rid of the & in the workbook's Title property.

Thanks for a great tool!

Hello! I recently found an issue with setting a Workbook's Title to text that has an ampersand `&` in it. When I do that, I get this nasty error when trying to open the Excel doc: ![image](https://user-images.githubusercontent.com/1091559/69641746-5dfec200-1026-11ea-9e27-40ef514a8ac4.png) The Excel doc happened to have `&` in the name, too, but that didn't seem to be the root of the problem. Instead, things started working fine once I got rid of the `&` in the workbook's Title property. Thanks for a great tool!

karlbecker commented

2019-11-26 14:32:02 +00:00

(Migrated from github.com)

Also note that I emailed the SheetJS team before creating this, and they confirmed both that it's a bug on write, and mentioned that there's a bug on reading files with an & in the Title, too:

It's a bug, xml entities in core properties should be encoded/decoded correctly. You can see this affects read as well -- the title when reading a similar file is Something with an & in it

So both a read and a write piece to this fix.

Also note that I emailed the SheetJS team before creating this, and they confirmed both that it's a bug on write, and mentioned that there's a bug on reading files with an `&` in the Title, too: > It's a bug, xml entities in core properties should be encoded/decoded correctly. You can see this affects read as well -- the title when reading a similar file is `Something with an & in it` So both a read and a write piece to this fix.

Sign in to join this conversation.