public AutoFilterRecord(RecordInputStream in1)
 {
     field_1_iEntry = in1.ReadShort();
     field_2_grbit = in1.ReadShort();
     field_3_doper1 = new DOPERRecord(in1);
     field_4_doper2 = new DOPERRecord(in1);
     if (field_3_doper1.DataType == DOPERType.String&&field_3_doper1.LengthOfString>0)
     {
         rgch1_multibyte = (in1.ReadByte() != 0);
         if (rgch1_multibyte)
         {
             field_5_rgch1 = in1.ReadUnicodeLEString(field_3_doper1.LengthOfString);
         }
         else
         {
             field_5_rgch1 = in1.ReadCompressedUnicode(field_3_doper1.LengthOfString);
         }
     }
     if (field_4_doper2.DataType == DOPERType.String && field_4_doper2.LengthOfString > 0)
     {
         rgch2_multibyte = (in1.ReadByte() != 0);
         if (rgch2_multibyte)
         {
             field_6_rgch2 = in1.ReadUnicodeLEString(field_4_doper2.LengthOfString);
         }
         else
         {
             field_6_rgch2 = in1.ReadCompressedUnicode(field_4_doper2.LengthOfString);
         }
     }
 }

 public DOPERRecord(RecordInputStream in1)
 {
     vt=(DOPERType)in1.ReadByte();
     switch (vt)
     { 
         case DOPERType.RKNumber:
             grbitSgn = (byte)in1.ReadByte();
             _RK = new RKRecord(in1);
             in1.ReadInt();  //reserved
             break;
         case DOPERType.IEEENumber:
             grbitSgn = (byte)in1.ReadByte();
             _IEEENumber = in1.ReadDouble();
             break;          
         case DOPERType.String:
             grbitSgn = (byte)in1.ReadByte();
             in1.ReadInt();  //reserved
             CCH = (byte)in1.ReadByte();
             in1.ReadByte();     //reserved
             in1.ReadShort();    //reserved
             break;
         case DOPERType.BooleanOrErrors:
             grbitSgn = (byte)in1.ReadByte();
             fError=(byte)in1.ReadByte();
             bBoolErr=(byte)in1.ReadByte();
             in1.ReadShort();    //reserved
             in1.ReadInt();      //reserved
             break;
         default:    //FilterCondition,MatchAllBlanks,MatchNoneBlank
             grbitSgn = 0;
             in1.ReadByte();    //reserved
             in1.ReadLong();    //reserved
             break;
     }
 }

        /**
         * Constructs a Bar record and s its fields appropriately.
         *
         * @param in the RecordInputstream to Read the record from
         */

        public BarRecord(RecordInputStream in1)
        {

            field_1_barSpace = in1.ReadShort();
            field_2_categorySpace = in1.ReadShort();
            field_3_formatFlags = in1.ReadShort();
        }

        /**
         * Constructs a ObjectLink record and Sets its fields appropriately.
         *
         * @param in the RecordInputstream to Read the record from
         */

        public ObjectLinkRecord(RecordInputStream in1)
        {

            field_1_anchorId = in1.ReadShort();
            field_2_link1 = in1.ReadShort();
            field_3_link2 = in1.ReadShort();
        }

        /**
         * Constructs a DataFormat record and Sets its fields appropriately.
         *
         * @param in the RecordInputstream to Read the record from
         */

        public DataFormatRecord(RecordInputStream in1)
        {
            field_1_pointNumber = in1.ReadShort();
            field_2_seriesIndex = in1.ReadShort();
            field_3_seriesNumber = in1.ReadShort();
            field_4_formatFlags = in1.ReadShort();
        }

        /**
         * Constructs a SheetProperties record and Sets its fields appropriately.
         *
         * @param in the RecordInputstream to Read the record from
         */

        public ShtPropsRecord(RecordInputStream in1)
        {

            field_1_flags = in1.ReadShort();
            field_2_mdBlank = (byte)in1.ReadByte();
            field_3_reserved = (byte)in1.ReadByte();
        }

        /**
         * Constructs a SheetProperties record and Sets its fields appropriately.
         *
         * @param in the RecordInputstream to Read the record from
         */

        public SheetPropertiesRecord(RecordInputStream in1)
        {

            field_1_flags = in1.ReadShort();
            field_2_empty = (byte)in1.ReadByte();
            field_3_reserved = (byte)in1.ReadByte();
        }

 /**
  * Constructs a Axis record and Sets its fields appropriately.
  *
  * @param in the RecordInputstream to Read the record from
  */
 public AxisRecord(RecordInputStream in1)
 {
     field_1_axisType = in1.ReadShort();
     field_2_reserved1 = in1.ReadInt();
     field_3_reserved2 = in1.ReadInt();
     field_4_reserved3 = in1.ReadInt();
     field_5_reserved4 = in1.ReadInt();
 }

        /**
         * Constructs a CategorySeriesAxis record and Sets its fields appropriately.
         *
         * @param in the RecordInputstream to Read the record from
         */

        public CategorySeriesAxisRecord(RecordInputStream in1)
    {
        field_1_crossingPoint = in1.ReadShort();
        field_2_labelFrequency = in1.ReadShort();
        field_3_tickMarkFrequency = in1.ReadShort();
        field_4_options = in1.ReadShort(); 
    
    }

        /**
         * Constructs a Chart record and Sets its fields appropriately.
         *
         * @param in the RecordInputstream to Read the record from
         */

        public ChartRecord(RecordInputStream in1)
        {
            field_1_x = in1.ReadInt();
            field_2_y = in1.ReadInt();
            field_3_width = in1.ReadInt();
            field_4_height = in1.ReadInt();

        }

 /**
  * Constructs a AxisParent record and s its fields appropriately.
  *
  * @param in the RecordInputstream to Read the record from
  */
 public AxisParentRecord(RecordInputStream in1)
 {
     field_1_axisType = in1.ReadShort();
     field_2_x = in1.ReadInt();
     field_3_y = in1.ReadInt();
     field_4_width = in1.ReadInt();
     field_5_height = in1.ReadInt();
 }

 /**
  * Constructs a FontBasis record and Sets its fields appropriately.
  *
  * @param in the RecordInputstream to Read the record from
  */
 public FontBasisRecord(RecordInputStream in1)
 {
     field_1_xBasis = in1.ReadShort();
     field_2_yBasis = in1.ReadShort();
     field_3_heightBasis = in1.ReadShort();
     field_4_scale = in1.ReadShort();
     field_5_indexToFontTable = in1.ReadShort();
 }

        /**
         * Constructs a LineFormat record and Sets its fields appropriately.
         *
         * @param in the RecordInputstream to Read the record from
         */

        public LineFormatRecord(RecordInputStream in1)
        {
            field_1_lineColor = in1.ReadInt();
            field_2_linePattern = in1.ReadShort();
            field_3_weight = in1.ReadShort();
            field_4_format = in1.ReadShort();
            field_5_colourPaletteIndex = in1.ReadShort();
        }

        /**
         * Constructs a CategorySeriesAxis record and Sets its fields appropriately.
         *
         * @param in the RecordInputstream to Read the record from
         */

        public CatSerRangeRecord(RecordInputStream in1)
        {
            field_1_catCross = in1.ReadShort();
            field_2_catLabel = in1.ReadShort();
            field_3_catMark = in1.ReadShort();
            field_4_options = in1.ReadShort();

        }

        /**
         * Constructs a LinkedData record and Sets its fields appropriately.
         *
         * @param in the RecordInputstream to Read the record from
         */

        public LinkedDataRecord(RecordInputStream in1)
        {
            field_1_linkType = (byte)in1.ReadByte();
            field_2_referenceType = (byte)in1.ReadByte();
            field_3_options = in1.ReadShort();
            field_4_indexNumberFmtRecord = in1.ReadShort();
            int encodedTokenLen = in1.ReadUShort();
            field_5_formulaOfLink = Formula.Read(encodedTokenLen, in1);
        }

 /**
  * Constructs a ValueRange record and Sets its fields appropriately.
  *
  * @param in the RecordInputstream to Read the record from
  */
 public ValueRangeRecord(RecordInputStream in1)
 {
     field_1_minimumAxisValue = in1.ReadDouble();
     field_2_maximumAxisValue = in1.ReadDouble();
     field_3_majorIncrement = in1.ReadDouble();
     field_4_minorIncrement = in1.ReadDouble();
     field_5_categoryAxisCross = in1.ReadDouble();
     field_6_options = in1.ReadShort();
 }

 public ChartStartBlockRecord(RecordInputStream in1)
 {
     rt = in1.ReadShort();
     grbitFrt = in1.ReadShort();
     iObjectKind = in1.ReadShort();
     iObjectContext = in1.ReadShort();
     iObjectInstance1 = in1.ReadShort();
     iObjectInstance2 = in1.ReadShort();
 }

 /**
  * Constructs a AreaFormat record and s its fields appropriately.
  *
  * @param in the RecordInputstream to Read the record from
  */
 public AreaFormatRecord(RecordInputStream in1)
 {
     field_1_foregroundColor = in1.ReadInt();
     field_2_backgroundColor = in1.ReadInt();
     field_3_pattern = in1.ReadShort();
     field_4_formatFlags = in1.ReadShort();
     field_5_forecolorIndex = in1.ReadShort();
     field_6_backcolorIndex = in1.ReadShort();
 }

 /**
  * Constructs a Series record and Sets its fields appropriately.
  *
  * @param in the RecordInputstream to Read the record from
  */
 public SeriesRecord(RecordInputStream in1)
 {
     field_1_categoryDataType = in1.ReadShort();
     field_2_valuesDataType = in1.ReadShort();
     field_3_numCategories = in1.ReadShort();
     field_4_numValues = in1.ReadShort();
     field_5_bubbleSeriesType = in1.ReadShort();
     field_6_numBubbleValues = in1.ReadShort();
 }

 public Chart3dRecord(RecordInputStream in1)
 {
     field_1_anRot = in1.ReadShort();
     field_2_anElev = in1.ReadShort();
     field_3_pcDist = in1.ReadShort();
     field_4_pcHeight = in1.ReadShort();
     field_5_pcDepth = in1.ReadShort();
     field_6_pcGap = in1.ReadShort();
     field_7_option = in1.ReadShort();
 }