Impossible to open file, copy file or obtain data using DDE function when using macro from a local application or function with ftp address. Exemple of sub-routine doesn't working well on version 3.3 (working fine on OOo version 3.2.1) Sub CopyFile dim demenageur As Object demenageur = createUnoService("com.sun.star.ucb.SimpleFileAccess") FileStart = "ftp://utilisateur:motdepasse@ftp.monsite.com/monfichier.ods" FiileStop = converttourl("C:/monfichier.ods") demenageur.copy(FileStart,FiileStop) 'False - Erreur d'exécution Basic com::sun::star::ucb::InteractiveAugmentedIOException (import) rem demenageur.copy(FiileStop,FileStart) 'OK this way (export) end sub Another non working sub routine when call from a local Calc file Sub OpenFileSub dim oDocument As Object, oSheet As Object, oCell As Object dim fichier As STRING, Utilisateur As String dim document as object, dispatcher as object document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") Fichier = "ftp://test%40monsite.com:monmotdepasse@ftp.monsite.com/monfichier.ods" dim args102(1) as new com.sun.star.beans.PropertyValue args102(0).Name = "URL" args102(0).Value = converttourl(Fichier) args102(1).Name = "MacroExecutionMode" args102(1).Value = 4 dispatcher.executeDispatch(document, ".uno:Open", "", 0, args102()) end sub In other words, tring to get a file or a cell data value from a server does not work. However, I did not see any problem to put file (or copy file) on a server. The problem seems to be only on the import side (from server to local computer). Everything is working fine on OOo ver 3.2.1. So there is nothing with the ftp address itself.
Confirmed in master build. Here is a code pointer to start debugging it: http://opengrok.libreoffice.org/xref/libs-gui/ucbhelper/source/client/content.cxx#1527
Did not ear about this one for awhile. Is this tickey make part of the priority? Need it fixed to upgrade some applications. Case else, I am stock behind with 3.2.1 ..... Regards.
So, I think this problem is one I saw and fixed earlier today, i.e. http://cgit.freedesktop.org/libreoffice/core/commit/?id=3ae98a0ca5329a0205728a46b4e5dd0d4b46a9f3
*** Bug 39376 has been marked as a duplicate of this bug. ***
got cherry-picked for 3.4.3 http://cgit.freedesktop.org/libreoffice/libs-core/commit/?h=libreoffice-3-4-3&id=c0887806c54985a22e7a6688fee113dd17ceaeaa