To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59516 Issue #:|59516 Summary:|IT: Cannot insert decimal, real or float values |properly Component:|Database access Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|pescetti
------- Additional comments from [EMAIL PROTECTED] Sun Dec 18 14:19:07 -0800 2005 ------- Verified in OOo 2.0.1-RC5-IT, may affect other locales. 1. Open Base and create a new database. 2. Create a table with three fields: "decimal" of type decimal, "float" of type float, "real" of type real. Add an auto-incrementing primary key when prompted. 3. Double click on the table to insert data. 4. Select a (comma-separated, as per locale) numeric format with two decimals right-clicking on each column heading. 5. Type "2.22" in all columns and move to the next record. 6. Data are changed into "0,0000", "2.22", "0,1" respectively. 7. Type "2,22" (decimal separator is a comma in IT) in all columns and move to the next record. 8. Data are changed into "2,0000", "2", "2,22" respectively. Something is not working because, at the very least, REAL and FLOAT should be identical as per HSQLDB documentation: http://hsqldb.sourceforge.net/doc/guide/ch02.html#N10426 [Reported by Filippo Cerulo during Italian QA tests] --------------------------------------------------------------------- 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]
