Start generalising the IgnoredErrorType code for later HSSF use too #56892

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1730540 13f79535-47bb-0310-9956-ffa450edef68

1 files changed, 85 insertions, 0 deletions

diff --git a/src/ooxml/java/org/apache/poi/xssf/usermodel/helpers/XSSFIgnoredErrorHelper.java b/src/ooxml/java/org/apache/poi/xssf/usermodel/helpers/XSSFIgnoredErrorHelper.java
new file mode 100644
index 0000000000..4911a3532d
--- /dev/null
+++ b/src/ooxml/java/org/apache/poi/xssf/usermodel/helpers/XSSFIgnoredErrorHelper.java
@@ -0,0 +1,85 @@
+/* ====================================================================
+   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.
+==================================================================== */
+
+package org.apache.poi.xssf.usermodel.helpers;
+
+import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTIgnoredError;
+import org.apache.poi.ss.usermodel.IgnoredErrorType;
+
+/**
+ * XSSF-specific code for working with ignored errors
+ */
+public class XSSFIgnoredErrorHelper {
+    public static boolean isSet(IgnoredErrorType errorType, CTIgnoredError error) {
+        switch(errorType) {
+            case CALCULATED_COLUMN:
+                return error.isSetCalculatedColumn();
+            case EMPTY_CELL_REFERENCE:
+                return error.isSetEmptyCellReference();
+            case EVALUATION_ERROR:
+                return error.isSetEvalError();
+            case FORMULA:
+                return error.isSetFormula();
+            case FORMULA_RANGE:
+                return error.isSetFormulaRange();
+            case LIST_DATA_VALIDATION:
+                return error.isSetListDataValidation();
+            case NUMBER_STORED_AS_TEXT:
+                return error.isSetNumberStoredAsText();
+            case TWO_DIGIT_TEXT_YEAR:
+                return error.isSetTwoDigitTextYear();
+            case UNLOCKED_FORMULA:
+                return error.isSetUnlockedFormula();
+            default:
+                throw new IllegalStateException();
+            }
+    }
+    
+    public static void set(IgnoredErrorType errorType, CTIgnoredError error) {
+        switch(errorType) {
+        case CALCULATED_COLUMN:
+            error.setCalculatedColumn(true);
+            break;
+        case EMPTY_CELL_REFERENCE:
+            error.setEmptyCellReference(true);
+            break;
+        case EVALUATION_ERROR:
+            error.setEvalError(true);
+            break;
+        case FORMULA:
+            error.setFormula(true);
+            break;
+        case FORMULA_RANGE:
+            error.setFormulaRange(true);
+            break;
+        case LIST_DATA_VALIDATION:
+            error.setListDataValidation(true);
+            break;
+        case NUMBER_STORED_AS_TEXT:
+            error.setNumberStoredAsText(true);
+            break;
+        case TWO_DIGIT_TEXT_YEAR:
+            error.setTwoDigitTextYear(true);
+            break;
+        case UNLOCKED_FORMULA:
+            error.setUnlockedFormula(true);
+            break;
+        default:
+            throw new IllegalStateException();
+        }
+    }
+}