MathNya / umya-spreadsheet

A pure rust library for reading and writing spreadsheet files
MIT License
239 stars 41 forks source link

xml escape character "&" is corrupting sheetname on write #143

Closed agentjill closed 7 months ago

agentjill commented 7 months ago

in book.get_sheet_by_name_mut("Sheet2").unwrap().get_cell_mut("A1").set_value("TEST1");

if the sheet name contains xml escape characters for example say Alice&Bob then it is not detecting the Worksheet.

On inspection the ''Alice&Bob'' is being processed as Alice&Bob, that would mean that xml escape character & is not properly read as &.

calling sheet by Alice&Bobis saving the workbook as Alice&&Bob

MathNya commented 7 months ago

@agentjill Thank you for your report. We will address this in the next version update.

agentjill commented 7 months ago

This was addressed in #145.