To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=101782
------- Additional comments from paulwolstenho...@openoffice.org Fri Jul 3
02:28:13 +0000 2009 -------
In 3.1.0 OFFSET to a cell in another spreadsheet file always gives Err:504. The
links in my spreadsheets mostly use this feature. This means that even if I
could stop OOo from crashing when opening, my old linked spreadsheets (and I
have found many sheets that do crash) would not work on OOo 3.1.0 anyway.
The failure of OFFSET can be demonstrated by creating 2 calc files and entering
a formula into file SpreadsheetB such as:
=OFFSET('file:SpreadsheetA.ods'#$Sheet1.C5;0;0)
Note that OOo will add the full path after you enter it. The function wizard
even lets you specify the link by clicking in the other spreadsheet if you have
both open.
So far I haven't been able to prove that this has anything to do with OOo
hanging. What I do know is that after OOo does hang, memory usage increases
until something happens (such as: visual C++ runtime library - runtime error...
application requested the runtime to terminate in an unusual way). While
hanging I've also seen the linked files on the share drive being accessed
(reported by windows 'computer management') and the file original spreadsheet
file being opened a second time (read instead of read-write access).
As I knowing nothing of OOo internals, interpretation of the symptoms and a
possible link of these issues is beyond me.
---------------------------------------------------------------------
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...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
