https://bugs.documentfoundation.org/show_bug.cgi?id=164357

--- Comment #5 from MARINA-SODA <[email protected]> ---
I would like to emphasize that large numeric values with 12 or more digits are
common in real-world contexts, and should not be automatically converted to
scientific notation.

For example>>
Apple Inc.'s market capitalization exceeds $3,000,000,000,000:13 digits
Saudi Aramco's annual revenue has surpassed $600,000,000,000:12 digits
ISBN Code:12 digits
Corporate number 13 digits
Thailand's Tabien Baan ID numbers:13 digits
ebay US itemID:12 digits

These are all valid numbers that must be preserved exactly as entered.
User-entered values should not be altered or reinterpreted by the application.
Automatically converting them into scientific notation can lead to loss of
precision, misinterpretation, and irreversible data corruption.

I would prefer to see the automatic conversion into scientific notation removed
entirely, rather than offered as an optional behavior. Most users do not expect
or benefit from this transformation.

Version: 25.2.4.1 (x86) / LibreOffice Community
Build ID: 09303ce8b49f86f106fccd32b1324662053027cc
CPU threads: 20; OS: Windows 11 X86_64 (10.0 build 22631); UI render:
Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to