libreoffice formulae not editable after reboot

[duncan smith]

Hello,
I closed an .odt file down yesterday, before rebooting (to
complete an update). Today I re-opened the file and found that formulae
are no longer editable. The problematic file gives me no option for
editing under the right click menu and the editor doesn't open on double
clicking. I can add new equations which work as expected. But I have *a
lot* of quite complex existing equations that will take a long time to
recreate.

I also note that none of my documents (editable formulae or otherwise)
can be exported to LaTex with Writer2LaTex (from File -> Export...) any
longer.

"""
Error saving the document notes:
General Error.
General input/output error.
"""

Any help would be appreciated. TIA.

Duncan

Libreoffice 6.4.6.2
Ubuntu 20.04

[Mike Easter]

Post by duncan smith
I closed an .odt file down yesterday, before rebooting (to
complete an update). Today I re-opened the file and found that formulae
are no longer editable.

Ub 20.10 LO is 7.0.2. Maybe there is a compatibility problem w/ some
features of some docs of an earlier v. There is a newer OpenDocument 1.3.

https://wiki.documentfoundation.org/ReleaseNotes/7.0#Changed_spreadsheet_functions
Changed spreadsheet functions

[duncan smith]

  I closed an .odt file down yesterday, before rebooting (to
complete an update). Today I re-opened the file and found that formulae
are no longer editable.

Ub 20.10 LO is 7.0.2.  Maybe there is a compatibility problem w/ some
features of some docs of an earlier v.  There is a newer OpenDocument 1.3.
https://wiki.documentfoundation.org/ReleaseNotes/7.0#Changed_spreadsheet_functions
 Changed spreadsheet functions

I found an earlier version of the file on my laptop (which fortunately
contains most of the formulae). That opens fine with editable formulae
(same versions of Ubuntu / LibreOffice).

I also installed Writer2LaTex from the repos, but that doesn't show up
as an option for export.

So I'm guessing the file has somehow become corrupted, and I have a
compatibility problem with LO / Writer2LaTex. Cheers.

Duncan

[Paul]

Post by duncan smith

Post by Mike Easter

Post by duncan smith
I closed an .odt file down yesterday, before rebooting (to
complete an update). Today I re-opened the file and found that formulae
are no longer editable.

Ub 20.10 LO is 7.0.2. Maybe there is a compatibility problem w/ some
features of some docs of an earlier v. There is a newer OpenDocument 1.3.
https://wiki.documentfoundation.org/ReleaseNotes/7.0#Changed_spreadsheet_functions
Changed spreadsheet functions

I found an earlier version of the file on my laptop (which fortunately
contains most of the formulae). That opens fine with editable formulae
(same versions of Ubuntu / LibreOffice).
I also installed Writer2LaTex from the repos, but that doesn't show up
as an option for export.
So I'm guessing the file has somehow become corrupted, and I have a
compatibility problem with LO / Writer2LaTex. Cheers.
Duncan

Document files now, modern ones, can be similar to Java .jar
files. They're a ZIP with a lot of stuff inside. Some of the
files are XML files, which could be storing settings.

For example, I can apply 7ZIP, to drill into this file
and show the structure inside. A person can "Extract",
with the equivalent of Archive Manager, what's in there.
For a writer document, for example, there might be a
folder with Images in it.

beer-manufacturers-microbrewers-brands.xlsx

Unpacked into L:\TEMP

01/01/1980 12:00 AM 2,208 [Content_Types].xml
12/08/2020 10:51 AM <DIR> _rels
12/08/2020 10:51 AM <DIR> xl
12/08/2020 10:51 AM <DIR> customXml
12/08/2020 10:51 AM <DIR> docProps

Directory of L:\TEMP\_rels

01/01/1980 12:00 AM 735 .rels

Directory of L:\TEMP\xl <=== Excel specific section

01/01/1980 12:00 AM 1,656 workbook.xml
12/08/2020 10:51 AM <DIR> _rels
12/08/2020 10:51 AM <DIR> worksheets
12/08/2020 10:51 AM <DIR> theme
01/01/1980 12:00 AM 17,644 styles.xml
01/01/1980 12:00 AM 68,866 sharedStrings.xml
01/01/1980 12:00 AM 907 connections.xml
12/08/2020 10:51 AM <DIR> printerSettings
12/08/2020 10:51 AM <DIR> tables
12/08/2020 10:51 AM <DIR> queryTables

