|
/* ====================================================================
|
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
|
{
|
using System;
|
using System.Text;
|
using HH.WMS.Utils.NPOI.Util;
|
|
|
/**
|
* Title: WSBool Record.
|
* Description: stores workbook Settings (aka its a big "everything we didn't
|
* put somewhere else")
|
* REFERENCE: PG 425 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
* @author Andrew C. Oliver (acoliver at apache dot org)
|
* @author Glen Stampoultzis (gstamp@iprimus.com.au)
|
* @author Jason Height (jheight at chariot dot net dot au)
|
* @version 2.0-pre
|
*/
|
|
public class WSBoolRecord
|
: StandardRecord
|
{
|
public const short sid = 0x81;
|
private byte field_1_wsbool; // crappy names are because this is really one big short field (2byte)
|
private byte field_2_wsbool; // but the docs inconsistantly use it as 2 seperate bytes
|
|
// I decided to be consistant in this way.
|
static private BitField autobreaks =
|
BitFieldFactory.GetInstance(0x01); // are automatic page breaks visible
|
|
// bits 1 to 3 Unused
|
static private BitField dialog = BitFieldFactory.GetInstance(0x10); // is sheet dialog sheet
|
static private BitField applystyles = BitFieldFactory.GetInstance(0x20); // whether to apply automatic styles to outlines
|
static private BitField rowsumsbelow = BitFieldFactory.GetInstance(0x40); // whether summary rows will appear below detail in outlines
|
static private BitField rowsumsright = BitFieldFactory.GetInstance(0x80); // whether summary rows will appear right of the detail in outlines
|
static private BitField fittopage = BitFieldFactory.GetInstance(0x01); // whether to fit stuff to the page
|
|
// bit 2 reserved
|
static private BitField Displayguts = BitFieldFactory.GetInstance(0x06); // whether to Display outline symbols (in the gutters)
|
|
// bits 4-5 reserved
|
static private BitField alternateexpression = BitFieldFactory.GetInstance(0x40); // whether to use alternate expression eval
|
|
static private BitField alternateformula = BitFieldFactory.GetInstance(0x80); // whether to use alternate formula entry
|
|
|
public WSBoolRecord()
|
{
|
}
|
|
/**
|
* Constructs a WSBool record and Sets its fields appropriately.
|
* @param in the RecordInputstream to Read the record from
|
*/
|
|
public WSBoolRecord(RecordInputStream in1)
|
{
|
byte[] data = in1.ReadRemainder();
|
field_1_wsbool =
|
data[0];
|
field_2_wsbool =
|
data[1];
|
}
|
|
|
/**
|
* Get first byte (see bit Getters)
|
*/
|
|
public byte WSBool1
|
{
|
get
|
{
|
return field_1_wsbool;
|
}
|
set { field_1_wsbool = value; }
|
}
|
|
// bool1 bitfields
|
|
/// <summary>
|
/// Whether to show automatic page breaks or not
|
/// </summary>
|
public bool Autobreaks
|
{
|
get
|
{
|
return autobreaks.IsSet(field_1_wsbool);
|
}
|
set { field_1_wsbool = autobreaks.SetByteBoolean(field_1_wsbool, value); }
|
}
|
|
/// <summary>
|
/// Whether sheet is a dialog sheet or not
|
/// </summary>
|
public bool Dialog
|
{
|
get
|
{
|
return dialog.IsSet(field_1_wsbool);
|
}
|
set { field_1_wsbool = dialog.SetByteBoolean(field_1_wsbool, value); }
|
}
|
|
/// <summary>
|
/// Get if row summaries appear below detail in the outline
|
/// </summary>
|
public bool RowSumsBelow
|
{
|
get
|
{
|
return rowsumsbelow.IsSet(field_1_wsbool);
|
}
|
set { field_1_wsbool = rowsumsbelow.SetByteBoolean(field_1_wsbool, value); }
|
}
|
|
/// <summary>
|
/// Get if col summaries appear right of the detail in the outline
|
/// </summary>
|
public bool RowSumsRight
|
{
|
get
|
{
|
return rowsumsright.IsSet(field_1_wsbool);
|
}
|
set { field_1_wsbool = rowsumsright.SetByteBoolean(field_1_wsbool, value); }
|
}
|
|
|
/// <summary>
|
/// Get the second byte (see bit Getters)
|
/// </summary>
|
public byte WSBool2
|
{
|
get
|
{
|
return field_2_wsbool;
|
}
|
set { field_2_wsbool = value; }
|
}
|
|
|
/// <summary>
|
/// fit to page option is on
|
/// </summary>
|
public bool FitToPage
|
{
|
get
|
{
|
return fittopage.IsSet(field_2_wsbool);
|
}
|
set { field_2_wsbool = fittopage.SetByteBoolean(field_2_wsbool, value); }
|
}
|
|
/// <summary>
|
/// Whether to display the guts or not
|
/// </summary>
|
public bool DisplayGuts
|
{
|
get
|
{
|
return Displayguts.IsSet(field_2_wsbool);
|
}
|
set { field_2_wsbool = Displayguts.SetByteBoolean(field_2_wsbool, value); }
|
}
|
|
/// <summary>
|
/// whether alternate expression evaluation is on
|
/// </summary>
|
public bool AlternateExpression
|
{
|
get
|
{
|
return alternateexpression.IsSet(field_2_wsbool);
|
}
|
set
|
{
|
field_2_wsbool = alternateexpression.SetByteBoolean(field_2_wsbool,
|
value);
|
}
|
}
|
|
/// <summary>
|
/// whether alternative formula entry is on
|
/// </summary>
|
public bool AlternateFormula
|
{
|
get
|
{
|
return alternateformula.IsSet(field_2_wsbool);
|
}
|
set
|
{
|
field_2_wsbool = alternateformula.SetByteBoolean(field_2_wsbool,
|
value);
|
}
|
}
|
|
public override String ToString()
|
{
|
StringBuilder buffer = new StringBuilder();
|
|
buffer.Append("[WSBOOL]\n");
|
buffer.Append(" .wsbool1 = ")
|
.Append(StringUtil.ToHexString(WSBool1)).Append("\n");
|
buffer.Append(" .autobreaks = ").Append(Autobreaks)
|
.Append("\n");
|
buffer.Append(" .dialog = ").Append(Dialog)
|
.Append("\n");
|
buffer.Append(" .rowsumsbelw= ").Append(RowSumsBelow)
|
.Append("\n");
|
buffer.Append(" .rowsumsrigt= ").Append(RowSumsRight)
|
.Append("\n");
|
buffer.Append(" .wsbool2 = ")
|
.Append(StringUtil.ToHexString(WSBool2)).Append("\n");
|
buffer.Append(" .fittopage = ").Append(FitToPage)
|
.Append("\n");
|
buffer.Append(" .Displayguts= ").Append(DisplayGuts)
|
.Append("\n");
|
buffer.Append(" .alternateex= ")
|
.Append(AlternateExpression).Append("\n");
|
buffer.Append(" .alternatefo= ").Append(AlternateFormula)
|
.Append("\n");
|
buffer.Append("[/WSBOOL]\n");
|
return buffer.ToString();
|
}
|
|
public override void Serialize(ILittleEndianOutput out1)
|
{
|
out1.WriteByte(WSBool1);
|
out1.WriteByte(WSBool2);
|
}
|
|
protected override int DataSize
|
{
|
get { return 2; }
|
}
|
|
public override short Sid
|
{
|
get { return sid; }
|
}
|
|
public override Object Clone()
|
{
|
WSBoolRecord rec = new WSBoolRecord();
|
rec.field_1_wsbool = field_1_wsbool;
|
rec.field_2_wsbool = field_2_wsbool;
|
return rec;
|
}
|
}
|
}
|
