Bug 142670 - Cyrillic characters are changed to questions marks after saving a spreadsheet document in CSV format in the Calc
Summary: Cyrillic characters are changed to questions marks after saving a spreadsheet...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-06-05 11:35 UTC by GregLou
Modified: 2021-06-09 15:19 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc cyrillic characters in spreadsheet (29.69 KB, image/png)
2021-06-05 11:36 UTC, GregLou
Details

Note You need to log in before you can comment on or make changes to this bug.
Description GregLou 2021-06-05 11:35:58 UTC
Description:
Problem persists in version 7.1.2.2 under Windows 10 x64 ENG, this bug has not been fixed! I create a document in *.CSV file using words in Cyrillic russian language, in ANSI and WIN-1251 encoding. I save it several times and everything is fine with encoding, all words are readable when I open this CSV file in LibreOffice few times. But by some coincidence, after saving this document before rebooting the computer (after rebooting request), after rebooting I open it and instead of all Cyrillic characters i see question marks - ????
All Cyrillic characters turn into question marks.

I lost all the russian text, I have to work in Notepad++ instead of Calc with unpredictable behavior. I lose a lot of personal time to re-editing the document.

Steps to Reproduce:
1. Create a spreadsheet in Calc with encoding parameters: ANSI, Cyrillic WIN-1251 and running on Windows 10 x64 Enterprise.
2. Enter text in Russian (in Cyrillic) into the table.
3. Save the document as a comma-separated plain CSV document.
3. Edit text, enter new lines in Russian, do not save document.
4. Restart Windows, when prompted to restart Calc will ask to save the document. 5. Press Yes and Yes again to save it in normal CSV format.
6. Reboot your computer and reopen the same document.


Actual Results:
All Russian characters are replaced by question marks in the document after opening.

Expected Results:
Show Cyrillic characters as they were saved in the document.


Reproducible: Sometimes


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
The bug does not always reproduce itself, if you just save this document and open it without rebooting, nothing changes - the characters are fine.
Comment 1 GregLou 2021-06-05 11:36:49 UTC
Created attachment 172640 [details]
Calc cyrillic characters in spreadsheet
Comment 2 Timur 2021-06-07 09:40:01 UTC
Bug must be reproducible, with exact steps, that normally include not reboot, as it doesn't affect fileopen. 
If you saved as Cyrillic WIN-1251, you also must use that to open. 
Screenshot is of no use, CSV is needed - with reproducible steps.
Comment 3 GregLou 2021-06-08 13:29:35 UTC
Послушай, я хз как эти необъяснимые глюки воспроизвести. То что глючит - это факт.
Comment 4 QA Administrators 2021-06-09 03:48:59 UTC Comment hidden (obsolete)
Comment 5 Michael Warner 2021-06-09 14:00:46 UTC
(In reply to GregLou from comment #3)
> Послушай, я хз как эти необъяснимые глюки воспроизвести. То что глючит - это
> факт.

For the benefit of others, Google translates Comment 3 to this:
"Listen, I xs how to reproduce these inexplicable glitches. What is buggy is a fact."
Comment 6 Timur 2021-06-09 15:07:49 UTC
So let's close, this is searchable, maybe someone will bump into.
Comment 7 Roman Kuznetsov 2021-06-09 15:19:37 UTC
(In reply to GregLou from comment #3)
> Послушай, я хз как эти необъяснимые глюки воспроизвести. То что глючит - это
> факт.

You just do something wrong. I see it in your description. If you still have that "problem" you can ask help on our RU forum https://forumooo.ru