To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76982 Issue #|76982 Summary|Cannot refresh spreadsheet datatsource in writer if da |te or number field has been used Component|Database access Version|OOo 2.2 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|andreschnabel
------- Additional comments from [EMAIL PROTECTED] Sat May 5 16:45:14 +0000 2007 ------- If a spreadsheet datasource is used in Writer (e.g. mailmerge) this datasource cannot be refreshed, if a date or number field is used in writer (and filled with data). To reproduce: - create a simple spreadsheet as datasource with at least a date or number column (you may use the attached example) - create a database document that linkes to the spreasheet (you may use the attached example, change the link to the spreadsheet) - register the db document - open a writer new writer document (you may use the attached example) - open datasource browser and open the spreadsheet table - drag a date or numeric field to the writer document - select any data entry in the spreatsheet table and use the "Data to Fields" button - open the spreadsheet - change any value in the spreadsheet - save the spreadsheet - in Writer - Datasource window, close the connection to the spreadsheet datasource - open the table view again -> expected: changed data should be displayed -> got: changed data are not displayed unless OOo is closed and reopened this does not happen, if only text columns are used. This issue is likely to occure in real live mail merge scenarios (e.g. if you try to send a mail merge with an appointment date). --------------------------------------------------------------------- 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]