Issue 11775

Summary: Updating of data in spreadsheet not available in open mail merge document
Product: Calc Reporter: kelvine <kelvineld>
Component: uiAssignee: oc
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: 644   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description kelvine 2003-02-24 09:13:15 UTC 
The updated data in a spreadsheet is not available for use in a Writer mail 
merge.

This is repeatable.

Set up a spreadsheet as a data source.
Enter the data into the spreadsheet, save but keep the spreadsheet open.

Now open a new writer document.
Press F4 to open data source.  Select the Excel table and create a main 
document for a mail merge.

Note the contents of the data source window.
Now switch back over to the spreadsheet, update the contents and save.

Now switch back to the document.
Notice how the data source information has not been updated.
Pressing refresh does nothing.

It may just be me but I can't find a way to get the updated data.

Given this is the prime example of how to set up a mail merge this is not 
working the way it should.

Kelvin
K
Using a spreadsheet as a data source for a mail merge it is not possible to 
update the spreadsheet and have
Comment 1 waiterevo 2003-06-14 06:04:26 UTC 
I can confirm that this problem still exists in OO1.1beta2. The only 
way to get the data refresh is to close everything (including the 
Quickstarter) and restart OO.
Comment 2 frank 2003-08-26 13:53:46 UTC 
Hi,

this is a double to Issue 9899.

Please try to workaround this Issue as mentioned in 9899 by disabeling
connection polling. For further Information have a look there.

Frank

*** This issue has been marked as a duplicate of 9899 ***
Comment 3 frank 2003-08-26 13:54:12 UTC 
closed double
Comment 4 kelvine 2003-08-27 00:13:30 UTC 
Hi,

I thought I would provide feedback that changing the connection 
pooling does not work.

I have just tested this under OO1.1RC3

Leaving closed though as issue is a duplicate.

Thanks

Kelvin