Bug 158282 - FILEOPEN Incorrect encoding opening MS Excel 4.0 for Macintosh files with cyrillic text
Summary: FILEOPEN Incorrect encoding opening MS Excel 4.0 for Macintosh files with cyr...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Format-Filters
  Show dependency tree / graph
 
Reported: 2023-11-20 11:20 UTC by Mikhail Kukharenko
Modified: 2023-12-09 12:06 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
MS Excel 4.0 document with Cyrillic text (3.12 KB, application/octet-stream)
2023-11-20 11:20 UTC, Mikhail Kukharenko 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mikhail Kukharenko 2023-11-20 11:20:57 UTC 
Created attachment 190920 [details]
MS Excel 4.0 document with Cyrillic text

When I open the old MS Excel 4.0 documents with cyrillic text in Libreoffice , they opened with incorrect encoding (became unreadable).

Example is attached. All my Excel documents contain two fonts:
1. Латинский (\x8b\xe0\xf2\xe8\xed\xf1\xea\xe8\xe9)  and 
2. Прямой Проп (8FF0DFECEEE9208FF0EEEF)

1st font is Serif (like Times)
2nd font is Sans Serif (like Arial)

Right inside the binary document I changed the 1st font name to 
"Times CYR" and  2nd font name to "Arial   CYR" (to preserve the length) but it did not work (opened unreadable again).

Utilities from https://sourceforge.net/p/libmwaw/wiki/Home/ did not help either.

See also https://bugs.documentfoundation.org/show_bug.cgi?id=158225#c12

I tried to understand here (https://learn.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/cd03cb5f-ca02-4934-a391-bb674cb8aa06) what should I change inside Excel document, but its too complicated.

Is that possible to fix libreoffice calc filter to correctly import old excel documents with at least fonts listed above?
Comment 1 Roman Kuznetsov 2023-11-23 20:48:04 UTC 
confirm in

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d7a5e7643f3540b1490c1e2f1a91ff86c721d7b6
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL threaded