1 package org.simantics.spreadsheet.graph.formula;
\r
3 import java.util.HashMap;
\r
4 import java.util.Map;
\r
5 import org.apache.poi.util.Internal;
\r
6 import org.simantics.databoard.binding.mutable.Variant;
\r
8 public enum FormulaError2{
\r
10 _NO_ERROR(-1, "(no error)"),NULL(0x00, "#NULL"),DIV0(0x07,"#DIV/0!"),VALUE(0x0F,
\r
11 "#VALUE!"),REF(0x17,"#REF!"),NAME(0x1D,"#NAME?"),NUM(0x24,"#NUM!"),NA(0x2A, "#N/A"),
\r
12 CIRCULAR_REF(0xFFFFFFC4, "~CIRCULAR~REF~"),FUNCTION_NOT_IMPLEMENTED(0xFFFFFFE2,"~FUNCTION~NOT~IMPLEMENTED~");
\r
14 private final String text;
\r
15 //private final Integer longType;
\r
16 //private final byte shortType;
\r
18 private static Map<String, FormulaError2> smap = new HashMap<String, FormulaError2>();
\r
20 private FormulaError2(int type, String text){
\r
21 //this.longType = type;
\r
22 //this.shortType = (byte)type;
\r
27 for(FormulaError2 error : values()) {
\r
28 smap.put(error.getString(), error);
\r
32 public String getString(){
\r
36 public static FormulaError2 forString(String errorName){
\r
37 FormulaError2 err = smap.get(errorName);
\r
41 public static FormulaError2 forObject(Object errorObj){
\r
42 if(errorObj instanceof Variant)
\r
43 return forString(((Variant)errorObj).getValue().toString());
\r
45 return forString(errorObj.toString());
\r
48 public static String handleErrorCall(Object value){
\r
49 if(value==null) return VALUE.getString();
\r
50 FormulaError2 error = FormulaError2.forObject(value);
\r
51 if(error!=null) return error.getString();
\r
52 return VALUE.getString();
\r