To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48026 Issue #:|48026 Summary:|Improve Scientific Number Format Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P4 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|sulimma
------- Additional comments from [EMAIL PROTECTED] Sat Apr 23 12:50:37 -0700 2005 ------- The scientific number format representation lacks functionality. Currently there is always a fixed number of digits displayed in front of the decimal point. This means that 34,5 and 345 show up either as 3,45e1 and 3,45e2 or as 34,5e0 and 34,5e1 respectively. It should be possible to limit the exponents to values devisible by three as it is comon in engineering. This means there should be a number format were the values show up as 34,5e0 and 345,0e0 while 3450 and 34500 show up as 3,4e3 and 34,5e3. It also would be really nice to be able to display ISO/SI/ANSI suffixes for the exponents. E.g. k for e3, M for e6, m for e-3 and so on. The last two examples would show as 3,40k and 34,5k (or optionally as 3k4 and 34k5) --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
