Apache OpenOffice (AOO) Bugzilla – Issue 108404
value return 0 from link of calc file with password
Last modified: 2017-05-20 11:42:08 UTC
1. create ODS (i.e "transaction.ods")and save as with password "abc" 2. create another ODS file (i.e "master.ods")and save as with password "xyz" 3. put value in cell A1, B1, C1 = 1, 2, 3 in "master.ods" 4. link A1, B1, C1 in "transaction.ods" to A1, B1, C1 in "master.ods" (cell A1 in "transaction.ods" will contain like this "='file:///C:/master.ods'#Sheet1.A1") [in normal case, value of A1, B1, C1 in "transaction.ods" should be the same as value of A1, B1, C1 in "master.ods"] close the file and save the changes. 5. open file "transaction.ods", enter the password. A dialog box will appear. click "Yes" to update the file with the link contained. 6. Cell A1, B1, and C1 will be "0" (Zero) If you remove password of file "master.ods", cell A1, B1, C1 of "transaction.ods" will return the value of A1,B1, C1 of "master.ods" correctly.
any help ? I am using the newest released candidate version, but still getting this problem..
hai.. just wondering about the progress of this issue.. I don't see this has been resolved yet in the newest release candidate version (RC4)..
*** Issue 109090 has been marked as a duplicate of this issue. ***
@kohei: ?
Let me look into that.
any update on this ? my users are waiting impatiently. This could be a reason for them to go back to microsoft excel.. I really need progress here... Thanks
No update. All of us developers are already under massive loads, so it's not reasonable to expect a bug be fixed that quick.
If you need an immediate fix, you should get a support contract with someone capable of supporting OOo.
Confirmed. But I doubt this ever worked correctly. So, at least this is not a regression. For instance, when you link a table to an encrypted document, it succeeds only for the first time. When you reload the document and select to update the link, the table fails to update. The reason I checked the linked table is that linked tables are an old mechanism not affected by my rework of the external references. I could check how easily we can add support for encrypted documents, but no idea if I could make that for 3.3.
then my user will have a reason to stay with their excel until openoffice resolve this issue... this becomes one of the obstacles that will hold me to reduce excel users in my office..:( Please, let me know if you have new progress on this.. Thanks
I had a second look at this. Actually fixing this is quite simple. I'll put this into the koheiextref01 cws for 3.3 inclusion.
set target for 3.3.
fixed in koheiextref01 cws. http://hg.services.openoffice.org/cws/koheiextref01/rev/8e541a16ecaa
UseInteractionHandler must only be used if user interaction is involved. When called via API for example, no pop-up dialogs are allowed. See issue 73992 and the handling in tablink.cxx.
Good point. I've added a guard to disable interaction handler when interpreting formula strings from the API. http://hg.services.openoffice.org/hg/cws/koheiextref01/rev/a113b80ef941 The external doc link API (the interfaces in linkuno.?xx used from oox) doesn't need such guard since it accesses the cache table content directly.
Re-assigning to oc for verification.
Re-assigning to Yi Fan for verification.
Verified on SLED 11 sp1 and Windows xp sp3.
*** Issue 24535 has been marked as a duplicate of this issue. ***