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
with custom numfmt "[$¥-8004]" "#" "####""", the value "80145.899999999994" format to "80145.899999999994", but excel format as "¥ 8 0146"。
after the following change, the result is correct:
in numfmt.go:
supportedLanguageCodeInfo={
"8004":xxx,
xxx
}
in printNumberLiteral func:
...
if token.TType == nfp.TokenTypeHashPlaceHolder || token.TType == nfp.TokenTypeZeroPlaceHolder {
if useLiteral && usePlaceHolder {
//change here
//return nf.value
return result
}
...
The text was updated successfully, but these errors were encountered:
Thanks for your issue. As the documentation of GetCellValue says: "If the cell format can be applied to the value of a cell, the applied value will be returned, otherwise the original value will be returned", this library doesn't support apply all kinds of number format, if the number format doesn't support will be fallback to original value. Contribution are welcome.
with custom numfmt "[$¥-8004]" "#" "####""", the value "80145.899999999994" format to "80145.899999999994", but excel format as "¥ 8 0146"。
after the following change, the result is correct:
in numfmt.go:
supportedLanguageCodeInfo={
"8004":xxx,
xxx
}
in printNumberLiteral func:
...
if token.TType == nfp.TokenTypeHashPlaceHolder || token.TType == nfp.TokenTypeZeroPlaceHolder {
if useLiteral && usePlaceHolder {
//change here
//return nf.value
return result
}
...
The text was updated successfully, but these errors were encountered: