[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from gotc...@openoffice.org Sat Mar 21 01:47:39 + 2009 --- I just started with oo 3.0. The 1st thing I needed was to move a database/label/mail merge from EXCEL/WORD to OO. I created the calc spreadsheet and rebuilt my macros used in EXCEL. I populated the spreadsheet with the EXCEL data. I registered it as a 'datasource'. I defined my label form, did the layout and successfully printed the selected data. However, when I make changes to the spreadsheet, close the spreadsheet and reopened the label document --- changes are not reflected in the datasource. I know this has been a problem since 2002 - but -- do we have a workaround or fix? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User mechtilde changed the following: What|Old value |New value Status whiteboard| |dba30a - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Wed Mar 5 10:50:32 + 2008 --- verified in cws dba30a. You need to turn on connection pooling to see a diffrent between OOH m7 and this CWS. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Tue Feb 26 20:30:29 + 2008 --- Hello hhoehle, to my mind, oj means we have to re-run the Mail Merge Wizard from the "Tools" menu. (German version: Extras -> Serienbriefassistent), which hopefully hasn't forgotten the other settings from the last time. I don't know if other ways work to refresh the writer document with the edited addresses (According to my post from 2007-01-22, see above). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Tue Feb 26 18:30:29 + 2008 --- Thank you very much oj that you took the time to fix this issue! As I am not a 100% sure that I understand right could you please explain the new behaviour in my scenario. Given a calc table as data source of an odb database and a writer document which contains fields references to the odb database (address data like name etc.) Now I change data in the calc file and save it. Then I “print” this writer document and I choose “serial letters” and print some data (OO version 2.3, german) 1. Do you call this printing using the wizard? 2. What would be required to do in minimum to get the letters with the new data out of the calc sheet. 3. With the writer document open f4 shows the actual connected db in bold in the window and provides an update and a reconnect button What would be the function of this buttons? In addition I would like to use the bug fix. Which version should I download and where do I get it? Thank you very much again! hhoehle - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from [EMAIL PROTECTED] Tue Feb 26 11:05:22 + 2008 --- Please verify. - Create spreadsheet and insert some values - Execute mail merge wizard and select the spreadsheet as data source - Change data in the spreadsheet - Execute the mail merge wizard again => You see the changes. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Fri Feb 15 06:06:08 + 2008 --- 1. Yes. I changed nothing in handling of ods sources inside the wizard. 2. I don't know the work flow but fact is when you close the wizard the ods file will be released (of course when you have any other db instance which has opened the ods file then it won't be released). 3. When the cws dba30a was integrated. It will be part of OOo 3.0. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Thu Feb 14 21:16:27 + 2008 --- Hello oj, great that you have taken the task! I didn't understand your explanation completely, e.g. "first table, last table", so would you please clarify? 1. For Mail Merge with ODS/XLS-spreadsheets, will there still be an ODB-Database file created? 2. The refreshing from the spreadsheet file is done by calling Tools -> Mail Merge Wizard again? 3. When will we be able to test it? I don't suppose it to be in 2.4. Thank you! :-) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Thu Feb 14 11:55:57 + 2008 --- I fixed the issue in that way that the document is still loaded only once. But when the last table of the connection dies the document will be closed. When after that new tables will be asked for ( like Menu->View-Refresh Tables) the document will be loaded again. Now every time you create a Mail Merge for an ods (not a datasource, this is a different story) a new connection will be created and the document will be reloaded. When you use a datasource you have to reconnect it to get the new data. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User oj changed the following: What|Old value |New value Assigned to|nn|oj Status|STARTED |NEW --- Additional comments from [EMAIL PROTECTED] Thu Feb 14 11:48:37 + 2008 --- Grabbing - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User hhoehle changed the following: What|Old value |New value CC|'andreasfilsinger,anowak,a|'andreasfilsinger,anowak,a |srail,cornouws,ds13,jcdamg|srail,cornouws,ds13,jcdamg |aard,kelvine,mandreiana,ma|aard,kelvine,mandreiana,ma |nens,martinwhitaker,maxweb|nens,martinwhitaker,maxweb |er,nodisalsi,pagalmes,phil|er,nn,nodisalsi,pagalmes,p |lg,probe1,rtrout,thing' |hillg,probe1,rtrout,thing' --- Additional comments from [EMAIL PROTECTED] Thu Feb 7 18:19:43 + 2008 --- Hi, As I have a really need for this issue to be solved I feel somewhat disappointed about the schedule shift. Can we expect to see something in 3.0 beta? I may even support you in testing. Please let me know. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User nn changed the following: What|Old value |New value Target milestone|OOo 2.4 |OOo 3.0 --- Additional comments from [EMAIL PROTECTED] Mon Jan 21 14:51:34 + 2008 --- Not finished in time for 2.4, retargeting. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Sun Oct 28 21:20:51 + 2007 --- Hi, re fs's suggestion "the connection should be disposed when it is not used anymore, and that the driver should discard the file at this point."...could this be implemented such that a new mail merge activity was itself the trigger for disposing of the connection (after which it would, of course, be refreshed)? Then you would be guaranteed the most up to date database every time you did the merge. I guess it might take a second or two longer, but for most people that would be a trivial inconvenience compared to finding after the fact that you used old data. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Tue Oct 23 13:21:54 + 2007 --- hhoehle -> fs, nn: Sorry, it took a while to continue this discussion. From my point as user the following behaviour is expected. The set up is that base uses an external db source like a CALC sheet, an excel sheet or an ODBC connection as data source to provide data for a serial letter in writer. After the changed data source file (calc, excel etc.) has been saved, the new data content should be used within base. At least after pushing the “update” button the new data should appear in the data base/table window and should be used for merging the serial letter. This behaviour should be independent of the type of the data base. In case your change proposal would lead to such a result it is more then welcome to be implemented. However no additional action (reconnect ...) should be required to make use of an updated data base content. greetings hhoehle - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User cornouws changed the following: What|Old value |New value CC|'andreasfilsinger,anowak,a|'andreasfilsinger,anowak,a |srail,ds13,jcdamgaard,kelv|srail,cornouws,ds13,jcdamg |ine,mandreiana,manens,mart|aard,kelvine,mandreiana,ma |inwhitaker,maxweber,nodisa|nens,martinwhitaker,maxweb |lsi,pagalmes,phillg,probe1|er,nodisalsi,pagalmes,phil |,rtrout,thing'|lg,probe1,rtrout,thing' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User fs changed the following: What|Old value |New value Target milestone|OOo Later |OOo 2.4 --- Additional comments from [EMAIL PROTECTED] Mon Sep 24 08:27:49 + 2007 --- fs->nn: as talked about and agreed upon: Let's try to do this for 2.4. The general idea is that the connection should be disposed when it is not used anymore, and that the driver should discard the file at this point. Nowadays, it's more reliable that connections are really closed/disposed when they're not needed anymore than at the time when this issue was submitted :-\. If this approach doesn't work, please tell me, and I'll assist in finding a better entry point (or fixing the reasons why it doesn't work). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Wed Sep 5 08:18:23 + 2007 --- Hello, Is there anybody out there who takes care of this issue or is willing to participate on this discussion? Maybe somebody can give me a hint how we get some movement into this? greetings hhoehle - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Wed Aug 8 07:54:06 + 2007 --- Hello, I would be very happy if this issue could be solved. As I am quit new here (actually because of this defect) I would like to ask if somebody can make suggestions how to overcome this situation. Maybe you nn can tell us what activity or other improvement would be helpful to get this issue a step further in direction of a solution? >From my user point of view I would expect as minimum: * update button: The actual data of the last saved calc/excel file to be displayed/used by base * rebuild button: The actual data structure and data of the last saved calc/excel file to be displayed/used by base Thank you! hhoehle - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Tue Jun 26 15:47:36 + 2007 --- *** Issue 77431 has been marked as a duplicate of this issue. *** - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User manens changed the following: What|Old value |New value CC|'andreasfilsinger,anowak,a|'andreasfilsinger,anowak,a |srail,ds13,jcdamgaard,kelv|srail,ds13,jcdamgaard,kelv |ine,mandreiana,martinwhita|ine,mandreiana,manens,mart |ker,maxweber,nodisalsi,pag|inwhitaker,maxweber,nodisa |almes,phillg,probe1,rtrout|lsi,pagalmes,phillg,probe1 |,thing' |,rtrout,thing' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User pagalmes changed the following: What|Old value |New value CC|'andreasfilsinger,anowak,a|'andreasfilsinger,anowak,a |srail,ds13,jcdamgaard,kelv|srail,ds13,jcdamgaard,kelv |ine,mandreiana,martinwhita|ine,mandreiana,martinwhita |ker,maxweber,nodisalsi,phi|ker,maxweber,nodisalsi,pag |llg,probe1,rtrout,thing' |almes,phillg,probe1,rtrout | |,thing' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Mon Mar 19 13:09:01 + 2007 --- *** Issue 75467 has been marked as a duplicate of this issue. *** - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Mon Mar 5 22:14:11 + 2007 --- Hello Andreas I have offered a bounty of £20 to get the bug fixed. If others can join me offering a bounty, maybe the bug would get fixed sooner. I will pay the money to the person who submits a patch accepted by the OO project which solves the bug. Patch to be submitted before end of June, I will pay via Paypal on receipt of an email evidencing the accepted patch. We must remember that even though this bug is annoying and very old, there are still likely bugs in OO which have a higher priority. And, IMO, it is only since V2.04 that the mail merge functionality in OO became sufficiently bug-free to be of general use. Apart from usability issues, this, as far as I am concerned is the last real bug with the OO mail merge, resulting in this bug being conspicuous. I guess this bug can't live for more than 6 months. nn; I know you don't have enough time currently to work on the bug. If the bug were unassigned/ marked as new, is it be more or less likely someone who has time will pick it up? To put it another way, if the bug is marked started, and assigned to you, might that actually stop someone else working on it? I don't have experience of the OO BTS like you do, so this question is asked with naivety and I value your opinion on this matter. Are there any major overhauls of the OO code base planned which may result in the re-coding of the mail merge functions and hence give us a different selection of bugs and perhaps solve this one? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User andreasfilsinger changed the following: What|Old value |New value CC|'anowak,asrail,ds13,jcdamg|'andreasfilsinger,anowak,a |aard,kelvine,mandreiana,ma|srail,ds13,jcdamgaard,kelv |rtinwhitaker,maxweber,nodi|ine,mandreiana,martinwhita |salsi,phillg,probe1,rtrout|ker,maxweber,nodisalsi,phi |,thing' |llg,probe1,rtrout,thing' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Mon Mar 5 15:22:00 + 2007 --- i can confirm the bug (OO 2.1.0), please fix it, before working on other features, or be fair and disable this feature until it get fixed. I burned a day checking out whats wrong and finding out that its known since 2002, yes, hey, my dougther was born in 2002 too, you dont really want to know whats she's able to tell ya about live - man. Anybody out there able and willing to fix it DO IT I tested this issue with 3 different machines: # the "refresh symbol" in the F4 Window NEVER works. Windows-XP, JRE 1.5.0_11_b03 -> works fine if you disconnect DataBase and reconnect by "browsing" to sheet1 again. Windows-XP, JRE 1.?? (older one)-> works only AFTER you log-out / log-in (so you force all apps go down, even this one wich locks the database File) Windows-Vista, JRE 1.6.0_b105 -> you just must restart Writer, then the data is refreshed. Good luck, and thanks for your unbelieveable work Andreas Filsinger - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Fri Mar 2 21:13:05 + 2007 --- Oops, I'm sorry nn, I assumed 'nn' was erroneous data in the "Assigned to:" field. I didn't imagine nn being an actual username. I now understand the Status: field is correct, and the bug has been assigned to a real person. No offence was meant, and apologise if any was taken. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Fri Mar 2 18:11:46 + 2007 --- "Started" is the state after accepting an issue. That can be a bit confusing. I wouldn't call myself non-existent, but I'm not currently working on this. If someone else wants to take a look at it, go ahead. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Fri Mar 2 17:53:37 + 2007 --- I notice the bug was filed more than 4 years ago. I also notice the bug is assigned to "nn (nn)" which is probably not a real person. I also notice the bug is not assigned to any target milestone The bug is flagged as started, which means someone should be working on it. But given it is assigned to a non-existent person, I suspect nobody is working on it. Could someone change the status to Unassigned, or assign it to someone, and set a genuine target milestone? I am happy to offer a bounty of GBP20 (appx 38 USD) good until end of June 2007 to help encourage resolution of this bug. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Fri Mar 2 17:19:51 + 2007 --- I am currently experiencing this problem with 2.1. Create openoffice spreadsheet containing mailmerge data Set up a data source of a given name Mailmerge works OK. Change data in spreadsheet Actual result: Changes not reflected in mailmerge data source or in mailmerge itself. Expected result: Changes in spreadsheet in underlying data source should be reflected in mailmerge. Attempts to resolve: Hit F4 to see data sources. Hit refresh button. Result: No change Hit F4, hit rebuild. Result: No change Close and re-open oowriter mailmerge document. Result: Mailmerge data still does not reflect underlying data source. Close all openoffice applications, re-open mailmerge document. Normally, underlying data will be reflected in mailmerge document after restarting openoffice, but not always. Presumably some other application is holding the libraries open. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=9899
--- Additional comments from [EMAIL PROTECTED] Mon Jan 22 12:30:30 -0800
2007 ---
Hello,
OO Writer is great, though I would really be thankful for fixing this bug.
What does the user expect?
1. When you use the Mail Merge wizards, there's no hint that OO creates a
database file as middle layer between spreadsheet and document. So the average
user won't even know that there's a different thing to update.
2. If you did understand at least that, it's not obvious that the name of
a) the spreadsheet .ODS (or .xls)
b) the database .ODB
c) logical data sources name in OO
can be similar or different.
Example: In step 3 of the Mail Merge wizard, it's called "Adress list". But
instead of the spreadsheet file the user has chosen directly ("Add...") here
before, the shown "Adress list" is the name of the automatically created "data
source" (c). This is neither recognizable by the GUI nor by pressing the
"Help"-Button in the "Select Adress list" window.
3. The windows to enter, edit or refresh data a little widespread:
- New: "Adress data source" under File -> Wizards
- New: Tools -> "Mail Merge Wizard" -> "Adress list" (Why not under
File->Wizards, too? Why here a different name than "Data Source"?)
- Edit/View: View -> "Data Sources" (F4), here you could disconnect to refresh
4. In the Print Layout View of OO Writer, if you open the serial letters's
starting document, the grey data fields for the Mail Merge show the values of
the first adress list dataset (e.g. "Bill Gates, Redmond"). This might be quite
disturbing when it's not updated, even as user may expect when pressing Tools
--> Update.
Contrary to that, some word processors don't show the values in the basic
document but the name of the data fields ("Firstname, lastname, City"). So they
avoid that "Why the h... does it show the old adress??"
IMHO, the current solution does work, but unfortunately it is somewhat
inconvenient and confusing - my dad wouldn't get refreshing data to work
(besides shutting down and restarting OO every time). ;-)
Do you think the following ideas might be as well possible and sensible?
A) Add a automatic or explicit "refresh" option directly to the Mail Merge
Wizard which loads the current spreadsheet data.
B) Add the Mail Merge Wizard to the File -> Wizards menu.
C) Get that "Refresh" button in the datasource view (F4) to work for ODS.
D) Access spreadsheet files directly *without* creating a odb-database.
So, enough text written.
Bye, thanks a lot!
Dirk
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User ds13 changed the following: What|Old value |New value CC|'anowak,asrail,jcdamgaard,|'anowak,asrail,ds13,jcdamg |kelvine,mandreiana,martinw|aard,kelvine,mandreiana,ma |hitaker,maxweber,nodisalsi|rtinwhitaker,maxweber,nodi |,phillg,probe1,rtrout,thin|salsi,phillg,probe1,rtrout |g'|,thing' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 User asrail changed the following: What|Old value |New value CC|'anowak,jcdamgaard,kelvine|'anowak,asrail,jcdamgaard, |,mandreiana,martinwhitaker|kelvine,mandreiana,martinw |,maxweber,nodisalsi,phillg|hitaker,maxweber,nodisalsi |,probe1,rtrout,thing' |,phillg,probe1,rtrout,thin | |g' Keywords| |ms_interoperability, oooqa OS/Version|Windows 2000 |All Platform|PC|All - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Fri Dec 15 02:51:38 -0800 2006 --- I can confirm what fchauvat states: Simple an intuitive operation is a key issue in migration processes in our place too, and this issue is one of the top blockers. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Thu Dec 14 09:27:15 -0800 2006 --- Can I suggest a P2 priority because it's really annoying for final users. We're replacing all our Microsoft Office by OpenOffice ... and many users used Excel + Word to make simple mailmerge operation... It's difficult to replace Excel sheets for adresses data by OpenOffice because of this problem of update in data source when you update the spreadsheet. We can replace Excel sheet by OOoBase ... but it's not so easier for final users. Thanks ! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 9899] Mail merge from Calc or Exc el - embedded fields not updating on refresh
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9899 --- Additional comments from [EMAIL PROTECTED] Wed Dec 6 13:47:35 -0800 2006 --- Hello, My experience about this really annoying bug ( no data refresh mailmerge with ods document as datasource). If you modify/save the spreadsheet datasource and disconnect/reconnect the datasource in the beamer in Writer ... data are refreshed in the beamer and for the mailing. It's an acceptable behaviour (even if refeshing data with the refresh button will be better than connect/disconnect). BUT if you use the mailmerge wizard ( and even if you cancel on step 6 ou 7) the ONLY way to refresh data after a new spreadsheet data change is to restart OpenOffice ( without forgetting to also stop the quick launch in systray ). (disconnect/reconnect datasource, changing datasource, changing name of datasource nothing else ok, the only way is to kill all soffice process) It's seems like mailmerge wizard/process will stuck/lock cached spreadsheet data in memory... tested on Win XP - OOo 2.0.4 fr.. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
