[Solved] Repeating crash on opening specific file

[jordihuisman]

I've been using OpenOffice with great pleasure for years now. Recently I've been having repeating crashing with one very important .ods file. Opening any other file is not a problem, but opening this specific file always leads to a crash. I've tried copying the file to another location and opening +it from there, and I tried opening it on another computer. All with a crash as a result.
Here's the error message:
Process: soffice [1002]
Path: /Applications/OpenOffice.app/Contents/MacOS/soffice
Identifier: org.openoffice.script
Version: 4.1.6 (???)
Code Type: X86-64 (Native)
Parent Process: ??? [1]
Responsible: soffice [1002]
User ID: 502

Date/Time: 2019-08-04 19:07:40.612 +0200
OS Version: Mac OS X 10.14.5 (18F132)
Report Version: 12
Bridge OS Version: 3.5 (16P5125)
Anonymous UUID: 060D9A43-5268-6C6F-9B36-EAFC29F303C1


Time Awake Since Boot: 1000 seconds

System Integrity Protection: enabled

Crashed Thread: 0 Dispatch queue: com.apple.main-thread

Exception Type: EXC_BAD_ACCESS (SIGSEGV)
Exception Codes: KERN_INVALID_ADDRESS at 0x0000000000000008
Exception Note: EXC_CORPSE_NOTIFY

Termination Signal: Segmentation fault: 11
Termination Reason: Namespace SIGNAL, Code 0xb
Terminating Process: exc handler [1002]

VM Regions Near 0x8:
-->
__TEXT 000000010d080000-000000010d081000 [ 4K] r-x/rwx SM=COW /Applications/OpenOffice.app/Contents/MacOS/soffice



Does anyone have an idea how to fix this? Do you need more lines from the error message? Please advise what to do!

[RoryOF]

The symptoms suggest an internal error in the file. Can you make it available for examination?

[jordihuisman]

It has my company’s finances in it, so I’m a bit hesitant to make it public. I can email it to you though.

[RoryOF]

Perhaps not to me, as I am not a Calc expert; some other volunteer may offer.

[John_Ha]

It has my company’s finances in it ...

Heavily edited files (File > Properties > General ..., shows how many times a file has been edited) often seem to get "tangled" where I don't really know what "tangled" means apart from the fact that "tangles" can often be removed and the file made more responsive by:

1. Start AOO
2. File > New > Spreadsheet. This creates a new, empty spreadsheet
3. Insert > Sheet from file. Navigate to the problem file and select it. Select all the sheets in the file.
4. File > Save as ..., and save with a new name.

If that does not work I will be happy to look at the file for you and I have sent you an email with my ID.

Another thought, though much less likely as the file fails on different PCs. Strange problems are sometimes fixed by resetting the profile - see Resetting the user profile.

As always in cases like this it is a good idea to ask Mrs Google what she knows about the error messages - searching with EXC_BAD_ACCESS (SIGSEGV) mac found EXC_BAD_ACCESS (SIGSEGV) and KERN_INVALID_ADDRESS.

[RusselB]

I agree with John_Ha. I, also, would be willing to look at the file if the OP wants to e-mail it to me.
While I don't have a Mac currently, I will be getting a used one shortly, and will be able to examine the file under both PC and Mac infrastructures...just in case there's a difference in how the file is handled.

[RoryOF]

It can happen that a file is unstable on one operating system, but will open correctly on another and a saved version from that will then be stable on the original computer, so I wouldn't worry about not yet having a Mac, RusselB.

One of the things this shows is the need for regular timed/dated backups, as provided by this extension:

You can download it from
http://flowcont.hu/LO_oxt_store/

Note that you must invoke it separately using its button; it does not replace the standard save mechanism.

Edit: URL updated to point to later version of extension. This extension will work on both OpenOffice and LibreOffice.

[John_Ha]

jordihuisman sent me the file for analysis. I replied with following email:

Jordi

There is something very strange happening here. I did the following

1. Opened the file with AOO. It crashed and did not recover

2. Extracted content.xml from the .ods file - it is the content. I checked the XML syntax and it was OK so no error in the XML.

3. Opened the file with LibreOffice and it opened!

4. Saved the file with LO as 2019kostenverkopen_saved by LO.ods. Opened 2019kostenverkopen_saved by LO.ods with AOO and it opened. I then saved it as 2019kostenverkopen_saved by LO_then saved by AOO.ods. 2019kostenverkopen_saved by LO_then saved by AOO.ods then opened fine with AOO.

I have no idea what is causing the problem but I hope this gives you the file back.

Edit: A thought. It could be that LO has a better error handling capability than AOO which allows LO to open the file whereas AOO fails.

