[Libreoffice-bugs] [Bug 77834] FORMATTING: Option to keep numeric precision (significant figures) as entered

[bugzilla-daemon at bugs.documentfoundation.org]

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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #11 from b. <newbie-02 at gmx.de> ---
supporting the request, 

'7,5' (decimal) entered is not! the same as '7,5000' (decimal) entered! 

7,5 is a placeholder for the range from 7,450000000000000 to 7,549999999999999
if we stay with 16 digit precision, 

7,5000 is a placeholder for the range 7,499950000000000 to 7,500049999999999, 

it carries some precision information in it which is thrown away when
truncating the trailing zeros, 

additional: user sometimes want a formatted display of columns, without first
having to manipulate the cell format, 

and additional: from such a display respecting the input values you can spot
some typing errors which is more difficult with display / values messed up by
truncating zeroes and / or overriding cell format, 

shouldn't be too difficult to implement, an option to automatically change cell
format acc. input, and store trailing zeroes in content.xml ...

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201101/7d6343d3/attachment-0001.htm>