Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc User Guide
Previous Page Home Next Page

Calc error codes

Calc provides feedback for errors of miscalculation, incorrect use of functions, invalid cell references and values, and other user initiated mistakes. The feedback may be displayed within the cell that contains the error (Figure 131) or on the Status Bar (Figure 132) or in both depending on the type of error. 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.

As an example, Figure 131 shows the error code returned when a column is too narrow to display the entire formatted date.The date displayed within the Input Line, 04/05/1998, would fit within the cell without a problem, but the format used by the cell produces the date value “Sunday, April 05, 1998â€.


When the cell displaying the #REF error code in Figure 131 is selected, the Status Bar displays the error message as shown in Figure 132.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.For fuller explanations, consult the following tables and the online help topic, Error Codes in Calc.


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

OpenOffice Calc User Guide
Previous Page Home Next Page

  Published under the terms of the Open Publication License Design by Interspire