Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - DDE link between two spreadsheets: updated values not saved
DDE link between two spreadsheets: updated values not saved
 
   NeoOffice Forum Index -> NeoOffice Beta Releases
View previous topic :: View next topic  
Author Message
timrichardson
Pure-blooded Human


Joined: Oct 07, 2007
Posts: 39

PostPosted: Fri Apr 15, 2011 2:51 pm    Post subject: DDE link between two spreadsheets: updated values not saved

Rather than a minimal test case, I will attach two real spreadsheets.
The no._4_neis_spreadsheets... .ods has a tab called Cash Flow Y1.
On this tab, row 19 uses the DDE formula to dynamically link to a second spreadsheet, also attached (no 2 marketing action plan)
The values in the no._4_ spreadsheet are old; they do not reflect the current values in the source.

Bug:
1) open the no.4 spreadsheet, and choose to update values from the linked source.
2) the document is marked as "dirty".
3) save the document.
4) open it again. Choose NOT to update linked values. Observe that the linked values have reverted to the old values, despite the save in step 3.
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Fri Apr 15, 2011 6:00 pm    Post subject:

Thank you for the steps to reproduce this bug. With your steps, I can reproduce the bug in NeoOffice 3.1.2 and 3.2 Beta.

I have bad news: I can also reproduce this bug in both OpenOffice.org 3.1.1 (the version that NeoOffice is based on) and OpenOffice.org 3.3 (their latest version) so this is definitely an OpenOffice.org bug.

Unfortunately, our very limited donations only supports one half time developer (me) so this limits the current scope of the NeoOffice project to keeping a native version of OpenOffice.org running on Mac OS X and fixing any critical crashing and hanging bugs that our users find. Because of these limits, fixing OpenOffice.org's feature bugs is outside of that scope.

What I can do is give you a workaround that will avoid this bug. The bug is that you are putting the DDE function inside of an array operator (that is it is inside "{}"). It is using this array operator that triggers the bug. So, what I did in the attached modified version of your no._4 spreadsheet file was to put a DDE function in each of the cells so that the return value of each DDE function is a single value, not an array.

Not only does this stop display of the "do you want to update links" dialog every time you open the spreadsheet, but it correctly save the last values fetched by the DDE functions.

Does my workaround work for you?

Patrick
Back to top
timrichardson
Pure-blooded Human


Joined: Oct 07, 2007
Posts: 39

PostPosted: Sat Apr 16, 2011 2:43 pm    Post subject:

Thanks Patrick. I reported the bug at LibreOffice.
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Sat Apr 16, 2011 3:07 pm    Post subject:

timrichardson wrote:
Thanks Patrick. I reported the bug at LibreOffice.


Thank you for filing a bug with LibreOffice.

Just to confirm, did the workaround that I made to your document (that is, a separate DDE function for each respective cell) work for you?

Patrick
Back to top
timrichardson
Pure-blooded Human


Joined: Oct 07, 2007
Posts: 39

PostPosted: Sat Apr 16, 2011 7:41 pm    Post subject:

Yes, it did, and I mentioned that in the bug report to LibreOffice because it helps isolate the problem.
Back to top
timrichardson
Pure-blooded Human


Joined: Oct 07, 2007
Posts: 39

PostPosted: Mon Apr 25, 2011 3:27 pm    Post subject:

For completeness sake, I reported this upstream.
https://bugs.freedesktop.org/show_bug.cgi?id=36311

They could not reproduce, but said that DDE is flakey and may not be used for paste link in future. When I pointed out that at least it updated dynamically, unlike simple links which require manual update, there was not much insight.

I tried to make a simple test case to help them reproduce ... but I could not reproduce!
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Mon Apr 25, 2011 3:34 pm    Post subject:

timrichardson wrote:
I tried to make a simple test case to help them reproduce ... but I could not reproduce!


I could reproduce this bug with your sample very easily in LibreOffice. My guess is that they did not create the absolute path that your DDE functions point to (that is /Users/...) and put the sample document there.

One they are able to reproduce it, they should find that the problem occurs when nesting DDE functions in a Calc array within a cell.

Patrick
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Beta Releases All times are GMT - 7 Hours
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.