Directory of L:\TEMP\xl\_rels

01/01/1980 12:00 AM 1,261 workbook.xml.rels

Directory of L:\TEMP\xl\worksheets

01/01/1980 12:00 AM 240,701 sheet1.xml
12/08/2020 10:51 AM <DIR> _rels

Directory of L:\TEMP\xl\worksheets\_rels

01/01/1980 12:00 AM 458 sheet1.xml.rels

Directory of L:\TEMP\xl\theme

01/01/1980 12:00 AM 8,390 theme1.xml

Directory of L:\TEMP\xl\printerSettings

01/01/1980 12:00 AM 4,840 printerSettings1.bin

Directory of L:\TEMP\xl\tables

01/01/1980 12:00 AM 825 table1.xml
12/08/2020 10:51 AM <DIR> _rels

Directory of L:\TEMP\xl\tables\_rels

01/01/1980 12:00 AM 308 table1.xml.rels

Directory of L:\TEMP\xl\queryTables

01/01/1980 12:00 AM 849 queryTable1.xml

Directory of L:\TEMP\customXml

01/01/1980 12:00 AM 12,341 item1.xml
01/01/1980 12:00 AM 1,149 itemProps1.xml
01/01/1980 12:00 AM 219 item2.xml
01/01/1980 12:00 AM 335 itemProps2.xml
01/01/1980 12:00 AM 290 item3.xml
01/01/1980 12:00 AM 954 itemProps3.xml
12/08/2020 10:51 AM <DIR> _rels

Directory of L:\TEMP\customXml\_rels

01/01/1980 12:00 AM 296 item1.xml.rels
01/01/1980 12:00 AM 296 item2.xml.rels
01/01/1980 12:00 AM 296 item3.xml.rels

Directory of L:\TEMP\docProps

01/01/1980 12:00 AM 645 core.xml
01/01/1980 12:00 AM 791 app.xml
01/01/1980 12:00 AM 2,071 custom.xml

*******

Your equations likely follow some standard type,
like MML or something (Math Markup Language).
And so you'd do a content search within the
unpacked item, for a string like that.

According to this, it's "MathML".

https://documentation.libreoffice.org/assets/Uploads/Documentation/en/GS5.1/HTML/GS5109-GettingStartedWithMath.html

The suggestion here, is it's something in your profile.
If that were the case, to my way of thinking, then all
documents with MathML would be affected at the same time.
The suggestion here is for another OS, but the
tool should still tell you where the profile is stored.
It could be yours is in a dot dir in your home directory.
The tool will tell you when you get there.

https://ask.libreoffice.org/en/question/86/how-to-insert-a-formulamath/

"When you go to Tools > Options > LibreOffice > Path.

There should be one that goes like C:\users\YOUR_USER_NAME\AppData\Roaming

Close all instances of Libre office and backup this folder,
then delete it. You will need to start libre office writer twice
and it should let you use the formulas again."

Paul

[duncan smith]

Post by Paul

Post by duncan smith

  I closed an .odt file down yesterday, before rebooting (to
complete an update). Today I re-opened the file and found that formulae
are no longer editable.

Ub 20.10 LO is 7.0.2.  Maybe there is a compatibility problem w/ some
features of some docs of an earlier v.  There is a newer OpenDocument 1.3.
https://wiki.documentfoundation.org/ReleaseNotes/7.0#Changed_spreadsheet_functions
 Changed spreadsheet functions

I found an earlier version of the file on my laptop (which fortunately
contains most of the formulae). That opens fine with editable formulae
(same versions of Ubuntu / LibreOffice).
I also installed Writer2LaTex from the repos, but that doesn't show up
as an option for export.
So I'm guessing the file has somehow become corrupted, and I have a
compatibility problem with LO / Writer2LaTex. Cheers.
Duncan

Document files now, modern ones, can be similar to Java .jar
files. They're a ZIP with a lot of stuff inside. Some of the
files are XML files, which could be storing settings.
For example, I can apply 7ZIP, to drill into this file
and show the structure inside. A person can "Extract",
with the equivalent of Archive Manager, what's in there.
For a writer document, for example, there might be a
folder with Images in it.
beer-manufacturers-microbrewers-brands.xlsx
 Unpacked into L:\TEMP
