sheetjs icon indicating copy to clipboard operation
sheetjs copied to clipboard

Format negative value wrong

Open 2453929471 opened this issue 5 years ago • 0 comments
trafficstars

If I use [<=-1000000]("$"#,##0.0,,"M") to format -1000000, then the result is image If I use [<=-1000000]("$"#,##0.0,,"M"); to format -1000000, then the result is image 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?

2453929471 avatar Jul 30 '20 03:07 2453929471