Once you hit enter, you should see Error 522 in cell A2. In the cell A2, enter the following formula: =A1+A2 Open a LibreOffice or OpenOffice spreadsheet. The circular references mean you entered some formulas directly or indirectly referencing the result.Īs per the official reference, here’s the explanation: Formula refers directly or indirectly to itself and the Iterations option is not set under Tools - Options - LibreOffice Calc - Calculate. It applies to both the relative and absolute references. What is Error 522?Įrror 522 usually happens during circular references while using formulas. Here are the three most prominent reasons error 522 runtime errors occur: Error 522 Crash - It is called 'Error 522' when a program terminates unexpectedly while running (at runtime). This guide will see how to fix Error 522 (or Err:522) in LibreOffice. They are meant to tell you the reason for the error. It has some basic errors which are pre-defined. LibreOffice is one of the most popular software applications used for data analysis, financial modelling, and reporting. I've never had a problem with the spreadsheet, through various Lotus, MS, and Apache tools, over about 20 years, except for this silly error message.A simple and basic guide on how to fix error 522 in LibreOffice and OpenOffice. I left out some parts of my actual spreadsheet, where I track spending on maintenance and new bikes, accessories, or supplies. Then I bought some Assos shorts, which are expensive, and the shorts included a statement that they could last about 10,000 km, so I started tracking that.

Power meters came along, and I wanted to track battery life for those. Tire life has been of interest, so I calculate that. I used to climb more, so once the Garmin cycling computers came along that showed elevation gain, I wanted to keep track of that. Then, I got a second and a third bike, so I wanted to keep records for each one. I just started several years ago, adding up my rides so I could brag about how much cycling I did. Wow, Villeroy, I'm no expert with Calc, and I can't really understand what you did with the data! But I'll try to figure it out. Thanks to all of you for your time looking into my question! I am going to start over as you suggest.

Err 522 openoffice calc