]> gerrit.simantics Code Review - simantics/platform.git/blob - bundles/org.simantics.spreadsheet.graph/src/org/simantics/spreadsheet/graph/formula/FormulaError2.java
SpreadsheetCells with Circular References support iterations.
[simantics/platform.git] / bundles / org.simantics.spreadsheet.graph / src / org / simantics / spreadsheet / graph / formula / FormulaError2.java
1 package org.simantics.spreadsheet.graph.formula;\r
2 \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
7 \r
8 public enum FormulaError2{\r
9         @Internal\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
13         \r
14         private final String text;\r
15         //private final Integer longType;\r
16         //private final byte shortType;\r
17         \r
18         private static Map<String, FormulaError2> smap = new HashMap<String, FormulaError2>();\r
19         \r
20         private FormulaError2(int type, String text){\r
21                 //this.longType = type;\r
22                 //this.shortType = (byte)type;\r
23                 this.text = text;\r
24         }\r
25         \r
26         static {\r
27                 for(FormulaError2 error : values()) {\r
28                         smap.put(error.getString(), error);\r
29                 }\r
30         }\r
31         \r
32         public String getString(){\r
33                 return this.text;\r
34         }\r
35         \r
36         public static FormulaError2 forString(String errorName){\r
37         FormulaError2 err = smap.get(errorName);\r
38         return err;\r
39     }\r
40         \r
41         public static FormulaError2 forObject(Object errorObj){\r
42                 if(errorObj instanceof Variant)\r
43                         return forString(((Variant)errorObj).getValue().toString());\r
44                 else\r
45                         return forString(errorObj.toString());\r
46         }\r
47         \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
53         }\r
54 }