Greater Flexibility in Number TVs - Githubissues

modxbot commented 13 years ago

everettg_99 created Redmine issue ID 3863

Here are some improvement suggestions for handling Number TVs

Allow for the use of a plus sign (+) as well as the negative sign (-)
Simply allow both the decimal mark and the thousands separator to appear in the field (this is the easy way out). In other words allow the following characters in any combination: 0-9,-,+,.,',',e
Permit the letter 'e' to be used to represent large numbers in scientific notation, e.g. 6.0221418E23 is equivalent to 6.0221418×10^23
Allow format to be specified on a per-field basis (similar to how date TVs work), e.g. "#,###.##". See Microsoft Excel for some good examples of a familiar format method.

modxbot commented 13 years ago

everettg_99 submitted:

Two minus signs would be valid for exceptionally small numbers that would use negative exponents, e.g.

-6.0221418E-23

modxbot commented 13 years ago

rethrash submitted:

Everett, what on earth are you trying to measure? ;)

modxbot commented 13 years ago

everettg_99 submitted:

Atomic masses of carbon isotopes. You get a lot of scientific notation with chemical compounds (seriously).

modxbot / migrate