To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99118 Issue #|99118 Summary|automatic type recognition doesn't work when pasting f |rom Calc Component|Database access Version|OOo 3.0.1 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|SRB Assigned to|oj Reported by|fs
------- Additional comments from [email protected] Wed Feb 11 12:55:40 +0000 2009 ------- - open the attached spreadsheet document - mark the range A1:B6 - Edit / Copy - open a database document of your choice - select "Tables" on the left hand side - Edit / Paste => the "Copy table" wizard opens - on the first page, press "Next" - on the second page, move all fields to the right hand side list box, and press "Next" - on the third page, press the "Auto" button This is expected to automatically determine the fields types for all columns. However, both the "Date" and the "Value" column still have the "Text [ VARCHAR ]" type. Given that in the source document, "Date" is explicitly formatted as date, and also contains only date values, where "Value" is formatted as Number, and contains only numbers, I would say this is not the expected result. --------------------------------------------------------------------- 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]
