Bug 158458 - FILESAVE : after closing the file it contains unrecognizable garbage
Summary: FILESAVE : after closing the file it contains unrecognizable garbage
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.8.2 release
Hardware: x86-64 (AMD64) macOS (All)
: medium normal
Assignee: Not Assigned
URL: https://ask.libreoffice.org/t/libreof...
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-11-30 11:41 UTC by Matthias Mittelstein
Modified: 2023-12-06 22:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
How a file looks after reopening (218.79 KB, image/png)
2023-11-30 11:41 UTC, Matthias Mittelstein
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Matthias Mittelstein 2023-11-30 11:41:12 UTC
Created attachment 191139 [details]
How a file looks after reopening

Sometime files are destroyed when I save them.
It happened on four files until now.

I am using CALC. The spreadsheets have a couple of pages, some 50 columns and up to 1600 rows. I save as .ods-files. And sometimes I create .pdf-files.

Last time I was very careful:
Working with LibreOffice 7.5.8 on Mac with Intel-CPU and MacOS 10.15.7
1. save file
   The directory is on a external USB disk drive.
2. close file
3. close LibreOffice
4. disconnect disk drive in Finder
5. shut down MacOS
6. switch of disk drive
7. disconnect USB cable

When I try to open that file later on Mac it shows unrecognisable content. See attached screen shot. When I try to open the file with LibreOffice on a Win-PC it says that the file is damaged and cannot be repaired.
Comment 1 Stéphane Guillou (stragu) 2023-12-01 14:43:41 UTC
Your screenshot shows the ODS file opened in Writer.
How do you open the file? What happens if you open the file directly from Calc?
Does it always happen on the same drive? Could it be a hardware failure?
Please attach a sample file if you can, and share the full version information copied from LibreOffice > About LibreOffice.
Comment 2 Matthias Mittelstein 2023-12-03 13:48:55 UTC
How to open ?
I normally open such files with double-click in file-manager resp Finder.
Sometime I use "Zuletzt verwendete Dokumente" (recently used documents)
In both cases LibreOffice chooses Write even with a .ods-filename.

From Calc ?
If I first use ->Datei->neu->Tabellendokument and then ->Datei-Öffnen... LibreOffice seems to be in "Calc"-mode. Then it shows the text-import dialog.

Drive ? Hardware ?
In all four cases it was the same disk and it happened when working on Mac. And all damaged file I saw until now had been .ods .
I know that does not prove anything.
It could be hardware...
It could be software or firmware not flushing the contents from cache to disk.
It could be LibreOffice...

Example file ?
Sorry.
If you would be able to restore contents of the files they contain bank account numbers, address, bank account histories, telephone numbers,...

version ?
One or two errors happened with a newer version 7.6....
Then I installed the "has been tested for longer" release and it happened again:
Version: 7.5.8.2 (X86_64) / LibreOffice Community
Build ID: f718d63693263970429a68f568db6046aaa9df01
CPU threads: 4; OS: Mac OS X 10.15.7; UI render: default; VCL: osx
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded


Recognizable strings in one of the damaged files:
mimetypePK
Configurations2/toolpanel/PK
Configurations2/progressbar/PK
Configurations2/popupmenu/PK
Configurations2/statusbar/PK
Configurations2/floater/PK
Configurations2/menubar/PK
Configurations2/toolbar/PK
Configurations2/images/Bitmaps/PK
Configurations2/accelerator/PK
manifest.rdfPK
settings.xmlPK
Thumbnails/thumbnail.pngPK
meta.xmlPK
styles.xmlPK
META-INF/manifest.xmlPK
content.xmlPK
mimetypeapplication/vnd.oasis.opendocument.spreadsheetPK
Configurations2/toolbar/PK
Configurations2/statusbar/PK
Configurations2/floater/PK
Configurations2/menubar/PK
Configurations2/popupmenu/PK
Configurations2/progressbar/PK
Configurations2/toolpanel/PK
Configurations2/accelerator/PK
Configurations2/images/Bitmaps/PK
manifest.rdf
settings.xml
Thumbnails/thumbnail.png
Comment 3 QA Administrators 2023-12-04 03:18:22 UTC Comment hidden (obsolete)
Comment 4 Stéphane Guillou (stragu) 2023-12-04 10:59:22 UTC
Looks similar to https://forum.openoffice.org/en/forum/viewtopic.php?t=105083 and https://ask.libreoffice.org/t/libreoffice-6-4-is-trying-to-open-an-ods-file-in-writer/58508

I would say that your thumb drive is failing and corrupts the file. You can test saving files to another storage device and on the mac itself to see if it only happens on that device.
Are other files, unrelated to LibreOffice, also corrupt on that drive?
Comment 5 QA Administrators 2023-12-05 03:18:49 UTC Comment hidden (obsolete)