Apache OpenOffice (AOO) Bugzilla – Issue 41404
dde link spaces in source path name cannot be inserted manually
Last modified: 2017-05-20 11:25:52 UTC
DDE links from spreadsheet into writer in instances where there are spaces in the path name do not register properly. For example the dde link in writer 'soffice C:\Documents and Settings\Administrator\Desktop\test.sxc Sheet1.A1' does not register properly. When inserting this link, it returns an error “Error loading file ///C:Documents C:\Documents does not exist.†Putting quotation marks around the file name does not solve the problem. A workaround follows: Dismiss the error error message. Click on insert anyway. At this point, a small gray block will appear in the text document. Left click on the beginning of the gray block. Then right click at the beginning of the gray block. A dialogue with numerous choices, one of which is “fields†should appear. If “fields†does not appear, repeat the process as needed until “fields†does appear. Select “fieldsâ€. At this time, a dialogue entitled “Edit Links†appears. Select “modifyâ€. A new dialogue will come up. Ensure that “application†is soffice. Correct the file name so it reads C:\Documents and Settings\Administrator\Desktop\test.sxc. Correct the category so it reads Sheet1.A1. Select “OK†At this time, select “update†[for manual links] and then close. At this time, the link will appear properly in the document.
reassigned to ES.
I cannot reproduce it. How do you "insert the link"?
Here is the full detail of the procedure to reproduce the bug and the workaround: Create a spreadsheet. Save it to desktop as test. (e.g. C:\documents and settings\userName\desktop\test.sxc). Note that userName is the name under which you logged into MS Windows 2000. Put some values in the spreadsheet. (i.e. Put the word "month" in cell A1). Create a new document. Save it to desktop as test. (e.g. C:\documents and settings\userName\desktop\test.sxw) Select menu choices <insert><fields><other>. This will bring up a dialogue entitled 'fields'. Click on the 'variables' tab. Select 'dde field'. Select automatic format. Fill in 'name' with the name for a link (e.g. testLink1). Fill in 'dde statement' with the following: 'soffice c:\documents and settings\userName\desktop\test.sxc a1'. Click the 'insert' button. At this point a dialogue will come up with the message: 'Error loading document file:///c:/documents: c:\documents does not exist. "ok"'. This is the stated bug found in Open Office Org 1.1.4. It is always possible to reproduce this bug. Now, to proceed with the workaround. Click “ok†on the error dialogue noted above. Close the 'fields' dialogue box. At this time, note the presence of a small gray block in your text document. Left click on the beginning of the gray block. Now, right click on the beginning of the gray block. This will bring up a drop down menu. Select 'fields' from the menu. If the 'fields' choice does not show, repeat the left click and right click procedure as needed until 'fields' does show. Selecting fields will bring up another dialogue entitled “edit linksâ€. Then select 'Modify Link'. 'Application' should read 'soffice' File will read 'c:\documents'. You will need to change this to read 'c:\documents and settings\userName\desktop\test.sxc' Category will read 'and settings\userName\desktop...' Change this to read 'a1'. Click 'ok'. Now close the dialogue. At this time the link is properly set.
I replicated it. i using OOo1.1.4 windows2000 5.00.2195 sevice pack 4 i think this caused by the pattern which use space to separate file name and category. So the first space in the path consider as a separate.
I filed this notice for a machine that runs MS Windows 2000 Service Pack 4. I also run Open Office Org 1.1.4 on a MS XP Professional machine with Pentium III processor, 800 MHZ and 256 MEG of RAM. It exhibits the same behaviour. As konggyk has also observed, this has something to do with the pattern of spaces in the file path.
Confirmed. Using OOo 1.9.74 on Win 2000 SP4. I didn't get the Error loading document file:///c:/documents: c:\documents does not exist. "ok"'. message, but it still did not work correctly. After getting back to the main text document screen, I double clicked on the inserted field and it had Source File set to 'C:\Documents' and the Element set to 'and Settings\<username>\Desktop\test.ods a1'. It should have had Source File as 'C:\Documents and Settings\<username>\Desktop\test.ods' and Element set to 'a1'. Regardless, following the above instructions will produce the error.
It was reproduced in OOo 1.1.4 Windows XP Professional, Version 5.1, Build 2600, Service Pack 1. It can be reproduced according to the report above, and can also be reproduced by executing the following steps: 1.Copy an existing Spreadsheet file to "D:\a1\", and rename the file into "41404 t.sxc". (Note: The file has contents in A1 cell of Sheet1.) 2.Open OOWriter, and create an empty text document. 3.Select “Insert -> Field -> Otherâ€, click on “Variables†tab, enter “soffice D:\a1\41404 t.sxc Sheet1.A1†in the “DDE Statement†area, and click Insert. 4.Click “OK†on the error message, and click “Close†to close “Fields†dialogue. 5.A gray rectangle appears in the document. Double click it. 6.In “Edit Links†dialogue, click “Modify…â€. We can see that, in “Application†area, is “soffice†which is correct, in “File†area, is “D:\a1\41404†which is incorrect, in “Category†area, is “t.sxc Sheet1.A1†which is incorrect. (Obviously, the system splits three areas by space.) 7.In “File†area, enter “D:\a1\41404 t.sxcâ€; in “Category†area, enter “Sheet1.A1â€, and then click “Closeâ€. 8.The contents of A1 of Sheet1 from the file “D:\a1\41404 t.sxc†are shown in the text document now.
ES->OS: it is not possible to manually (Insert - Fields - Others - Variables DDE link) insert a DDE link containing a blank in the target path. Using quotes, double quotes around the whole statement or only the path, a backslash before the blanl or even %20 instead of the blank doesn't help. Though, when the link is inserted automatically over copy/paste as DDE Link, the Edit - Links dialog shows a path containing a blank and the link works. Sum up: there should be a way to insert such links manually.
Reset assigne to the default "issues@openoffice.apache.org".