https://bugs.documentfoundation.org/show_bug.cgi?id=77951
--- Comment #9 from DF <devonfy...@gmail.com> --- I most certainly think this enhancement should be considered at least medium if not high priority. I went through undergraduate university and this was one of the first things I found to be very clunky in all spreadsheet software and having this feature would be a significant time saver and would benefit most of the research area and the students. I've had to go through tables of data I've entered and manually fix numbers. I've checked online and currently the best solution in either this or Excel is to use a formula. Another field where this would stand out is for anyone who wants to round numbers such as turning raw data into user friendly (presentable). For example in finance or statistics one would prefer to to present all their data to two sig figs for aesthetics (eg 1,342,554 becomes 1,300,000). Just to give some kind of insight on the impact, about 20% of students are in math, sciences and engineering for 16 countries. In Canada for example, there are about 1M undergraduates. So I'd think it would be safe to say at least 3% of the first-world population per year would likely find this feature to be of benefit in their spreadsheet software of choice. I should mention that significant figures also applies to non-decimal numbers which is just as important as decimals. For example 123456 with 3 sig figs would be 123000 or if someone divides 1100/3.0 the result should be shown as 370 not 367 or 366.667, but it is important not to round anything other than visually so as not to incorporate rounding errors into subsequent calculations. Another important part of significant figures is the rounding rules (see https://en.wikipedia.org/wiki/Rounding) There would have to be a few options for cases where the first non-significant figure is a 5. Normally one would round up (ex 1.25 to 2 sig figs becomes 1.3) but there are also cases where one may not want to round or and the case of 'round half to even'. -- 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
