/* ====================================================================
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: Extended Format Record
* Description: Probably one of the more complex records. There are two breeds:
* Style and Cell.
*
* It should be noted that fields in the extended format record are
* somewhat arbitrary. Almost all of the fields are bit-level, but
* we name them as best as possible by functional Group. In some
* places this Is better than others.
*
*
* REFERENCE: PG 426 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
* @author Andrew C. Oliver (acoliver at apache dot org)
* @version 2.0-pre
*/
public class ExtendedFormatRecord : StandardRecord
{
public const short sid = 0xE0;
// null constant
public const short NULL = unchecked((short)0xfff0);
// xf type
public const short XF_STYLE = 1;
public const short XF_CELL = 0;
// borders
public const short NONE = 0x0;
public const short THIN = 0x1;
public const short MEDIUM = 0x2;
public const short DASHED = 0x3;
public const short DOTTED = 0x4;
public const short THICK = 0x5;
public const short DOUBLE = 0x6;
public const short HAIR = 0x7;
public const short MEDIUM_DASHED = 0x8;
public const short DASH_DOT = 0x9;
public const short MEDIUM_DASH_DOT = 0xA;
public const short DASH_DOT_DOT = 0xB;
public const short MEDIUM_DASH_DOT_DOT = 0xC;
public const short SLANTED_DASH_DOT = 0xD;
// alignment
public const short GENERAL = 0x0;
public const short LEFT = 0x1;
public const short CENTER = 0x2;
public const short RIGHT = 0x3;
public const short FILL = 0x4;
public const short JUSTIFY = 0x5;
public const short CENTER_SELECTION = 0x6;
// vertical alignment
public const short VERTICAL_TOP = 0x0;
public const short VERTICAL_CENTER = 0x1;
public const short VERTICAL_BOTTOM = 0x2;
public const short VERTICAL_JUSTIFY = 0x3;
// fill
public const short NO_FILL = 0;
public const short SOLID_FILL = 1;
public const short FINE_DOTS = 2;
public const short ALT_BARS = 3;
public const short SPARSE_DOTS = 4;
public const short THICK_HORZ_BANDS = 5;
public const short THICK_VERT_BANDS = 6;
public const short THICK_BACKWARD_DIAG = 7;
public const short THICK_FORWARD_DIAG = 8;
public const short BIG_SPOTS = 9;
public const short BRICKS = 10;
public const short THIN_HORZ_BANDS = 11;
public const short THIN_VERT_BANDS = 12;
public const short THIN_BACKWARD_DIAG = 13;
public const short THIN_FORWARD_DIAG = 14;
public const short SQUARES = 15;
public const short DIAMONDS = 16;
// fields in BOTH style and Cell XF records
private short field_1_font_index; // not bit-mapped
private short field_2_format_index; // not bit-mapped
// field_3_cell_options bit map
static private BitField _locked = BitFieldFactory.GetInstance(0x0001);
static private BitField _hidden = BitFieldFactory.GetInstance(0x0002);
static private BitField _xf_type = BitFieldFactory.GetInstance(0x0004);
static private BitField _123_prefix = BitFieldFactory.GetInstance(0x0008);
static private BitField _parent_index = BitFieldFactory.GetInstance(0xFFF0);
private short field_3_cell_options;
// field_4_alignment_options bit map
static private BitField _alignment = BitFieldFactory.GetInstance(0x0007);
static private BitField _wrap_text = BitFieldFactory.GetInstance(0x0008);
static private BitField _vertical_alignment = BitFieldFactory.GetInstance(0x0070);
static private BitField _justify_last = BitFieldFactory.GetInstance(0x0080);
static private BitField _rotation = BitFieldFactory.GetInstance(0xFF00);
private short field_4_alignment_options;
// field_5_indention_options
static private BitField _indent =
BitFieldFactory.GetInstance(0x000F);
static private BitField _shrink_to_fit =
BitFieldFactory.GetInstance(0x0010);
static private BitField _merge_cells =
BitFieldFactory.GetInstance(0x0020);
static private BitField _Reading_order =
BitFieldFactory.GetInstance(0x00C0);
// apparently bits 8 and 9 are Unused
static private BitField _indent_not_parent_format =
BitFieldFactory.GetInstance(0x0400);
static private BitField _indent_not_parent_font =
BitFieldFactory.GetInstance(0x0800);
static private BitField _indent_not_parent_alignment =
BitFieldFactory.GetInstance(0x1000);
static private BitField _indent_not_parent_border =
BitFieldFactory.GetInstance(0x2000);
static private BitField _indent_not_parent_pattern =
BitFieldFactory.GetInstance(0x4000);
static private BitField _indent_not_parent_cell_options =
BitFieldFactory.GetInstance(0x8000);
private short field_5_indention_options;
// field_6_border_options bit map
static private BitField _border_left = BitFieldFactory.GetInstance(0x000F);
static private BitField _border_right = BitFieldFactory.GetInstance(0x00F0);
static private BitField _border_top = BitFieldFactory.GetInstance(0x0F00);
static private BitField _border_bottom = BitFieldFactory.GetInstance(0xF000);
private short field_6_border_options;
// all three of the following attributes are palette options
// field_7_palette_options bit map
static private BitField _left_border_palette_idx =
BitFieldFactory.GetInstance(0x007F);
static private BitField _right_border_palette_idx =
BitFieldFactory.GetInstance(0x3F80);
static private BitField _diag =
BitFieldFactory.GetInstance(0xC000);
private short field_7_palette_options;
// field_8_adtl_palette_options bit map
static private BitField _top_border_palette_idx =
BitFieldFactory.GetInstance(0x0000007F);
static private BitField _bottom_border_palette_idx =
BitFieldFactory.GetInstance(0x00003F80);
static private BitField _adtl_diag =
BitFieldFactory.GetInstance(0x001fc000);
static private BitField _adtl_diag_line_style =
BitFieldFactory.GetInstance(0x01e00000);
// apparently bit 25 Is Unused
static private BitField _adtl_Fill_pattern =
BitFieldFactory.GetInstance(unchecked((int)0xfc000000));
private int field_8_adtl_palette_options; // Additional to avoid 2
// field_9_fill_palette_options bit map
static private BitField _fill_foreground = BitFieldFactory.GetInstance(0x007F);
static private BitField _fill_background = BitFieldFactory.GetInstance(0x3f80);
// apparently bits 15 and 14 are Unused
private short field_9_fill_palette_options;
/**
* Constructor ExtendedFormatRecord
*
*
*/
public ExtendedFormatRecord()
{
}
/**
* Constructs an ExtendedFormat record and Sets its fields appropriately.
* @param in the RecordInputstream to Read the record from
*/
public ExtendedFormatRecord(RecordInputStream in1)
{
field_1_font_index = in1.ReadShort();
field_2_format_index = in1.ReadShort();
field_3_cell_options = in1.ReadShort();
field_4_alignment_options = in1.ReadShort();
field_5_indention_options = in1.ReadShort();
field_6_border_options = in1.ReadShort();
field_7_palette_options = in1.ReadShort();
field_8_adtl_palette_options = in1.ReadInt();
field_9_fill_palette_options = in1.ReadShort();
}
/**
* Clones all the style information from another
* ExtendedFormatRecord, onto this one. This
* will then hold all the same style options.
*
* If The source ExtendedFormatRecord comes from
* a different Workbook, you will need to sort
* out the font and format indicies yourself!
*/
public void CloneStyleFrom(ExtendedFormatRecord source)
{
field_1_font_index = source.field_1_font_index;
field_2_format_index = source.field_2_format_index;
field_3_cell_options = source.field_3_cell_options;
field_4_alignment_options = source.field_4_alignment_options;
field_5_indention_options = source.field_5_indention_options;
field_6_border_options = source.field_6_border_options;
field_7_palette_options = source.field_7_palette_options;
field_8_adtl_palette_options = source.field_8_adtl_palette_options;
field_9_fill_palette_options = source.field_9_fill_palette_options;
}
///
/// Get the index to the FONT record (which font to use 0 based)
///
public short FontIndex
{
get { return field_1_font_index; }
set { field_1_font_index = value; }
}
///
/// Get the index to the Format record (which FORMAT to use 0-based)
///
public short FormatIndex
{
get
{
return field_2_format_index;
}
set { field_2_format_index = value; }
}
///
/// Gets the options bitmask - you can also use corresponding option bit Getters
/// (see other methods that reference this one)
///
public short CellOptions
{
get
{
return field_3_cell_options;
}
set { field_3_cell_options = value; }
}
///
/// Get whether the cell Is locked or not
///
public bool IsLocked
{
get
{
return _locked.IsSet(field_3_cell_options);
}
set
{
field_3_cell_options = _locked.SetShortBoolean(field_3_cell_options,
value);
}
}
///
/// Get whether the cell Is hidden or not
///
public bool IsHidden
{
get
{
return _hidden.IsSet(field_3_cell_options);
}
set
{
field_3_cell_options = _hidden.SetShortBoolean(field_3_cell_options,
value);
}
}
///
/// Get whether the cell Is a cell or style XFRecord
///
public short XFType
{
get
{
return _xf_type.GetShortValue(field_3_cell_options);
}
set
{
field_3_cell_options = _xf_type.SetShortValue(field_3_cell_options,
value);
}
}
///
/// Get some old holdover from lotus 123. Who cares, its all over for Lotus.
/// RIP Lotus.
///
public bool _123Prefix
{
get{
return _123_prefix.IsSet(field_3_cell_options);
}
set
{
field_3_cell_options =
_123_prefix.SetShortBoolean(field_3_cell_options, value);
}
}
///
/// for cell XF types this Is the parent style (usually 0/normal). For
/// style this should be NULL.
///
public short ParentIndex
{
get
{
return _parent_index.GetShortValue(field_3_cell_options);
}
set
{
field_3_cell_options =
_parent_index.SetShortValue(field_3_cell_options, value);
}
}
///
/// Get the alignment options bitmask. See corresponding bitGetter methods
/// that reference this one.
///
public short AlignmentOptions
{
get
{
return field_4_alignment_options;
}
set { field_4_alignment_options = value; }
}
///
/// Get the horizontal alignment of the cell.
///
public short Alignment
{
get
{
return _alignment.GetShortValue(field_4_alignment_options);
}
set
{
field_4_alignment_options =
_alignment.SetShortValue(field_4_alignment_options, value);
}
}
///
/// Get whether to wrap the text in the cell
///
public bool WrapText
{
get
{
return _wrap_text.IsSet(field_4_alignment_options);
}
set
{
field_4_alignment_options =
_wrap_text.SetShortBoolean(field_4_alignment_options, value);
}
}
///
/// Get the vertical alignment of text in the cell
///
public short VerticalAlignment
{
get
{
return _vertical_alignment.GetShortValue(field_4_alignment_options);
}
set
{
field_4_alignment_options =
_vertical_alignment.SetShortValue(field_4_alignment_options,
value);
}
}
///
/// Docs just say this Is for far east versions.. (I'm guessing it
/// justifies for right-to-left Read languages)
///
public short JustifyLast
{
get
{// for far east languages supported only for format always 0 for US
return _justify_last.GetShortValue(field_4_alignment_options);
}
set
{ // for far east languages supported only for format always 0 for US
field_4_alignment_options =
_justify_last.SetShortValue(field_4_alignment_options, value);
}
}
///
/// Get the degree of rotation. (I've not actually seen this used anywhere)
///
public short Rotation
{
get
{
return _rotation.GetShortValue(field_4_alignment_options);
}
set
{
field_4_alignment_options =
_rotation.SetShortValue(field_4_alignment_options, value);
}
}
///
/// Get the indent options bitmask (see corresponding bit Getters that reference
/// this field)
///
public short IndentionOptions
{
get
{
return field_5_indention_options;
}
set { field_5_indention_options = value; }
}
///
/// Get indention (not sure of the Units, think its spaces)
///
public short Indent
{
get
{
return _indent.GetShortValue(field_5_indention_options);
}
set
{
field_5_indention_options =
_indent.SetShortValue(field_5_indention_options, value);
}
}
///
/// Get whether to shrink the text to fit
///
public bool ShrinkToFit
{
get
{
return _shrink_to_fit.IsSet(field_5_indention_options);
}
set
{
field_5_indention_options =
_shrink_to_fit.SetShortBoolean(field_5_indention_options, value);
}
}
///
/// Get whether to merge cells
///
public bool MergeCells
{
get
{
return _merge_cells.IsSet(field_5_indention_options);
}
set
{
field_5_indention_options =
_merge_cells.SetShortBoolean(field_5_indention_options, value);
}
}
///
/// Get the Reading order for far east versions (0 - Context, 1 - Left to right,
/// 2 - right to left) - We could use some help with support for the far east.
///
public short ReadingOrder
{
get
{// only for far east always 0 in US
return _Reading_order.GetShortValue(field_5_indention_options);
}
set
{ // only for far east always 0 in US
field_5_indention_options =
_Reading_order.SetShortValue(field_5_indention_options, value);
}
}
///
/// Get whether or not to use the format in this XF instead of the parent XF.
///
public bool IsIndentNotParentFormat
{
get
{
return _indent_not_parent_format.IsSet(field_5_indention_options);
}
set
{
field_5_indention_options =
_indent_not_parent_format
.SetShortBoolean(field_5_indention_options, value);
}
}
///
/// Get whether or not to use the font in this XF instead of the parent XF.
///
public bool IsIndentNotParentFont
{
get
{
return _indent_not_parent_font.IsSet(field_5_indention_options);
}
set
{
field_5_indention_options =
_indent_not_parent_font.SetShortBoolean(field_5_indention_options,
value);
}
}
///
/// Get whether or not to use the alignment in this XF instead of the parent XF.
///
public bool IsIndentNotParentAlignment
{
get{return _indent_not_parent_alignment.IsSet(field_5_indention_options);}
set
{
field_5_indention_options =
_indent_not_parent_alignment
.SetShortBoolean(field_5_indention_options, value);
}
}
///
/// Get whether or not to use the border in this XF instead of the parent XF.
///
public bool IsIndentNotParentBorder
{
get { return _indent_not_parent_border.IsSet(field_5_indention_options); }
set
{
field_5_indention_options =
_indent_not_parent_border
.SetShortBoolean(field_5_indention_options, value);
}
}
///
/// Get whether or not to use the pattern in this XF instead of the parent XF.
/// (foregrount/background)
///
public bool IsIndentNotParentPattern
{
get { return _indent_not_parent_pattern.IsSet(field_5_indention_options); }
set
{
field_5_indention_options =
_indent_not_parent_pattern
.SetShortBoolean(field_5_indention_options, value);
}
}
///
/// Get whether or not to use the locking/hidden in this XF instead of the parent XF.
///
public bool IsIndentNotParentCellOptions
{
get
{
return _indent_not_parent_cell_options
.IsSet(field_5_indention_options);
}
set
{
field_5_indention_options =
_indent_not_parent_cell_options
.SetShortBoolean(field_5_indention_options, value);
}
}
///
/// Get the border options bitmask (see the corresponding bit Getter methods
/// that reference back to this one)
///
public short BorderOptions
{
get { return field_6_border_options; }
set { field_6_border_options = value; }
}
///
/// Get the borderline style for the left border
///
public short BorderLeft
{
get{return _border_left.GetShortValue(field_6_border_options);}
set
{
field_6_border_options =
_border_left.SetShortValue(field_6_border_options, value);
}
}
///
/// Get the borderline style for the right border
///
public short BorderRight
{
get{return _border_right.GetShortValue(field_6_border_options);}
set
{
field_6_border_options =
_border_right.SetShortValue(field_6_border_options, value);
}
}
///
/// Get the borderline style for the top border
///
public short BorderTop
{
get{return _border_top.GetShortValue(field_6_border_options);}
set {
field_6_border_options =_border_top.SetShortValue(field_6_border_options, value);
}
}
///
/// Get the borderline style for the bottom border
///
public short BorderBottom
{
get{return _border_bottom.GetShortValue(field_6_border_options);}
set {
field_6_border_options =_border_bottom.SetShortValue(field_6_border_options, value);
}
}
///
/// Get the palette options bitmask (see the individual bit Getter methods that
/// reference this one)
///
public short PaletteOptions
{
get{return field_7_palette_options;}
set { field_7_palette_options = value; }
}
///
/// Get the palette index for the left border color
///
public short LeftBorderPaletteIdx
{
get{return _left_border_palette_idx
.GetShortValue(field_7_palette_options);
}
set {
field_7_palette_options =
_left_border_palette_idx.SetShortValue(field_7_palette_options,
value);
}
}
///
/// Get the palette index for the right border color
///
public short RightBorderPaletteIdx
{
get{return _right_border_palette_idx
.GetShortValue(field_7_palette_options);
}
set
{
field_7_palette_options =
_right_border_palette_idx.SetShortValue(field_7_palette_options,
value);
}
}
///
/// Not sure what this Is for (maybe Fill lines?) 1 = down, 2 = up, 3 = both, 0 for none..
///
public short Diag
{
get{return _diag.GetShortValue(field_7_palette_options);}
set
{
field_7_palette_options = _diag.SetShortValue(field_7_palette_options,
value);
}
}
///
/// Get the Additional palette options bitmask (see individual bit Getter methods
/// that reference this method)
///
public int AdtlPaletteOptions
{
get{return field_8_adtl_palette_options;}
set { field_8_adtl_palette_options = value; }
}
///
/// Get the palette index for the top border
///
public short TopBorderPaletteIdx
{
get{return (short)_top_border_palette_idx
.GetValue(field_8_adtl_palette_options);}
set
{
field_8_adtl_palette_options =
_top_border_palette_idx.SetValue(field_8_adtl_palette_options,
value);
}
}
///
/// Get the palette index for the bottom border
///
public short BottomBorderPaletteIdx
{
get{return (short)_bottom_border_palette_idx
.GetValue(field_8_adtl_palette_options);
}
set
{
field_8_adtl_palette_options =
_bottom_border_palette_idx.SetValue(field_8_adtl_palette_options,
value);
}
}
///
/// Get for diagonal borders
///
public short AdtlDiag
{
get{return (short)_adtl_diag.GetValue(field_8_adtl_palette_options);}
set
{
field_8_adtl_palette_options =
_adtl_diag.SetValue(field_8_adtl_palette_options, value);
}
}
///
/// Get the diagonal border line style
///
public short AdtlDiagLineStyle
{
get{return (short)_adtl_diag_line_style
.GetValue(field_8_adtl_palette_options);}
set
{
field_8_adtl_palette_options =
_adtl_diag_line_style.SetValue(field_8_adtl_palette_options,
value);
}
}
///
/// Get the Additional Fill pattern
///
public short AdtlFillPattern
{
get{return (short)_adtl_Fill_pattern
.GetValue(field_8_adtl_palette_options);}
set
{
field_8_adtl_palette_options =
_adtl_Fill_pattern.SetValue(field_8_adtl_palette_options, value);
}
}
///
/// Get the Fill palette options bitmask (see indivdual bit Getters that
/// reference this method)
///
public short FillPaletteOptions
{
get{return field_9_fill_palette_options;}
set { field_9_fill_palette_options = value; }
}
///
/// Get the foreground palette color index
///
public short FillForeground
{
get{return _fill_foreground.GetShortValue(field_9_fill_palette_options);}
set
{
field_9_fill_palette_options =
_fill_foreground.SetShortValue(field_9_fill_palette_options,
value);
}
}
///
/// Get the background palette color index
///
public short FillBackground
{
get{return _fill_background.GetShortValue(field_9_fill_palette_options);}
set
{
field_9_fill_palette_options =
_fill_background.SetShortValue(field_9_fill_palette_options,
value);
}
}
public override String ToString()
{
StringBuilder buffer = new StringBuilder();
buffer.Append("[EXTENDEDFORMAT]\n");
if (XFType == XF_STYLE)
{
buffer.Append(" STYLE_RECORD_TYPE\n");
}
else if (XFType == XF_CELL)
{
buffer.Append(" CELL_RECORD_TYPE\n");
}
buffer.Append(" .fontindex = ")
.Append(StringUtil.ToHexString(FontIndex)).Append("\n");
buffer.Append(" .formatindex = ")
.Append(StringUtil.ToHexString(FormatIndex)).Append("\n");
buffer.Append(" .celloptions = ")
.Append(StringUtil.ToHexString(CellOptions)).Append("\n");
buffer.Append(" .Islocked = ").Append(IsLocked)
.Append("\n");
buffer.Append(" .Ishidden = ").Append(IsHidden)
.Append("\n");
buffer.Append(" .recordtype= ")
.Append(StringUtil.ToHexString(XFType)).Append("\n");
buffer.Append(" .parentidx = ")
.Append(StringUtil.ToHexString(ParentIndex)).Append("\n");
buffer.Append(" .alignmentoptions= ")
.Append(StringUtil.ToHexString(AlignmentOptions)).Append("\n");
buffer.Append(" .alignment = ").Append(Alignment)
.Append("\n");
buffer.Append(" .wraptext = ").Append(WrapText)
.Append("\n");
buffer.Append(" .valignment= ")
.Append(StringUtil.ToHexString(VerticalAlignment)).Append("\n");
buffer.Append(" .justlast = ")
.Append(StringUtil.ToHexString(JustifyLast)).Append("\n");
buffer.Append(" .rotation = ")
.Append(StringUtil.ToHexString(Rotation)).Append("\n");
buffer.Append(" .indentionoptions= ")
.Append(StringUtil.ToHexString(IndentionOptions)).Append("\n");
buffer.Append(" .indent = ")
.Append(StringUtil.ToHexString(Indent)).Append("\n");
buffer.Append(" .shrinktoft= ").Append(ShrinkToFit)
.Append("\n");
buffer.Append(" .mergecells= ").Append(MergeCells)
.Append("\n");
buffer.Append(" .Readngordr= ")
.Append(StringUtil.ToHexString(ReadingOrder)).Append("\n");
buffer.Append(" .formatflag= ")
.Append(IsIndentNotParentFormat).Append("\n");
buffer.Append(" .fontflag = ")
.Append(IsIndentNotParentFont).Append("\n");
buffer.Append(" .prntalgnmt= ")
.Append(IsIndentNotParentAlignment).Append("\n");
buffer.Append(" .borderflag= ")
.Append(IsIndentNotParentBorder).Append("\n");
buffer.Append(" .paternflag= ")
.Append(IsIndentNotParentPattern).Append("\n");
buffer.Append(" .celloption= ")
.Append(IsIndentNotParentCellOptions).Append("\n");
buffer.Append(" .borderoptns = ")
.Append(StringUtil.ToHexString(BorderOptions)).Append("\n");
buffer.Append(" .lftln = ")
.Append(StringUtil.ToHexString(BorderLeft)).Append("\n");
buffer.Append(" .rgtln = ")
.Append(StringUtil.ToHexString(BorderRight)).Append("\n");
buffer.Append(" .topln = ")
.Append(StringUtil.ToHexString(BorderTop)).Append("\n");
buffer.Append(" .btmln = ")
.Append(StringUtil.ToHexString(BorderBottom)).Append("\n");
buffer.Append(" .paleteoptns = ")
.Append(StringUtil.ToHexString(PaletteOptions)).Append("\n");
buffer.Append(" .leftborder= ")
.Append(StringUtil.ToHexString(LeftBorderPaletteIdx))
.Append("\n");
buffer.Append(" .rghtborder= ")
.Append(StringUtil.ToHexString(RightBorderPaletteIdx))
.Append("\n");
buffer.Append(" .diag = ")
.Append(StringUtil.ToHexString(Diag)).Append("\n");
buffer.Append(" .paleteoptn2 = ")
.Append(StringUtil.ToHexString(AdtlPaletteOptions))
.Append("\n");
buffer.Append(" .topborder = ")
.Append(StringUtil.ToHexString(TopBorderPaletteIdx))
.Append("\n");
buffer.Append(" .botmborder= ")
.Append(StringUtil.ToHexString(BottomBorderPaletteIdx))
.Append("\n");
buffer.Append(" .adtldiag = ")
.Append(StringUtil.ToHexString(AdtlDiag)).Append("\n");
buffer.Append(" .diaglnstyl= ")
.Append(StringUtil.ToHexString(AdtlDiagLineStyle)).Append("\n");
buffer.Append(" .Fillpattrn= ")
.Append(StringUtil.ToHexString(AdtlFillPattern)).Append("\n");
buffer.Append(" .Fillpaloptn = ")
.Append(StringUtil.ToHexString(FillPaletteOptions))
.Append("\n");
buffer.Append(" .foreground= ")
.Append(StringUtil.ToHexString(FillForeground)).Append("\n");
buffer.Append(" .background= ")
.Append(StringUtil.ToHexString(FillBackground)).Append("\n");
buffer.Append("[/EXTENDEDFORMAT]\n");
return buffer.ToString();
}
public override void Serialize(ILittleEndianOutput out1)
{
out1.WriteShort(FontIndex);
out1.WriteShort(FormatIndex);
out1.WriteShort(CellOptions);
out1.WriteShort(AlignmentOptions);
out1.WriteShort(IndentionOptions);
out1.WriteShort(BorderOptions);
out1.WriteShort(PaletteOptions);
out1.WriteInt(AdtlPaletteOptions);
out1.WriteShort(FillPaletteOptions);
}
protected override int DataSize
{
get { return 20; }
}
public override short Sid
{
get { return sid; }
}
public override int GetHashCode()
{
int prime = 31;
int result = 1;
result = prime * result + field_1_font_index;
result = prime * result + field_2_format_index;
result = prime * result + field_3_cell_options;
result = prime * result + field_4_alignment_options;
result = prime * result + field_5_indention_options;
result = prime * result + field_6_border_options;
result = prime * result + field_7_palette_options;
result = prime * result + field_8_adtl_palette_options;
result = prime * result + field_9_fill_palette_options;
return result;
}
/**
* Will consider two different records with the same
* contents as Equals, as the various indexes
* that matter are embedded in the records
*/
public override bool Equals(Object obj)
{
if (this == obj)
return true;
if (obj == null)
return false;
if (obj is ExtendedFormatRecord)
{
ExtendedFormatRecord other = (ExtendedFormatRecord)obj;
if (field_1_font_index != other.field_1_font_index)
return false;
if (field_2_format_index != other.field_2_format_index)
return false;
if (field_3_cell_options != other.field_3_cell_options)
return false;
if (field_4_alignment_options != other.field_4_alignment_options)
return false;
if (field_5_indention_options != other.field_5_indention_options)
return false;
if (field_6_border_options != other.field_6_border_options)
return false;
if (field_7_palette_options != other.field_7_palette_options)
return false;
if (field_8_adtl_palette_options != other.field_8_adtl_palette_options)
return false;
if (field_9_fill_palette_options != other.field_9_fill_palette_options)
return false;
return true;
}
return false;
}
}
}