ssf negative number using accounting format has double minus sign #2956

Open
opened 2023-05-28 15:14:49 +00:00 by eyal1990 · 2 comments

This issue was reported back in 2015 and marked as fixed in 2017.
However, in the latest version (0.11.2) it still happens:

https://github.com/SheetJS/ssf/issues/17

I don't believe there's a need to add more context, as this is the exact same issue.

This issue was reported back in 2015 and marked as fixed in 2017. However, in the latest version (0.11.2) it still happens: https://github.com/SheetJS/ssf/issues/17 I don't believe there's a need to add more context, as this is the exact same issue.
Owner

The old issue was for format #.##;-"£"#. and value -3.1415926535. As shown in the screenshot, it appears to work as expected. Can you share a sample format / value / expected text?

The old issue was for format `#.##;-"£"#.` and value `-3.1415926535`. As shown in the screenshot, it appears to work as expected. Can you share a sample format / value / expected text?
Author

For this format:
-* #,##0.00_-

And any negetive number it will produce double minus sign

For this format: -* #,##0.00_- And any negetive number it will produce double minus sign
Sign in to join this conversation.
No Milestone
No Assignees
2 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#2956
No description provided.