Post by PaulPost 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
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
most of the formulae. Cheers.