Bug 161297 - working on a writer document with math formulas, writer crash, then formulas disappeard (logo puzzle replace it) and can not be recovered. The file was saved before but it is the same on file saved before
Summary: working on a writer document with math formulas, writer crash, then formulas ...
Status: RESOLVED DUPLICATE of bug 99225
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Formula Editor (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-27 16:09 UTC by granjon laurent
Modified: 2024-05-29 12:12 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
formulas doesn't appears anymore, "object xxx" replace it with puzzle logo (164.89 KB, image/png)
2024-05-27 20:09 UTC, granjon laurent
Details
the file which does not work (408.78 KB, application/vnd.oasis.opendocument.text)
2024-05-27 20:18 UTC, granjon laurent
Details
source file from which the .odt has been modified (401.39 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2024-05-28 12:08 UTC, granjon laurent
Details
an other document with the same problem (37.39 KB, application/vnd.oasis.opendocument.text)
2024-05-28 12:34 UTC, granjon laurent
Details

Note You need to log in before you can comment on or make changes to this bug.
Description granjon laurent 2024-05-27 16:09:18 UTC
Description:
It's the fourth time it happened to me
I was working on writer on LibreOffice 6.4.7.2 40(Build:2) 
running on a lubuntu (Linux Z210 5.4.0-182-generic #202-Ubuntu SMP Fri Apr 26 12:29:36 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux) 
I have saved a document again 
I have one "alert" (a formula has been modified and when i exit the formula to go to writer the modification has lost. I saved the document, and i saved again the document on a new name. 
then i worked on another formula. Libreoffice crashed. 
i launch again libreoffice
the recovery find a document but most of the formulas (not all of them) was replaced by a "puzzle" named "objet xxx" 
i close libreoffice again and reload it, trying opening my saved document. It's the same. 
The same on another computer with another libreoffice (on windows 10)

i can send you the files with problems if necessary

I haven't identify the cause of crash; but must of crashed formulas are copy of other existing formulas which has been modified before. 

sorry for the poor english, difficult for me to speak this language

IF the problem appear again and again i will have to quit libreoffice to another editor, formulas is vital for me (i have quit microsoft word because of bugs in formulas, and i find latex too complex to be used) 

Steps to Reproduce:
1.start a document writer
2.insert text & formulas in it
3.copy / paste / modify formulas
4. save document
5. modify formulas
6. save again
7. some times it crashs
8. reopen document (or use automatic recovery)
9. hurry & cry because hours of works are lost in the file 
10. go back to microsoft word or go to latex

Actual Results:
after crash, formulas are replaced by "object xxx" and cannot be modified or recovered again

Expected Results:
no crash, or, if crash, the formulas can be recovered (at least the text of the formula which can permise to regenerate it easily. Nothing can be saved, 


Reproducible: Always


User Profile Reset: No

Additional Info:
for three time on four it append to me, the file was modified from a micro$oft office one with formulas

Version : 6.4.7.2
Build ID : 1:6.4.7-0ubuntu0.20.04.9
Threads CPU : 4; OS : Linux 5.4; UI Render : par défaut; VCL: gtk3; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded
Comment 1 m_a_riosv 2024-05-27 18:21:01 UTC
Please test in safe mode, Menu/Help/Restart in Safe Mode

If it doesn't solve the issue, please test updating LibreOffice 6.4 is an old version (End Of Life).
Comment 2 granjon laurent 2024-05-27 20:09:48 UTC
Created attachment 194386 [details]
formulas doesn't appears anymore, "object xxx" replace it with puzzle logo

this is a screenshot of the problem
Comment 3 granjon laurent 2024-05-27 20:12:43 UTC
in safe mode it's the same, 
I'm on lubuntu 20.04 (focal) up to date

i have tried to install libreoffice 24 it does not work (bug 160388) it seems to have a dependancies problems (an icon theme which missing) so i can't try it on a newer version

since the file is corrupted it's impossible to recover it, it's the same on the windaube version on the laptop of my work, i'm unable to recover my work...
Comment 4 granjon laurent 2024-05-27 20:18:02 UTC
Created attachment 194387 [details]
the file which does not work

i send the file which does not work. i had search to recover the source code of the equations in it, but i had not find it (je suis ingénieur en mécanique, pas en informatique...) It would be very interesting for me to recover source code of equations when libreoffice crash, in order to recover my work. 

Please not that this file was converted from "docx" but i have also the problem whith native .odt files 

thank's for a future patch for this sort of bug,
Comment 5 QA Administrators 2024-05-28 03:14:03 UTC Comment hidden (obsolete)
Comment 6 granjon laurent 2024-05-28 11:35:29 UTC
file tested on windows (see above) it's the same

it semms that the file has been corrupted and no equations can be recovered from it. 

Version: 7.3.2.2 (x64) / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: CL
Comment 7 m_a_riosv 2024-05-28 11:55:10 UTC
The file doesn't have those empty OLE Objects.

Cleaning all empty OLE objects, and saving and reopening, the good formulas remain.

Tested with a new file, no issue found it.

As in the file properties, seems it was created on Word with Normal.dotm template.

Is this the file create with Word or was modified with LO?.

Can we have the file created with Word to test?
Comment 8 granjon laurent 2024-05-28 12:08:32 UTC
Created attachment 194400 [details]
source file from which the .odt has been modified

this was the file made with word by a colleague, modified with libreoffice (the file send before) 

thank's
Comment 9 granjon laurent 2024-05-28 12:34:03 UTC
Created attachment 194401 [details]
an other document with the same problem

This is an other document created by my wife under libreoffice on linux (ubuntu 20.04) but which could has been opened / writed and resend in odt format by another user using microsoft word (only a few number of users use libreoffice in her school) 

the same problem has appeared in april 2024 on this file. It has been done again from scratch on libreoffice without other problem

Note that i'm a very big user of libreoffice math (formulas) (thousand of page of documents and very big documents) and i have never had this sort of  bugs before 2024.

It seems that it appeared when a file was either generated first with microsoft word or have been modified with microsoft word even if it is a libreoffice file at it creation. 

The difficult is that it isn't always evident to know if a word user has modified a file
Comment 10 Stéphane Guillou (stragu) 2024-05-29 05:16:47 UTC
I think this is most likely bug 99225.
If you are able to provide steps that consistently reproduce the issue, it would be very helpful.
However, regarding the crash, do you get a crash report dialog? If you do, please submit and crash report and share the link to it here.
Thank you.
Comment 11 granjon laurent 2024-05-29 09:03:57 UTC
hello

thank's for your return. 
I have tried to replicate the bug yesterday in a simple file, but no crash and no equations problem, even with multiple "aller retour" between word and libreoffice. I would try to save a document just before and just after crash but difficult to make libreoffice crash

I make two or three documents per week using formulas, only four bug like this one (formulas disappears) since i have banned microsoft word in 2013-2014. Two of them in the two last month (the two document sended) 

I have tried for two hours to replicate the default it doesn't appears anymore. The action trigger ("élément déclencheur" en français) of the failure has not be identified for the moment. 

For crash report of libreoffice, i don't know where they are stocked in the system, and i have not take note of the number if sended to a server somewhere
Comment 12 Stéphane Guillou (stragu) 2024-05-29 11:35:24 UTC
Merci Laurent.

It does sounds as elusive as bug 99225. Looking at the unzipped files, the objects are indeed gone. Attachment 194387 [details] has a lot of formula objects, which is consistent with bug 99225, but attachment 194401 [details] only had 13, which is surprising.
It's also interesting that you think it might happen when files have previously been edited in MS Office.

If you find a way to replicate consistently, please do let us know.

Maybe turning on the Backup feature is a good idea, if you are worried about it happening again in the future (in Tools > Options > Load/Save).

(In reply to granjon laurent from comment #11)
> difficult to make libreoffice crash
That's good :D

> For crash report of libreoffice, i don't know where they are stocked in the
> system, and i have not take note of the number if sended to a server
> somewhere
Usually, after a crash, a dialog pops up when restarting, allowing you to send a crash report. If you accept, it will give you a URL, which you can paste here or in a new bug report.

*** This bug has been marked as a duplicate of bug 99225 ***
Comment 13 Stéphane Guillou (stragu) 2024-05-29 11:40:05 UTC
In any case, please update to a currently maintained version if you can, as the most recent version it was reported for is 7.3.
Comment 14 granjon laurent 2024-05-29 12:12:20 UTC
thank's for your return

i have tried to update on my ubuntu install to libreoffice 24 but there's a problem of dependancies (with qt5), i will migrate to 24.04 after the end of the school year, when all quizzes are corrected. On my professional computer i'm not admin and cannot do anything

I'm sure that at least three of the four case of this bug was on files which have been either created by microsoft office or modified with it. for the two i have attach with the bug it's the case (the first one was send as a .docx by a colleague i have attach the source too, the second one was a correction of an exam at the school of my wife, a collaborative works, and all her colleague are usually works with microsoft. There are a lot of issues on microsoft equations too, maybe the translation of equations from microsoft are a part of the source of the problem

I'm now attentive to report correctly the crash if the bug occurs again

thank's