You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
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.
The text was updated successfully, but these errors were encountered: