/* ====================================================================
|
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.
|
==================================================================== */
|
|
namespace HH.WMS.Utils.NPOI.HSSF.Record.Common
|
{
|
using System;
|
using System.Text;
|
using HH.WMS.Utils.NPOI.HSSF.Record;
|
using HH.WMS.Utils.NPOI.Util;
|
|
/**
|
* FeatFormulaErr2 (Formula Evaluation Shared Feature) common record part
|
*
|
* This record part specifies Formula Evaluation & Error Ignoring data
|
* for a sheet, stored as part of a Shared Feature. It can be found in
|
* records such as {@link FeatRecord}.
|
* For the full meanings of the flags, see pages 669 and 670
|
* of the Excel binary file format documentation.
|
*/
|
public class FeatFormulaErr2 : SharedFeature
|
{
|
static BitField checkCalculationErrors =
|
BitFieldFactory.GetInstance(0x01);
|
static BitField checkEmptyCellRef =
|
BitFieldFactory.GetInstance(0x02);
|
static BitField checkNumbersAsText =
|
BitFieldFactory.GetInstance(0x04);
|
static BitField checkInconsistentRanges =
|
BitFieldFactory.GetInstance(0x08);
|
static BitField checkInconsistentFormulas =
|
BitFieldFactory.GetInstance(0x10);
|
static BitField checkDateTimeFormats =
|
BitFieldFactory.GetInstance(0x20);
|
static BitField checkUnprotectedFormulas =
|
BitFieldFactory.GetInstance(0x40);
|
static BitField performDataValidation =
|
BitFieldFactory.GetInstance(0x80);
|
|
/**
|
* What errors we should ignore
|
*/
|
private int errorCheck;
|
|
|
public FeatFormulaErr2() { }
|
|
public FeatFormulaErr2(RecordInputStream in1)
|
{
|
errorCheck = in1.ReadInt();
|
}
|
|
public override String ToString()
|
{
|
StringBuilder buffer = new StringBuilder();
|
buffer.Append(" [FEATURE FORMULA ERRORS]\n");
|
buffer.Append(" checkCalculationErrors = ");
|
buffer.Append(" checkEmptyCellRef = ");
|
buffer.Append(" checkNumbersAsText = ");
|
buffer.Append(" checkInconsistentRanges = ");
|
buffer.Append(" checkInconsistentFormulas = ");
|
buffer.Append(" checkDateTimeFormats = ");
|
buffer.Append(" checkUnprotectedFormulas = ");
|
buffer.Append(" performDataValidation = ");
|
buffer.Append(" [/FEATURE FORMULA ERRORS]\n");
|
return buffer.ToString();
|
}
|
|
public void Serialize(ILittleEndianOutput out1)
|
{
|
out1.WriteInt(errorCheck);
|
}
|
|
public int DataSize
|
{
|
get
|
{
|
return 4;
|
}
|
}
|
|
public int RawErrorCheckValue
|
{
|
get
|
{
|
return errorCheck;
|
}
|
}
|
|
public bool CheckCalculationErrors
|
{
|
get
|
{
|
return checkCalculationErrors.IsSet(errorCheck);
|
}
|
set
|
{
|
FeatFormulaErr2.checkCalculationErrors.SetBoolean(
|
errorCheck, value);
|
}
|
}
|
|
public bool CheckEmptyCellRef
|
{
|
get
|
{
|
return checkEmptyCellRef.IsSet(errorCheck);
|
}
|
set
|
{
|
FeatFormulaErr2.checkEmptyCellRef.SetBoolean(
|
errorCheck, value);
|
}
|
}
|
|
public bool CheckNumbersAsText
|
{
|
get
|
{
|
return checkNumbersAsText.IsSet(errorCheck);
|
}
|
set
|
{
|
FeatFormulaErr2.checkNumbersAsText.SetBoolean(
|
errorCheck, value);
|
}
|
}
|
|
public bool CheckInconsistentRanges
|
{
|
get
|
{
|
return checkInconsistentRanges.IsSet(errorCheck);
|
}
|
set
|
{
|
FeatFormulaErr2.checkInconsistentRanges.SetBoolean(
|
errorCheck, value);
|
}
|
}
|
|
public bool CheckInconsistentFormulas
|
{
|
get
|
{
|
return checkInconsistentFormulas.IsSet(errorCheck);
|
}
|
set
|
{
|
FeatFormulaErr2.checkInconsistentFormulas.SetBoolean(
|
errorCheck, value);
|
}
|
}
|
|
public bool CheckDateTimeFormats
|
{
|
get
|
{
|
return checkDateTimeFormats.IsSet(errorCheck);
|
}
|
set
|
{
|
FeatFormulaErr2.checkDateTimeFormats.SetBoolean(
|
errorCheck, value);
|
}
|
}
|
|
public bool CheckUnprotectedFormulas
|
{
|
get
|
{
|
return checkUnprotectedFormulas.IsSet(errorCheck);
|
}
|
set
|
{
|
FeatFormulaErr2.checkUnprotectedFormulas.SetBoolean(
|
errorCheck, value);
|
}
|
}
|
|
public bool PerformDataValidation
|
{
|
get
|
{
|
return performDataValidation.IsSet(errorCheck);
|
}
|
set
|
{
|
FeatFormulaErr2.performDataValidation.SetBoolean(
|
errorCheck, value);
|
}
|
}
|
}
|
|
}
|
