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)
dim demenageur As Object
demenageur = createUnoService("com.sun.star.ucb.SimpleFileAccess")
FileStart = "ftp://utilisateur:firstname.lastname@example.org/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)
Another non working sub routine when call from a local Calc file
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:email@example.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())
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:
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.
*** 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