https://bugs.freedesktop.org/show_bug.cgi?id=77951
--- Comment #6 from DF <devonfy...@gmail.com> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs