Workbook Title does not allow ampersand "&" #1690
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!
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.
No due date set.
No dependencies set.
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?