Some words of advice.

1. Install the Timestamp Backup extension which is designed for LO but (2018) works with AOO. When you use it, every time you save your file, you save it as normal but, in addition, you save a time stamped version of it in a separate backup folder. You need to delete older versions in the backup folder yourself.

2. AOO is effectively dead as there are few/no developers working on it and as time goes by it will get further and further behind. Your company should look at migrating to LIbreOffice which is still under active development.

3. Check the file carefully in case something has gone missing or has been changed

4. See [Tutorial] How to find and un-delete AOO temporary files for detailed instructions on how to

a) use Previous Versions (W7 and later) to recover previous versions of the file (is there something similar on MacOS and Linux?);

b) recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery;

c) find previous versions of the file in the folder it is located in, but which have since been deleted;

d) un-delete the temporary files AOO wrote while you were editing the file, and then deleted. This will recover your file as it was when you last opened or you last saved it.

This may get you back the actual file as it was before it crashed.

5. This is File > Properties..., where you can see the file has been heavily edited. It is a good idea to do the Insert > File ..., or even copy the sheets into as new file to try and clear the "tangles". Search the Writer forum with tangled or tangle to see some comments.

I then looked at the file sizes for the three files. The original was 77kB, when opened and saved by LO it was 76 kB but when that file was opened and saved by AOO it reduced to 69kB.

Clipboard02.png (7.65 KiB) Viewed 3609 times

I then unzipped each of the .ods files to look at their component files and got the following results. I do not know how to interpret them.

[John_Ha]

Note that you must invoke it [Timestamp Backup] separately using its button; it does not replace the standard save mechanism.

Rory

It should be possible to use Tools > Customise > Events > Save document ..., to invoke the extension each time the document (or spreadsheet) is closed.

Alternatively, edit the Toolbar and File menu to remove the standard Save and Save As commands, and replace them with Timestamp Backup.

[RoryOF]

I agree, but out of the box it is not so linked.

[John_Ha]

I examined content.xml in the original file. The only thing which looked strange (there are 30,000 lines so my search was cursory) are the last few lines which include multiple #verw!

Code: Select all

<table:named-expressions>
	<table:named-range table:name="_xlnm._FilterDatabase" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$activa.$A$23:.$V$64"/>
	<table:named-range table:name="BTWamount" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$I$1:.$I$65428"/>
	<table:named-range table:name="BTWpercent" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$E$1:.$E$65429"/>
	<table:named-range table:name="categories" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$J$3:.$U$3"/>
	<table:named-range table:name="Category" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$F$1:.$F$65429"/>
	<table:named-range table:name="CategoryInputRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$F$198:.$F$300"/>
	<table:named-expression table:name="Datum" table:base-cell-address="$Overzicht.$A$1" table:expression="$kostenboek.$#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#VERW!$1:$#VERW!$65428"/>
	<table:named-range table:name="Excel_BuiltIn__FilterDatabase_2" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$3:.$W$302"/>
	<table:named-expression table:name="Excel_BuiltIn_Print_Titles_2" table:base-cell-address="$Overzicht.$A$1" table:expression="([$Kostenboek.$A$1:.$E$65429]~[$Kostenboek.$A$2:.$IO$2])"/>
	<table:named-range table:name="FirstNumber" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$4"/>
	<table:named-range table:name="InputRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$B$4:.$F$300"/>
	<table:named-range table:name="Net" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$H$1:.$H$65428"/>
	<table:named-range table:name="Nummer" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$1:.$A$65428"/>
	<table:named-range table:name="Omschrijving" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$C$1:.$C$65429"/>
	<table:named-range table:name="PercentInputRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$E$5:.$E$300"/>
	<table:named-range table:name="Period" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$C$2"/>
	<table:named-range table:name="PeriodRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$2:.$C$2"/>
	<table:named-expression table:name="_xlnm.Print_Titles" table:base-cell-address="$Overzicht.$A$1" table:expression="([$Kostenboek.$A$1:.$E$1048549]~[$Kostenboek.$A$2:.$AMI$2])"/>
	<table:named-range table:name="titles" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$3:.$IO$3"/>
	<table:named-range table:name="Totaal" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$D$1:.$D$65429"/>
</table:named-expressions>

In the file saved by LO they were still there.

Code: Select all

