To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70451 Issue #|70451 Summary|Fields missing when connecting a Database to a Spreads |heet Component|Database access Version|OOo 2.0.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|eferrari
------- Additional comments from [EMAIL PROTECTED] Sun Oct 15 07:46:21 -0700 2006 ------- When creating a new Database and connecting it to an existing OpenDocument Spreadsheet, some fields will not appear in the Database. Reporducable %100 of the time. Steps to reproduce: 1) Create a new Spreadsheet. and enter 5 or 6 numbers in the first column (any numbers will do) 2) in the same column enter a value with a alphabetic character. For example: C12345 3) Save the document 4) Create a new Database document from the existing .ods document: 4.1) Select File -> New -> Database 4.2) Select "Connect to an existing Database" and choose "Spreadsheet" in the drop down. Then click Next. 4.3) Browse and select the spreadsheet document created above. Then click Next. 4.4) Click Finish and save the New database file 5) View the new data - select "Tables" and open "Sheet1" 6) The row cooresponding to where C12345 was entered has an empty value. Expected behavior: The value should be part of the Database Note: the value will not appear in the new database no matter what you do. Even if you formatted the spreadsheet column as Text, the cell with alphabetic characters will be empty still. I have tried many different manipulations of the spreadsheet formating to attempt to make the value appear in the new database, but have not found a successful work around --------------------------------------------------------------------- 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]