The exponent sign goes right before the exponent digits, after any literal that follows the E; ? pads exponent digits with spaces; % and commas never scale a scientific section; zero shows 0 in every integer placeholder. Checked against the 248 TEXT() rows of Apache POI's NumberFormatApproxTests.xlsx, copied as data into a test. |
||
|---|---|---|
| .. | ||
| poi_number_format_approx.rs | ||