<table:named-expressions>
	<table:named-range table:name="BTWamount" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$I$1:.$I$65428"/>
	<table:named-range table:name="BTWpercent" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$E$1:.$E$65429"/>
	<table:named-range table:name="categories" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$J$3:.$U$3"/>
	<table:named-range table:name="Category" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$F$1:.$F$65429"/>
	<table:named-range table:name="CategoryInputRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$F$198:.$F$300"/>
	<table:named-expression table:name="Datum" table:base-cell-address="$Overzicht.$A$1" table:expression="$kostenboek.$#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#REF!:$#VERW!$65428"/>
	<table:named-expression table:name="Excel_BuiltIn_Print_Titles_2" table:base-cell-address="$Overzicht.$A$1" table:expression="([$Kostenboek.$A$1:.$E$65429]~[$Kostenboek.$A$2:.$IO$2])"/>
	<table:named-range table:name="Excel_BuiltIn__FilterDatabase_2" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$3:.$W$302"/>
	<table:named-range table:name="FirstNumber" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$4"/>
	<table:named-range table:name="InputRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$B$4:.$F$300"/>
	<table:named-range table:name="Net" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$H$1:.$H$65428"/>
	<table:named-range table:name="Nummer" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$1:.$A$65428"/>
	<table:named-range table:name="Omschrijving" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$C$1:.$C$65429"/>
	<table:named-range table:name="PercentInputRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$E$5:.$E$300"/>
	<table:named-range table:name="Period" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$C$2"/>
	<table:named-range table:name="PeriodRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$2:.$C$2"/>
	<table:named-range table:name="titles" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$3:.$IO$3"/>
	<table:named-range table:name="Totaal" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$D$1:.$D$65429"/>
	<table:named-expression table:name="_xlnm.Print_Titles" table:base-cell-address="$Overzicht.$A$1" table:expression="([$Kostenboek.$A$1:.$E$1048549]~[$Kostenboek.$A$2:.$AMI$2])"/>
	<table:named-range table:name="_xlnm._FilterDatabase" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$activa.$A$23:.$V$64"/>
</table:named-expressions>

They were also still there in the saved by LO then saved by AOO file.

Code: Select all

<table:named-expressions>
	<table:named-range table:name="BTWamount" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$I$1:.$I$65428"/>
	<table:named-range table:name="BTWpercent" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$E$1:.$E$65429"/>
	<table:named-range table:name="categories" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$J$3:.$U$3"/>
	<table:named-range table:name="Category" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$F$1:.$F$65429"/>
	<table:named-range table:name="CategoryInputRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$F$198:.$F$300"/>
	<table:named-expression table:name="Datum" table:base-cell-address="$Overzicht.$A$1" table:expression="$kostenboek.$#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#verw!#ref!"/>
	<table:named-expression table:name="Excel_BuiltIn_Print_Titles_2" table:base-cell-address="$Overzicht.$A$1" table:expression="([$Kostenboek.$A$1:.$E$65429]~[$Kostenboek.$A$2:.$IO$2])"/>
	<table:named-range table:name="Excel_BuiltIn__FilterDatabase_2" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$3:.$W$302"/>
	<table:named-range table:name="FirstNumber" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$4"/>
	<table:named-range table:name="InputRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$B$4:.$F$300"/>
	<table:named-range table:name="Net" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$H$1:.$H$65428"/>
	<table:named-range table:name="Nummer" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$1:.$A$65428"/>
	<table:named-range table:name="Omschrijving" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$C$1:.$C$65429"/>
	<table:named-range table:name="PercentInputRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$E$5:.$E$300"/>
	<table:named-range table:name="Period" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$C$2"/>
	<table:named-range table:name="PeriodRange" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$2:.$C$2"/>
	<table:named-range table:name="titles" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$A$3:.$IO$3"/>
	<table:named-range table:name="Totaal" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$Kostenboek.$D$1:.$D$65429"/>
	<table:named-expression table:name="_xlnm.Print_Titles" table:base-cell-address="$Overzicht.$A$1" table:expression="([$Kostenboek.$A$1:.$E$1048549]~[$Kostenboek.$A$2:.$AMI$2])"/>
	<table:named-range table:name="_xlnm._FilterDatabase" table:base-cell-address="$Overzicht.$A$1" table:cell-range-address="$activa.$A$23:.$V$64"/>
</table:named-expressions>

[John_Ha]

Examination of the file as opened by LO shows errors in the 5th sheet Voorraad.

[jordihuisman]

This is a bit above my knowledge and experience, but opening and saving it in LibreOffice worked. I have a functioning spreadsheet again, thanks ever so much John!

[RusselB]

This is a bit above my knowledge and experience, but opening and saving it in LibreOffice worked. I have a functioning spreadsheet again, thanks ever so much John!

Don't worry, That's why you go to "experts". We all started at the beginning...some of us have just obtained, for one reason or another, additional knowledge and skills, which, in turn, we use to help people like you, that do not have the knowledge and/or skills.