To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99980 Issue #|99980 Summary|Lost Format of Integer (and Other Numeric Fields) Component|Database access Version|OOO310m4 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|rk601
------- Additional comments from rk...@openoffice.org Fri Mar 6 16:14:55 +0000 2009 ------- OpenOffice Base 3.01 in Windows XP does not save its formatting when applied to an Integer field (or other numeric field). Follow these steps to reproduce the error: 1. Launch OpenOffice 3.01, Create a database using OpenOffice HSQL database engine. 2. Create a table that includes at least one numeric field like Integer. For this example the Integer field will be called "Primary Key" and it will auto-increment and be the primary key. 3. Click on the Field Type (Integer) and change the "Format Example" to "ABC"000 4. Click the OK button, click the save button, and save the database. 5. Create a Form that allows for data to be entered into the newly created table and allow the Form to edit database data. Be sure the Form allows for the display of the auto-incrementing Integer field called "Primary Key." 6. Save the Form. 7. Use the Form to enter data. Notice that the "Primary Key" field within the form does not maintain its format. It should display ABC000 but it displays 0. 8. You may need to quit OpenOffice a few times to see that the "Primary Key" field within the form does not maintain its format. Also note that the the "Primary Key" field within the Table defaults to its original format. --------------------------------------------------------------------- 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...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org