Negative numbers get the '-' sign inserted twice on formats containing extra text #2588

Open
opened 2020-10-01 22:59:35 +00:00 by snoopyjc · 0 comments
snoopyjc commented 2020-10-01 22:59:35 +00:00 (Migrated from github.com)

Here is another one from valid.tsv (who thinks of these??):

console.log(SSF.format('\c\c\c?????0"aaaa"0"bbbb"000000.00%', -12.3456789))
-ccc    0aaaa0bbbb0-1234.57%

The right answer is:

-ccc     0aaaa0bbbb001234.57%
Here is another one from valid.tsv (who thinks of these??): console.log(SSF.format('\c\c\c?????0"aaaa"0"bbbb"000000.00%', -12.3456789)) -ccc 0aaaa0bbbb0-1234.57% The right answer is: -ccc 0aaaa0bbbb001234.57%
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#2588
No description provided.