/* | |
* ==================================================================== | |
* 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()); | |
} | |
} | |
} |