Issue 54637 - Data Source Refresh in Mail Merge
Summary: Data Source Refresh in Mail Merge
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P4 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-09-15 09:03 UTC by amit73
Modified: 2017-05-20 11:26 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description amit73 2005-09-15 09:03:33 UTC 
We have connected a datasource (created in Calc / Excel Spreadsheet) to a mail 
merge document.

Later on we added some more records / rows to that spreadsheet and wanted to 
mail merge for the new records. We found that the datasource was not 
refreshed / rebuild even when we clicked on the refresh / rebuild icon.
Comment 1 h.ilter 2005-09-19 15:13:51 UTC 
HI->OS: Isn't there already an issue about that?
Comment 2 Oliver Specht 2006-11-22 14:21:17 UTC 
I don't know if there's a duplicate.
Comment 3 ds13 2007-01-19 00:01:58 UTC 
Hello,

this may be a duplicate to No. 9899.
I know that effect, too.

Workaround, but no guarantee: 
a) Close OpenOffice (all windows, parts, documents - including Quickstart)
 or
b) Open "Data Sources" with F4 or menu "View". Right-click the datasource in the
left list and choose "Disconnect". Afterwards double-click again and go to tables.

The problem is that OO automatically creates an .odb-database which imports the
content of the spreadsheet, instead of reading the spreadsheet directly while
merging mails.
Comment 4 cno 2009-07-10 10:24:51 UTC 
should be fixed in the mean time, IMO ...
considered the connection pooling for the type of database is disabled
(Tools|Options|OpenOffice.org Base > Connections)

@amit73 is this correct for you?
Comment 5 Marcus 2017-05-20 11:24:45 UTC 
Reset assigne to the default "issues@openoffice.apache.org".
Comment 6 Marcus 2017-05-20 11:26:12 UTC 
Reset assigne to the default "issues@openoffice.apache.org".