Created attachment 160477 [details]
An XLS (BIFF5) without proper codepage specified in the file, assumed Win-1251
The attached file (presumably generated using some 3rd-party generator) lacks explicit codepage (assumed Win-1251). Opening it in Calc with Russian locale and Russian default document language, all Cyrillic characters get garbled (i.e., Win-1252 is used instead of Win-1251).
Excel 2016 on Russian Windows OS opens this file correctly. On English OS, Excel emits "File error. Some number formats may have been lost.", and opens with garbled Cyrillic characters, as in Calc.
Tested with Version: 126.96.36.199 (x64)
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: default; VCL: win;
Locale: ru-RU (ru_RU); UI-Language: en-US
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":
tdf#132796: use LO language settings to set default XLS language
It will be available in 7.0.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
*** Bug 35208 has been marked as a duplicate of this bug. ***
*** Bug 94382 has been marked as a duplicate of this bug. ***
*** Bug 96330 has been marked as a duplicate of this bug. ***