Except in the case of the # error, they all correspond to a Calc error code number. This first table explains error messages which are displayed within the cell that actually contains the error. This appendix presents error codes in two tables.

For fuller explanations, consult the following tables and the Help topic, Error Codes in LibreOffice Calc. This message is more descriptive than the message displayed in the cell, but it still may not provide enough information to correctly diagnose the problem. When the cell displaying the #REF error code in Figure 1 is selected, the status bar displays the error message as shown in Figure 2. The date displayed within the input line,, would fit within the cell without a problem, but the format used by the cell produces the date value Sunday, April 05, 1998. Generally speaking, if the error occurs in the cell that is selected (or contains the cursor), the error message is displayed on the status bar.Īs an example, Figure 1 shows the error code returned when a column is too narrow to display the entire formatted date. The feedback may be displayed within the cell that contains the error (Figure 1) or on the status bar (Figure 2) or in both, depending on the type of error. Once you hit enter, you should see Error 522 in cell A2.Calc provides feedback for errors of miscalculation, incorrect use of functions, invalid cell references and values, and other user initiated mistakes.

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. 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. A simple and basic guide on how to fix error 522 in LibreOffice and OpenOffice.

Err 522 openoffice calc