Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Fields From Spreadsheet Datasource Don't Update In Writer | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Writer | Reporter: | marcdver <0zv8vjlc.openofficelogin.mdver> | ||||||
Component: | ui | Assignee: | h.ilter | ||||||
Status: | CLOSED DUPLICATE | QA Contact: | issues@sw <issues> | ||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | issues | ||||||
Version: | OOo 1.1 RC5 | ||||||||
Target Milestone: | --- | ||||||||
Hardware: | Other | ||||||||
OS: | Windows XP | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
marcdver
2004-01-08 16:44:17 UTC
Created attachment 12361 [details]
Mail Merge Spreadsheet
Created attachment 12362 [details]
Mail Merge Document
Database fields never update automatically. How (and why) should they? There content is set when merging data from the database beamer or when used in mail merge. If you want to have dynamic update of data from a spreadsheet you should use DDE fields. This issue is a serious one. I also have been trying to use a spreadsheet (not a database) as a datasource for a mail merge. When I change a number on the spreadsheet, I cannot get that change to show in the datasource for the text document that is the source of the mail merge. I tried everything, even removing the datasource and re-exporting it (with the same name) from the spreadsheet. I tried closing all OO documents and reopening them. I tried invoking every "update" type command that I could find in both the spreadsheet and the text document. It seems that the original data in the datasource gets cached somewhere that just won't let go of it. The one thing that works is to edit the datasource from the text document and remove the table from that datasource. Then close the text document and reopen it, then edit the datasource and put the table back in. Duplicate to i9899 *** This issue has been marked as a duplicate of 9899 *** . |