Will not import value if numeric format = "Rs."#,###.00 #449

New Issue

2016-07-31T14:18:40Z

dougschiller commented

2016-07-31 14:18:40 +00:00

(Migrated from github.com)

For some reason, if number formatted "Rs."#,###.00, the numeric value will not be properly be converted. See attached. -Rs.51,968,287.00 imports as "Rs.00" .. it should be 51,968,287.00

testrs.xlsx

For some reason, if number formatted "Rs."#,###.00, the numeric value will not be properly be converted. See attached. -Rs.51,968,287.00 imports as "Rs.00" .. it should be 51,968,287.00 [testrs.xlsx](https://github.com/SheetJS/js-xlsx/files/392443/testrs.xlsx)

SheetJSDev commented

2017-04-30 16:11:28 +00:00

(Migrated from github.com)

@dougschiller The parser was tripped up by the presence of the . in the text. That was resolved in SSF 0.9.1 and will be pushed here as XLSX version 0.9.13.

@dougschiller The parser was tripped up by the presence of the `.` in the text. That was resolved in SSF 0.9.1 and will be pushed here as XLSX version 0.9.13.

Sign in to join this conversation.