To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46511 Issue #:|46511 Summary:|Calc/Spreadsheet general format not displaying as |Qpro, Excel, Lotus Component:|Spreadsheet Version:|OOo 1.1.3 Platform:|Other URL:|http://www.oooforum.org/forum/viewtopic.phtml?t=15887 OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|hawstom
------- Additional comments from [EMAIL PROTECTED] Fri Apr 1 09:10:43 -0800 2005 ------- Summary The Spreadsheet Format -> Cells -> Number -> Format "General" does not display numbers in the customary format historically established by Lotus 1-2-3, Quattro Pro, and Excel. Instead, it shows them in "2 decimals max" format: 123 shows as 123 123.4 shows as 123.1 123.45 shows as 123.45 123.456 shows as 123.46 123.456789 shows as 123.46 Workaround The workaround for this bug is to enter a user-defined format as 0.#############. However, this workaround has also a flaw, in that excessive # signs cause a cell width overflow: 1 shows as 1 123.456 shows as 123.456 (assuming cell is wide enough) 123.456789 shows as ### (assuming cell is too narrow for the full number). But in historic spreadsheets, in a narrow cell, 123.456789 shows as 123.4567 (whatever the cell can display. History of discussion In the forum topic linked and given again here http://www.oooforum.org/forum/viewtopic.phtml?t=15887 Steps Simply open a new Spreadsheet document and type 123.456789 into the first cell. Calc will display 123.46. Then open any other major spreadsheet and do the same thing for comparison. --------------------------------------------------------------------- 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]