01/01/1980  12:00 AM             2,208 [Content_Types].xml
12/08/2020  10:51 AM    <DIR>          _rels
12/08/2020  10:51 AM    <DIR>          xl
12/08/2020  10:51 AM    <DIR>          customXml
12/08/2020  10:51 AM    <DIR>          docProps
 Directory of L:\TEMP\_rels
01/01/1980  12:00 AM               735 .rels
 Directory of L:\TEMP\xl    <=== Excel specific section
01/01/1980  12:00 AM             1,656 workbook.xml
12/08/2020  10:51 AM    <DIR>          _rels
12/08/2020  10:51 AM    <DIR>          worksheets
12/08/2020  10:51 AM    <DIR>          theme
01/01/1980  12:00 AM            17,644 styles.xml
01/01/1980  12:00 AM            68,866 sharedStrings.xml
01/01/1980  12:00 AM               907 connections.xml
12/08/2020  10:51 AM    <DIR>          printerSettings
12/08/2020  10:51 AM    <DIR>          tables
12/08/2020  10:51 AM    <DIR>          queryTables
 Directory of L:\TEMP\xl\_rels
01/01/1980  12:00 AM             1,261 workbook.xml.rels
 Directory of L:\TEMP\xl\worksheets
01/01/1980  12:00 AM           240,701 sheet1.xml
12/08/2020  10:51 AM    <DIR>          _rels
 Directory of L:\TEMP\xl\worksheets\_rels
01/01/1980  12:00 AM               458 sheet1.xml.rels
 Directory of L:\TEMP\xl\theme
01/01/1980  12:00 AM             8,390 theme1.xml
 Directory of L:\TEMP\xl\printerSettings
01/01/1980  12:00 AM             4,840 printerSettings1.bin
 Directory of L:\TEMP\xl\tables
01/01/1980  12:00 AM               825 table1.xml
12/08/2020  10:51 AM    <DIR>          _rels
 Directory of L:\TEMP\xl\tables\_rels
01/01/1980  12:00 AM               308 table1.xml.rels
 Directory of L:\TEMP\xl\queryTables
01/01/1980  12:00 AM               849 queryTable1.xml
 Directory of L:\TEMP\customXml
01/01/1980  12:00 AM            12,341 item1.xml
01/01/1980  12:00 AM             1,149 itemProps1.xml
01/01/1980  12:00 AM               219 item2.xml
01/01/1980  12:00 AM               335 itemProps2.xml
01/01/1980  12:00 AM               290 item3.xml
01/01/1980  12:00 AM               954 itemProps3.xml
12/08/2020  10:51 AM    <DIR>          _rels
 Directory of L:\TEMP\customXml\_rels
01/01/1980  12:00 AM               296 item1.xml.rels
01/01/1980  12:00 AM               296 item2.xml.rels
01/01/1980  12:00 AM               296 item3.xml.rels
 Directory of L:\TEMP\docProps
01/01/1980  12:00 AM               645 core.xml
01/01/1980  12:00 AM               791 app.xml
01/01/1980  12:00 AM             2,071 custom.xml
*******
Your equations likely follow some standard type,
like MML or something (Math Markup Language).
And so you'd do a content search within the
unpacked item, for a string like that.
According to this, it's "MathML".
https://documentation.libreoffice.org/assets/Uploads/Documentation/en/GS5.1/HTML/GS5109-GettingStartedWithMath.html
The suggestion here, is it's something in your profile.
If that were the case, to my way of thinking, then all
documents with MathML would be affected at the same time.
The suggestion here is for another OS, but the
tool should still tell you where the profile is stored.
It could be yours is in a dot dir in your home directory.
The tool will tell you when you get there.
https://ask.libreoffice.org/en/question/86/how-to-insert-a-formulamath/
   "When you go to Tools > Options > LibreOffice > Path.
    There should be one that goes like
C:\users\YOUR_USER_NAME\AppData\Roaming
    Close all instances of Libre office and backup this folder,
    then delete it. You will need to start libre office writer twice
    and it should let you use the formulas again."
   Paul

I opened the file alongside a working file in Archive Manager yesterday,
and didn't notice any obvious difference. Checking again today there is
a difference. Both contain ObjectReplacements directories containing
images for the formulae. The good file also contains directories (named
like Object X) containing the MathML for the Xth formula. These
directories are missing for the problematic file. So it looks like the
relevant data has gone, but fortunately I have a backup that contains
most of the formulae. Cheers.

Duncan