/* ====================================================================
|
Licensed to the Apache Software Foundation (ASF) under one or more
|
contributor license agreements. See the NOTICE file distributed with
|
this work for Additional information regarding copyright ownership.
|
The ASF licenses this file to You under the Apache License, Version 2.0
|
(the "License"); you may not use this file except in compliance with
|
the License. You may obtain a copy of the License at
|
|
http://www.apache.org/licenses/LICENSE-2.0
|
|
Unless required by applicable law or agreed to in writing, software
|
distributed under the License is distributed on an "AS IS" BASIS,
|
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
See the License for the specific language governing permissions and
|
limitations under the License.
|
==================================================================== */
|
|
namespace HH.WMS.Utils.NPOI.SS.UserModel
|
{
|
using System;
|
/**
|
* Contains raw Excel error codes (as defined in OOO's excelfileformat.pdf (2.5.6)
|
*
|
* @author Michael Harhen
|
*/
|
public class ErrorConstants
|
{
|
protected ErrorConstants()
|
{
|
// no instances of this class
|
}
|
|
/** <b>#NULL!</b> - Intersection of two cell ranges is empty */
|
public const int ERROR_NULL = 0x00;
|
/** <b>#DIV/0!</b> - Division by zero */
|
public const int ERROR_DIV_0 = 0x07;
|
/** <b>#VALUE!</b> - Wrong type of operand */
|
public const int ERROR_VALUE = 0x0F;
|
/** <b>#REF!</b> - Illegal or deleted cell reference */
|
public const int ERROR_REF = 0x17;
|
/** <b>#NAME?</b> - Wrong function or range name */
|
public const int ERROR_NAME = 0x1D;
|
/** <b>#NUM!</b> - Value range overflow */
|
public const int ERROR_NUM = 0x24;
|
/** <b>#N/A</b> - Argument or function not available */
|
public const int ERROR_NA = 0x2A;
|
|
|
/**
|
* @return Standard Excel error literal for the specified error code.
|
* @throws ArgumentException if the specified error code is not one of the 7
|
* standard error codes
|
*/
|
public static String GetText(int errorCode)
|
{
|
switch (errorCode)
|
{
|
case ERROR_NULL: return "#NULL!";
|
case ERROR_DIV_0: return "#DIV/0!";
|
case ERROR_VALUE: return "#VALUE!";
|
case ERROR_REF: return "#REF!";
|
case ERROR_NAME: return "#NAME?";
|
case ERROR_NUM: return "#NUM!";
|
case ERROR_NA: return "#N/A";
|
}
|
throw new ArgumentException("Bad error code (" + errorCode + ")");
|
}
|
|
/**
|
* @return <c>true</c> if the specified error code is a standard Excel error code.
|
*/
|
public static bool IsValidCode(int errorCode)
|
{
|
// This method exists because it would be bad to force clients to catch
|
// ArgumentException if there were potential for passing an invalid error code.
|
switch (errorCode)
|
{
|
case ERROR_NULL:
|
case ERROR_DIV_0:
|
case ERROR_VALUE:
|
case ERROR_REF:
|
case ERROR_NAME:
|
case ERROR_NUM:
|
case ERROR_NA:
|
return true;
|
}
|
return false;
|
}
|
}
|
|
}
|
