Bug 77951 - FORMATTING: Enhancement Request - Specify number of significant figures, not just decimal places.
Summary: FORMATTING: Enhancement Request - Specify number of significant figures, not ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.1.3.2 release
Hardware: All All
: low enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: NeedsDevEval
Keywords:
Depends on:
Blocks:
 
Reported: 2014-04-25 23:33 UTC by DF
Modified: 2014-07-16 20:51 UTC (History)
3 users (show)

See Also:
i915 platform:
i915 features:


Attachments

Description DF 2014-04-25 23:33:20 UTC
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)

This enhancement would be useful for scientific data where significant figures are important and need to be tracked.

related enhancement: 77834
Comment 1 DF 2014-04-25 23:40:11 UTC
related enhancement: bug# 77834
Comment 2 m.a.riosv 2014-04-26 21:07:05 UTC
Hi DF, maybe the option in:
Menu/Tools/Options/LibreOffice calc/Calculate/General Calculations - Precision as shown, is not what you want, but can help a bit.
Comment 3 Jean-Baptiste Faure 2014-06-22 20:29:08 UTC
Hi DF,

Did you try the scientific format for numbers ? For me it does what you want.

Set status to NEEDINFO. Please set it back to UNCONFIRMED once you provided the requested informations. Thank you for your understanding.

Best regards. JBF
Comment 4 DF 2014-06-23 18:26:19 UTC
Jean-Baptiste Faure, the scientific format is scientific notation and it so happens the nature of it allows it work as I like however is a different formatting and not particularily asthetically pleasing or practical for modest numbers ex 123 vs 1.23E+2. I would like to keep precision while also keeping the standard formatting.

m.a.riosv, thanks but the 'precision as shown' appears to be for calculations, not formatting. It performs the calculations based on the precision shown and not the exact value and thus would be prone to rounding errors for multiple consecutive calculations. Im merely looking for a formatting option which properly displays a desired number of significant figures (not decimal places) and carries the formatting forward in calculations instead of having to do it manually.
Comment 5 Jean-Baptiste Faure 2014-06-28 18:22:39 UTC
I think it is a false good idea because in some case there is no valid display. For example with data like 120, 34.567 and 0.000890, if you want 3 significant digit you will get 120, 34.5 and 0.00 which does not render the data correctly.

I agree that the scientific formatting suffers of aesthetic drawbacks but it is always correct.

So I suggest to close this enhancement request as WontFix.

Best regards. JBF
Comment 6 DF 2014-07-01 18:03:42 UTC
For the last numeric example, 0.000890 is already 3 significant figures, and yes 0.00 is meaningless. From left to right, you start counting your figures from the first non-zero. Leading zeros don't count.

Significant figures are an integral part in taking measurements hence why it is drilled into undergraduate science students (and likely engineers) and is ubiquitous in research. This is not an enhancement which I thought up overnight, I've been finding the lack of this feature a nuisance for years and found it to be void of all spreadsheet software I've tried sofar (and I've looked). I think it would make a great addition for productivity. I've consulted others (who use Excel) and agreed this would be a useful feature.

A quick search shows me this is a commonplace, and there is no solution other than workarounds such as using scientific notation, or using a formula.
http://spreadsheetpage.com/index.php/tip/rounding_to_n_significant_digits/
http://www.eng-tips.com/viewthread.cfm?qid=231129
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=25658
http://www.faculty.umassd.edu/michele.mandrioli/172cbook/fCHM1.B.3.html
I've looked extensively through feature requests too, and found none.

As for implementing it, it would likely be an option between displaying specified number of decimal places or significant figures.
Comment 7 Joel Madero 2014-07-16 20:51:29 UTC
Another fine request.

New
Enhancement
Low - for most users they'll not see this as a hurdle.

Might be relatively easy to add, requesting input.


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.