Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Format escaping broken #258

Open
Troopster19 opened this issue Jan 8, 2020 · 1 comment
Open

Format escaping broken #258

Troopster19 opened this issue Jan 8, 2020 · 1 comment

Comments

@Troopster19
Copy link

Using a style of : -$*`` #,##0.00-;-$* #,##0.00_-;-$* "-"??-;-@- gets converted in numberFormatStandardized to: -$*\ #,##0.00-;-$\ #,##0.00_-;_-$\ "-"??-;-@_- and causes slashes to be visible in the cell. Changing line 811 to $escaped.= $c; instead of $escaped.= "\".$c; fixed it.

Not sure what the intended purpose of escaping those characters was but it breaks custom formats.

@mk-j
Copy link
Owner

mk-j commented May 31, 2023

XLSX is really just a zip of XML files. So when your write the numberFormat to XML you have to escape some characters to match excel. So I get that the escaping isn't working correctly for your format... but it would be interesting to see what your format looks like in the raw xml file within the xlsx file to see how it gets escaped.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants