To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=103317
                 Issue #|103317
                 Summary|References to external documents stored as relative UR
                        |Is are not adjusted during open.
               Component|Spreadsheet
                 Version|OOo 3.1
                Platform|All
                     URL|
              OS/Version|All
                  Status|NEW
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|open-import
             Assigned to|kohei
             Reported by|er





------- Additional comments from [email protected] Fri Jul  3 14:27:52 +0000 
2009 -------
The UI visible absolute URI is not adjusted for references to external
documents that are stored with a relative xlink:href URI. This is
a regression from OOo3.0.1

Assuming that the document folder is set to /home/you/Documents the
scenario to reproduce is:

0. Make sure that Tools->Options->Load/Save->General "Save URLs relative
   to file system" is enabled.
1. Create any spreadsheet document with some value in A1, save as
   external.ods and close document.
2. Create a second spreadsheet document.
3. In A1 enter ='external.ods'#Sheet1.A1
4. Note that the formula is displayed as
   ='file:///home/you/Documents/external.ods'#$Sheet1.A1 and also menu
   Edit->Links shows the file name as
   file:///home/you/Documents/external.ods
5. Save as referring.ods and close document.
6. In a shell move both, external.ods and referring.ods, to a different
   directory, let's say /home/you/somewhere/
7. Open /home/you/somewhere/referring.ods
8. Note that the formula and Edit->Links still display the URI as
   file:///home/you/Documents/external.ods
   It should display file:///home/you/somewhere/external.ods instead.

Calculation works correctly and so does refreshing the document.
However, the behavior is confusing, and in case a real document
/home/you/Documents/external.ods existed additionally, referring that
for already cached ranges would not be possible because the cache
already resolved the name internally.

---------------------------------------------------------------------
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]

Reply via email to