Issue 16798 - Updates to spreadsheet data source fields are not recognised until OOo restarts
Summary: Updates to spreadsheet data source fields are not recognised until OOo restarts
Status: CLOSED DUPLICATE of issue 9899
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: Frank Schönheit
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-14 04:37 UTC by rtrout
Modified: 2006-05-31 14:29 UTC (History)
1 user (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 rtrout 2003-07-14 04:37:26 UTC 
The bug: the data in a data source is modified, but the modification doesn't
appear in the data sources window and doesn't appear in a mail merge, until
after OOo is restarted. Only tested on Spreadsheet data source types.

Desired result: data source should read latest data on a mail merge, and allow a
manual update, eg. 'Refresh Data Source' in the Data Sources window.

How to reproduce: Create a spreadsheet with 3 fields a,b,c and 2 data rows:
john, smith, 12345678 & mary, jones, 87654321. Create a data source using the
above spreadsheet. Create a document that uses the data source as a mail merge
document. Produce sample mail merge output. Now modify the original spreadsheet,
eg change mary, jones to mary, citizen. Produce sample mail merge output again
and the data hasn't changed from jones to citizen. Also, using the Data Sources
window, drilling into the table holding the database fields, shows the original
data not the update. Close all OpenOffice windows and exit QuickStarter and
restart OOo. Load the sample document again and produce sample mail merge output
- data is now updated.
Comment 1 rtrout 2003-07-14 04:39:38 UTC 
Also see bug 15638 for an early report and confirmation of this same bug.
Comment 2 Frank Schönheit 2003-07-14 08:55:48 UTC 
Richard, thanks for reporting this.
The bug is already known with as issue 9899, so I close this one here
as duplicate. Thanks.

*** This issue has been marked as a duplicate of 9899 ***
Comment 3 Frank Schönheit 2003-07-14 08:56:32 UTC 
closing
Comment 4 hans_werner67 2004-02-02 12:55:32 UTC 
change subcomponent to 'none'