https://bugs.freedesktop.org/show_bug.cgi?id=77834
Priority: medium
Bug ID: 77834
Assignee: [email protected]
Summary: FORMATTING: Enhancement Request - Option to keep
numeric precision, significant figures.
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
For entering numeric data with decimal places, should have an option to keep
set the number of decimal places as per the precision input by the user; not
automatically remove any trailing zeros.
For example if one enters 0.10, Libre office will truncate to 0.1 and the user
has to manually change the number of decimal places. It would be useful if
Libre office could keep the number of decimal places based on the number of
trailing zeros entered.
Another related enhancement would be to have the option to display a specified
number of significant figures instead of number of decimal places. And carry it
forward in calculations. For example one may input a list of data (ex 120,
34.567, 0.890) and want to display all of them with the same number of
significant figures (say 3). This would require changing the number of decimal
places for each cell which is impractical for large datasets. This could be
extended to calculations where adding or multiplying figures would output a
value with the correct number of significant figures (ex 0.10 * 10. = 1.0)
These enhancements would be incredibly useful for scientific data where
significant figures are important and need to be tracked.
Operating System: All
Version: 4.1.3.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
