To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107681 Issue #|107681 Summary|Calc: entering large numbers & stopping scientific/ext |ended notation Component|Spreadsheet Version|OOO300m9 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|nicklevinson
------- Additional comments from nicklevin...@openoffice.org Tue Dec 15 07:01:27 +0000 2009 ------- Large numbers should be enterable without approximation to extended or scientific notation. I understand the problem that for Calc to perform the math users expect you rely on the platform's hardware to save on major programming work and that the hardware is usually designed to an IEEE standard limiting numbers to about 15 decimal places. I see this also affects large positive integers even without a decimal part. I found it with 20-digit numbers. But sometimes we just want very little arithmetic because we're willing to do our own work, for which we do want to enter the numbers and have them stay the way we enter them. I found a workaround: type a letter and follow it, in the same cell, with the very large number I want. Of course, adding them up then gets even more complicated, requiring another workaround. The approach that might be best is to allow us to turn extended notation off when it starts approximating in exchange for accepting less sophistication with calculations available. I use OOo 3.0.0 OOO300m9 (Build 9358). I don't plan to upgrade now since this one works. I looked in the help index but it had nothing on scientific notation or extended notation. Thank you. -- Nick --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
