To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58882 Issue #:|58882 Summary:|Use the spreadsheet data in right way, not just |(incorrectly) guess the type Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P2 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|tuharsky
------- Additional comments from [EMAIL PROTECTED] Mon Dec 5 03:34:36 -0800 2005 ------- Attached spreadsheet has 2 colums: Street and No. If used as datasource, the street numbers with letters in them aren't displayed. If MailMerge is done, the affected data are not merged (thus they are lost in output or print). The behaviour probably cannot be affected by regular actions of ordinary user, if it can be affected either. I've formatted all cells as Text, and then the Column Format was set to Text too in data view. (F4 key in word processor) The database layer should 1. Either verify the real data type from each cell's format settings 2. Or allow user to set them manually 3. Both: First step -try to guess the type by scanning the cells for each column. Second step -allow user to change it, with DB Source View open so that he can see, what he get Notes 1. Don't know if it affects all databases or just Calc spreadsheets source 2. May be related to http://www.openoffice.org/issues/show_bug.cgi?id=24671 http://www.openoffice.org/issues/show_bug.cgi?id=4122 http://www.openoffice.org/issues/show_bug.cgi?id=31472 http://www.openoffice.org/issues/show_bug.cgi?id=34992 3. Although for me it seems like bug and for sure it leads to unexpected loss of data (P2), the developer 'clu' insists that this is an enhancement. So I'm reporting this as enhancement. --------------------------------------------------------------------- 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]
