| /* |
| * ==================================================================== |
| * 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; |
| |
| import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfvo; |
| import org.openxmlformats.schemas.spreadsheetml.x2006.main.STCfvoType; |
| |
| /** |
| * High level representation for Icon / Multi-State / Databar / |
| * Colour Scale change thresholds |
| */ |
| public class XSSFConditionalFormattingThreshold implements org.apache.poi.ss.usermodel.ConditionalFormattingThreshold { |
| private CTCfvo cfvo; |
| |
| protected XSSFConditionalFormattingThreshold(CTCfvo cfvo) { |
| this.cfvo = cfvo; |
| } |
| |
| protected CTCfvo getCTCfvo() { |
| return cfvo; |
| } |
| |
| public RangeType getRangeType() { |
| return RangeType.byName(cfvo.getType().toString()); |
| } |
| public void setRangeType(RangeType type) { |
| STCfvoType.Enum xtype = STCfvoType.Enum.forString(type.name); |
| cfvo.setType(xtype); |
| } |
| |
| public String getFormula() { |
| if (cfvo.getType() == STCfvoType.FORMULA) { |
| return cfvo.getVal(); |
| } |
| return null; |
| } |
| public void setFormula(String formula) { |
| cfvo.setVal(formula); |
| } |
| |
| public Double getValue() { |
| if (cfvo.getType() == STCfvoType.FORMULA || |
| cfvo.getType() == STCfvoType.MIN || |
| cfvo.getType() == STCfvoType.MAX) { |
| return null; |
| } |
| if (cfvo.isSetVal()) { |
| return Double.parseDouble(cfvo.getVal()); |
| } else { |
| return null; |
| } |
| } |
| public void setValue(Double value) { |
| if (value == null) { |
| cfvo.unsetVal(); |
| } else { |
| cfvo.setVal(value.toString()); |
| } |
| } |
| } |