Exponential format with no decimal/digits shouldn't display any #2595

Open
opened 2020-10-13 01:22:13 +00:00 by snoopyjc · 1 comment
snoopyjc commented 2020-10-13 01:22:13 +00:00 (Migrated from github.com)

An exponential format with no decimal/digits such as #E-0 shouldn't display the decimal point and digit after it, e.g. 3.14159 displays incorrectly as 3.1E0 instead of 3E0.

An exponential format with no decimal/digits such as `#E-0` shouldn't display the decimal point and digit after it, e.g. `3.14159` displays incorrectly as `3.1E0` instead of `3E0`.
snoopyjc commented 2020-10-13 04:00:23 +00:00 (Migrated from github.com)

A similar issue occurs in Engineering notation (for both float and int inputs), where 10 with format 000E-0 should give 010E0 not 1.000E1.

A similar issue occurs in Engineering notation (for both float and int inputs), where `10` with format `000E-0` should give `010E0` not `1.000E1`.
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#2595
No description provided.