Created attachment 133343 [details] file w cracked symbols I try to change BASIC script in XLS file (created in original MS app. system Cyrillic encoding is cp1251, excel 97-2003 format) after that. I saved it, closed and open it again BUT all Cyrillic symbols was cracked (only ??????? symbols) like >> Nums1 = Array("", "один ", "два ", "три ", "четыре ", "пять ", "шесть ", "семь ", "восемь ", "девять ") >> to >> Nums1 = Array("", "???? ", "??? ", "??? ", "?????? ", "???? ", "????? ", "???? ", "?????? ", "?????? ") >> or like in attched file. I understand that Cyrillic in functions is not good but in arrays and variables?
5.1 branch is EOL and 5.2 will be soon. Could you give a try to last stable LO version 5.3.3?
at the same in: version: 5.3.3.2 Зборка: 1:5.3.3~rc2-0ubuntu0.16.04.1~lo0 CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; VCL: gtk2; Layout Engine: new; Locale: be-BY (be_BY.UTF-8); Calc: group I try xlsm format result at the same.
I had a similar problem more than a year ago, but then it was too lazy to make a report, in the hope of soon correct. Today if to paraphrase the saying "on other people hope, but itself good be can't stop." When you try to open the corrupted file again in the Excel, the "?" Signs are also displayed in the VBA editor. Presumably, something with codepages: in my country in Windows is usually used cp1251. In ubuntu I have a system encoding UTF-8 Downloaded the sources, but did not yet understand where to look for the problem.
This bug was incorrectly moved from NEEDINFO to REOPENED. Putting back to UNCONFIRMED.
Could you attach the original xls file? Indeed Excel 2013 tries to retrieve some information but doesn't succeed completely.
I also have same problem with *.xls and *.xlsm files
Hello, Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you
Created attachment 136521 [details] Cracked cyrillic symbol in Basic editor after save file in xls format
As indicated next to the field, the version must correspond to the earliest affected so I reverted back to 5.1.6.2
On pc Debian x86-64 with master sources updated today, I could reproduce this with Michelin38's file.
(In reply to Michelin38 from comment #8) > Created attachment 136521 [details] > Cracked cyrillic symbol in Basic editor after save file in xls format I download Michelin38's file, opened it and saw this in the doc: MsgBox "Hello! This greeting in English" MsgBox "Привет!This greeting in Russian" and save after that I saved it and opened again and saw this: MsgBox "Hello! This greeting in English" MsgBox "??????!This greeting in Russian" Version: 5.1.6.2 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2
dimahetman: why did you put UNCONFIRMED status since you confirmed it and I had confirmed it too? Anyway, let's put this back to NEW.
The same problem with LibreOffice 6.1.0.3 under windows 8.1 Pro. After saving file in .xlsm format with Cyrillic letters in script all of them turns into ????????. Script becomes unusable.
possible source code pointer: https://opengrok.libreoffice.org/xref/core/basctl/source/basicide/baside2b.cxx?r=8bf1542f#118 --- https://opengrok.libreoffice.org/xref/core/basctl/source/basicide/baside2.cxx?r=6e9d8739#784 or https://opengrok.libreoffice.org/xref/core/basctl/source/basicide/baside2b.cxx?r=8bf1542f#998 I don't know the difference --- https://opengrok.libreoffice.org/xref/core/basic/source/classes/sbxmod.cxx?r=889dc7bf#1587 https://opengrok.libreoffice.org/xref/core/basic/source/classes/image.cxx?r=49c88d8b#142 or https://opengrok.libreoffice.org/xref/core/basic/source/classes/image.cxx?r=49c88d8b#145
Seems I'm misunderstanding something. SAL_INFO I put with confidence was not reached.
here is another suggestion for source code pointer: https://opengrok.libreoffice.org/xref/core/oox/source/ole/vbaproject.cxx?r=b3edf85e#266
and here https://opengrok.libreoffice.org/xref/core/oox/source/ole/vbamodule.cxx?r=85fe083c#readSourceCode
https://opengrok.libreoffice.org/xref/core/oox/source/ole/vbaexport.cxx?r=ed5e4405#811 https://opengrok.libreoffice.org/xref/core/oox/source/ole/vbaexport.cxx?r=ed5e4405#60 https://opengrok.libreoffice.org/xref/core/oox/source/ole/vbaexport.cxx?r=ed5e4405#42
I guess Markus has a good knowledge, considering these paths in the code. https://opengrok.libreoffice.org/xref/core/oox/source/ole/vbaexport.cxx?r=ed5e4405#1073
This is very likely a dupe of bug 75263, which is in See Also.
*** This bug has been marked as a duplicate of bug 75263 ***