Bug 158456 - FILEOPEN, FILESAVE. Corrupted ODS file opens slowly and increases in size after saving
Summary: FILEOPEN, FILESAVE. Corrupted ODS file opens slowly and increases in size aft...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:ods
Depends on:
Blocks:
 
Reported: 2023-11-30 10:56 UTC by Yevgeny
Modified: 2024-04-04 02:45 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
The problem file with which the bug is reproduced. + video (1.18 MB, application/x-7z-compressed)
2023-11-30 11:03 UTC, Yevgeny
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yevgeny 2023-11-30 10:56:33 UTC
Description:
The once corrupted small ods file takes longer than usual to open, and after saving it increases in size 25 times. Unfortunately, I have not been able to reproduce the process of obtaining such a corrupted file. This problem is only with this file.
All I know: the file was created about two or three years ago in the then-current LibreOfficeCalc program. It doesn't seem to have been edited since then, until today.
Tried in the Russian version and in the English version.

Steps to Reproduce:
1.Open the file.
2.Save the file.
3.

Actual Results:
The file takes a long time to open. After saving the file, it increases in size many times.

Expected Results:
The file opens quickly. The file size is of reasonable value.


Reproducible: Sometimes


User Profile Reset: Yes

Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded

The bug is reproduced in both Russian and English versions.
Comment 1 Yevgeny 2023-11-30 11:03:33 UTC
Created attachment 191137 [details]
The problem file with which the bug is reproduced. + video
Comment 2 Yevgeny 2023-12-01 09:07:49 UTC
Perhaps, parsing the structure of a strange corrupted file will give a clue to the reason for creating such a file?
But, mainly, solving the problem will help to exclude future program failures when opening incorrect ods files.
Comment 3 Yevgeny 2023-12-05 09:18:18 UTC
If you save the attached file in xls or xlsx format, the file size is reduced to an adequate value (14.5 and 8.4 kb, respectively).
Comment 4 wjsim 2024-03-18 16:19:44 UTC
A jump from 1.01 mb to 25.7 mb in your video is pretty crazy. However, I cannot reproduce the bug presented in the video.

I tested it with 

Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: ko-KR (en_US); UI: en-US
Calc: CL threaded

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 6a064b1967e06e40be40817deff99d00c1a8554f
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: ko-KR (en_US); UI: en-US
Calc: CL threaded

I tested it in both Korean and English.
Comment 5 Yevgeny 2024-03-18 17:16:50 UTC
Unfortunately, I have the bug reproduced in the latest version as well.

Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded
Comment 6 Yevgeny 2024-03-23 19:22:23 UTC
What is even more incredible is that on different computers with the same latest version of LO installed, the size of this unfortunate saved file is different!
In the previous examples and with the configuration specified in the comment 2024-03-18 17:16:50 UTC, the size of the save file was 25.7 MB.
On this computer, with the configuration below, the size of the saved file was 11.2 MB.

Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded
Comment 7 Armondo Lopez 2024-04-04 02:45:15 UTC
In both of these versions:

Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

and

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

The size of the file went from 1.02 MB to 11.2 MB.