sheetjs
sheetjs copied to clipboard
Format negative value wrong
trafficstars
If I use [<=-1000000]("$"#,##0.0,,"M") to format -1000000, then the result is
If I use [<=-1000000]("$"#,##0.0,,"M"); to format -1000000, then the result is
Actually they all use [<=-1000000]("$"#,##0.0,,"M") to do format, the only difference is that the second case, we have 2 rules.(separate by ;)
I think we have two problems to solve here:
- both format results are wrong
- they two shouldn't have difference results
I check the code, the function eval_fmt(fmt, v, opts, flen) accept flen as a parameter. Does flen matters in formating?