Problem description: When the user library is password protected, there are issues with unicode? (cyrillic in my case) strings. Steps to reproduce: 1. create user library 2. enter some sample code Dim oDoc As Object Dim oSheet As Object Dim oCell As Object oDoc = ThisComponent oSheet = oDoc.Sheets(0) oCellTest = oSheet.getCellRangeByName("A1") oCellTest.String = "Ленинский проспект" 2. run the macro - works fine (displays Ленинский проспект string in the A1 cell) 3. password protect the module 4. run the macro again - does not work fine (displays ???????? ??????? string in the A1 cell) Current behavior: The cyrillic characters are replaced with question marks when the module is password protected. Expected behavior: The cyrillic characters display just fine, no matter whether the module is password protected or not. Platform (if different from the browser): Browser: Opera/9.80 (Windows NT 5.1) Presto/2.12.388 Version/12.10
Created attachment 70101 [details] Test files (LO Calc) to demonstrate the issue. password-test-protected.ods: password protected user library demonstrating the described issue password-test-unprotected.ods: unprotected user library, no issues (included for comparison)
The problem seems to not be platform-specific, I've tested it in Windows XP 32-bit (Czech), Windows 7 64-bit (English) and OpenSUSE (Czech) and the behaviour is identical everywhere. The problem is not caused by the presence of the password protection itself; once the password is entered ("becomes known to LO"), all works fine even in protected document. But if the end-user doesn't know the password protecting the BASIC library (this is intended), he/she is stuck.
*** Bug 58426 has been marked as a duplicate of this bug. ***
Ubuntu 14.04 x64 LibreOffice 4.2.4.2 release +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Just tested this on 4.2.4.2 release and it seems to work fine. Marking as: RESOLVED WORKSFORME If you still have this problem on 4.2.4.2 release please mark the bug as UNCONFIRMED and let us know your platform. Thanks!
Thanks for the feedback, unfortunately it does not work for me. Xubuntu 14.04 x86 (Ubuntu 14.04 LTS + Xfce 4.10), Czech localization in case it matters LibreOffice 4.2.4.2 release I tried both original test file included in attachment 70101 [details] (comment 2 in this thread) and a new file created from the scratch (in 4.2.4.2) and the behaviour is identical (broken) in both cases. On Windows platform it is the same. Steps to reproduce: - download the attachment 70101 [details] above - open the file password-test-protected.ods from within it - click on the "Run Test" button - text string "This should display in cyrillic: ????????? ????????." appears in the A1 cell, i. e. question marks instead of cyrillic characters When I do the same with the file password-test-unprotected.ods, the string is displayed correctly after pressing the "Run Test" button. See attached pair of screenshots. It is important to NOT unlock the library (by entering the password) before pressing the "Run Test" button.
Created attachment 99565 [details] Illustration of behaviour (for comment 5)
Please don't change the version - it reflects the oldest confirmed version not the latest tested on. Thanks!
Created attachment 105034 [details] screenshot showing where the "password protect" is Reproduced with version 4.3.1.1, Win7. Set to NEW. Password protect = protect the "libary", not the document, see screenshot.
Created attachment 105035 [details] An ODS file with password-protected macro library
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.