Apache OpenOffice (AOO) Bugzilla – Issue 24215
Fields From Spreadsheet Datasource Don't Update In Writer
Last modified: 2004-03-18 15:50:03 UTC
When working with a datasource in Writer, I find that if I change data in the spreadsheet, Writer never sees the changes. I've tried restarting Writer, and even shut down the Quickstarter, but writer never sees the changes. If I open the spreadsheet itself, I see the changes. I have administrator access and installed OO myself. As a side note, I had installed 680, but took it out, so I don't know if that is having any effect on this. However, I seem to remember seeing this issue before, so I don't think so. This time, I'm attaching files.
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 ***
.