Created attachment 76893 [details] Screenshot with the message Message: Incorrect format for Script URI: Hi, I am using an existing MS xls document with some simple macro's. I use this macro succesfully (after setting macro security to low) But, after saving this document and reload it again I get this message when I want to use the macro again. Greets, Maikel
Please attach a document for testing and set as UNCONFIRMED.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INVALID due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker -- The LibreOffice QA Team This INVALID Message was generated on: 2015-05-06 Warm Regards, QA Team
Created attachment 128244 [details] macro.xls: open from smb://server/share/macro.xls to see the error. Key concept: must open from Windows share via smb://xx/x/file.xls to see the macro error provided in the bug's description. It works fine if opened from a CIFS mount. Key concept: must be .xls format. It works fine in .ods format. (I don't know about .xlsx since I can't easily produce that.) My testing scenario: Windows 2003 server providing the windows share, Clients are Ubuntu 16.04 and Mint 12.04. Tested with LO 5.3 all the way back to where the document first loaded in last41onmaster, always with the same results.
One additional comment regarding opening an .xls file with VBA macros from a gvfs / samba share: I am *not* prompted to enable the macros when the document opens. The macros are somewhat enabled, resulting in the the error, but something is corrupting to not prompt the user to enable them on load. To confirm Justin L's observation, When opening the file with a CIFS connection via /etc/fstab and the same .xls file, I am prompted to enable the macros, and then the macro when executed will complete successfully. The same behavior is present with either a Windows File Server, or Samba running on a Linux server.
critical: data loss of macro code. Since the macros code is not read during the loading of the file, it isn't available during the save phase, and thus is lost. medium: affects a small subset of users.
starting point for a discussion on how to properly fix this: https://gerrit.libreoffice.org/30303 tdf#62625 - reopen stream to readBasic VBA over SMB
Windows doesn't seem to have a problem with an .xls with macros over a SMB share. Marking as Linux only. Perhaps only a problem in Gio (Gnome?) code.
Linux: also affects protocols sftp:, http:, dav: Windows: affects remote file - webdav service. Reproduction steps 1.) copy macro.xls test document to the remote site somehow. 2.) open Libreoffice and enable macros via: tools - options - security - macro security - Medium (prompt to enable macros). 3.) open macro.xls from http://, or sftp://, or smb:// 4a.) if it asks to enable macros, that is good. You can just disable for safety’s sake. If it loads without prompting about macros, click on a button and see the bug’s error message. Saving a copy of that locally would be missing 4b.) if loading the macros worked, save a copy locally, and confirm that it round-trips fine. It will.
Tested on macOS 10.12.1 + LO Version: 5.3.0.0.alpha0+ Build ID: 40fc2c1a0d2ebdf47131651045107c9d5abb850d CPU Threads: 4; OS Version: Mac OS X 10.12.1; UI Render: default; TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2016-10-20_06:13:56 Locale: de-DE (de_DE.UTF-8); Calc: group Opening this file http://www.ajaxfilebrowser.com/User05b65ad/macro.xls via Start Center > Remote files and WebDAV results in: * the file being opened * no macro dialog to be shown (despite security settings for macros being set to "medium" at LibreOffice > Preferences > Security) Clicking any of the macro buttons results in the following error msg: A Scripting Framework error occurred while running the UNKNOWN script UNKNOWN. Message: Incorrect format for Script URI:
Justin Luth committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d9c7b0a01162254240a1328fa594991eccf6bc65 tdf#62625 - reopen temp stream to readBasic .xls VBA It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=07b1e1025653c05f6422278da793261cbff42c71&h=libreoffice-5-2 tdf#62625 - reopen temp stream to readBasic .xls VBA It will be available in 5.2.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.