basic can't use chinese characters while protect

Bug #1038632 reported by jmxhyz
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
libreoffice (Ubuntu)
Invalid
Undecided
Unassigned

Bug Description

1) lsb_release -rd
Description: Ubuntu quantal (development branch)
Release: 12.10

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.6.1~rc2-1ubuntu5
  Candidate: 1:3.6.1~rc2-1ubuntu5
  Version table:
 *** 1:3.6.1~rc2-1ubuntu5 0
        500 http://archive.ubuntu.com/ubuntu/ quantal/main i386 Packages
        100 /var/lib/dpkg/status

3) What is expected to happen in a new Calc document is Save as cmsgbox.ods -> Tools -> Macros -> Organize Macros -> LibreOffice Basic... -> Expand cmsgbox.ods -> highlight Standard -> click button Organizer... -> In LibreOffice Basic Macro Organizer click tab Libraries -> change Location dropdown to cmsgbox.ods -> button New... -> cmsgboxlib -> button OK -> button Password... -> password: 123 -> button OK -> button Edit -> make the box look like:
REM ***** BASIC *****

Sub Main
 msgbox "中文"
End Sub

-> Run BASIC (F5) and notice a soffice window pops up with:
中文

click OK button -> Save -> close window msgbox.ods.cmsgboxlib - LibreOffice Basic -> close window cmsgbox.ods - LibreOffice Calc -> reopen cmsgbox.ods -> click Tools -> Macros -> Run Macro -> expand cmsgbox.ods -> expand cmsgboxlib -> click Module1 -> click button Run and an soffice window should pop up with:
中文

4) What happens instead is it shows:
??

End result document may be found at https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1038632/+attachment/3358596/+files/cmsgbox.ods .

Environment: libreoffice 3.5.x , 3.6.x @ ubuntu 12.04 @ zh_CN.UTF-8
---
ApportVersion: 2.0.1-0ubuntu13
Architecture: i386
DistroRelease: Ubuntu 12.04
InstallationMedia: Xubuntu 12.04 "Precise Pangolin" - Beta i386 (20120228)
NonfreeKernelModules: nvidia
Package: libreoffice 1:3.5.4-0ubuntu1.1
PackageArchitecture: i386
ProcEnviron:
 LANGUAGE=zh_CN:en
 TERM=xterm
 PATH=(custom, no user)
 LANG=zh_CN.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 3.2.0-31.50-generic-pae 3.2.28
Tags: precise
Uname: Linux 3.2.0-31-generic-pae i686
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups: adm cdrom dip lpadmin plugdev sambashare sudo vboxusers

jmxhyz (jmxhyz)
description: updated
Revision history for this message
penalvch (penalvch) wrote :

jmxhyz, thank you for taking the time to report this bug and helping to make Ubuntu better. Please execute the following command, as it will automatically gather debugging information, in a terminal:
apport-collect BUGNUMBER
When reporting bugs in the future please use apport by using 'ubuntu-bug' and the name of the package affected. You can learn more about this functionality at https://wiki.ubuntu.com/ReportingBugs.

As well, could you please attach the password protected document with password, that demonstrates this problem?

Changed in libreoffice (Ubuntu):
status: New → Incomplete
Revision history for this message
jmxhyz (jmxhyz) wrote :

libreoffice basic macro protected document with password "123".
in the massage box, chinese character change into "???".

penalvch (penalvch)
Changed in libreoffice (Ubuntu):
status: Incomplete → New
Revision history for this message
penalvch (penalvch) wrote :

jmxhyz, please execute the following command, as it will automatically gather debugging information, in a terminal:
apport-collect 1038632
When reporting bugs in the future please use apport by using 'ubuntu-bug' and the name of the package affected. You can learn more about this functionality at https://wiki.ubuntu.com/ReportingBugs.

As well, could you please provide a screen recording of this problem via the package recordmydesktop?

Changed in libreoffice (Ubuntu):
status: New → Incomplete
Revision history for this message
jmxhyz (jmxhyz) wrote : Dependencies.txt

apport information

tags: added: apport-collected precise
description: updated
Revision history for this message
jmxhyz (jmxhyz) wrote :

Recording desktop。
password protect the macro library, that library contains Chinese.
close the document. then reopen it. run the macro, the Chinese character becomes "??"

Revision history for this message
jmxhyz (jmxhyz) wrote :

libreoffice document with basic macro.
basic macro library protected password is "123".
just the recording desktop Video show.

Revision history for this message
penalvch (penalvch) wrote :
  • cmsgbox.ods Edit (10.2 KiB, application/vnd.oasis.opendocument.spreadsheet)

Simplified bug end result.

description: updated
penalvch (penalvch)
description: updated
Revision history for this message
penalvch (penalvch) wrote :

jmxhyz, thank you for attaching the recordings.

The reason why when you open your attachment:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1038632/+attachment/3333286/+files/macro-library-protect.ods

you initially cannot run the macro and see chinese characters, is because that library is password protected, and you did not input the password to allow yourself full access to this macro.

In order to do so, one must click Tools -> Macros -> Organize Macros -> LibreOffice Basic... -> expand macro-library-protect.ods -> expand Library1 -> input Password:
123

-> click button OK -> click button Close -> then click the button:
button show Chinese

and it will show the chinese characters as expected.

Thank you for reporting this. Please feel free to report any future bugs you may find.

Changed in libreoffice (Ubuntu):
status: Incomplete → Invalid
Revision history for this message
jmxhyz (jmxhyz) wrote :

why can it show the English but do not show Chinese when that library is password protected ?

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.