The second table explains all of the error codes, listed by code number, including those errors codes in the first table. 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. Which raises another question: these values were already calculated before being saved, why are they being recalculated on open? I took pains to avoid volatile functions.Calc provides feedback for errors of miscalculation, incorrect use of functions, invalid cell references and values, and other user initiated mistakes. It’s pretty clear to me that, on open, there is a recalculation cycle that just craps out part way through. D) Recalculate can’t resolve a circular reference, so that wouldn’t work if it was real (iterative calculation is off).
If it was truly circular, they’d all have it. C) This sheet is a template, one of 7 identical sheet in the workbook, and only the last one (on the tab bar, but is also the most recently created) has this issue. B) I used Trace Precendent and it doesn’t indicate any circular references, only the existing linear ones. I saw recently somewhere on the internet a suggestion that turning off multi-threaded calculation resolves this issue. (FYI: On Ubuntu 18.04 the desktop appears to be intercepting F9 so only the menubar UI works.) Happens when I open my spreadsheet, Recalculate Hard (Shift+Ctrl+F9) resolves the issue. I’m seeing the same issue on Calc 7.3.3.2.
0 kommentar(er)
