zhao
2021-06-24 02ca96debc6056275d58e55d97f7885a195542d0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
 
namespace HH.WMS.Utils.ExcelLibrary.BinaryFileFormat
{
    public partial class FORMULA : Record
    {
        public FORMULA(Record record) : base(record) { }
 
        public FORMULA()
        {
            this.Type = RecordType.FORMULA;
        }
 
        public UInt16 RowIndex;
 
        public UInt16 ColIndex;
 
        public UInt16 XFIndex;
 
        /// <summary>
        /// Result of the formula.
        /// </summary>
        public UInt64 Result;
 
        public UInt16 OptionFlags;
 
        public UInt32 Unused;
 
        /// <summary>
        /// Formula data (RPN token array)
        /// </summary>
        public Byte[] FormulaData;
 
        public override void Decode()
        {
            MemoryStream stream = new MemoryStream(Data);
            BinaryReader reader = new BinaryReader(stream);
            this.RowIndex = reader.ReadUInt16();
            this.ColIndex = reader.ReadUInt16();
            this.XFIndex = reader.ReadUInt16();
            this.Result = reader.ReadUInt64();
            this.OptionFlags = reader.ReadUInt16();
            this.Unused = reader.ReadUInt32();
            this.FormulaData = reader.ReadBytes((int)(stream.Length - stream.Position));
        }
 
        public override void Encode()
        {
            MemoryStream stream = new MemoryStream();
            BinaryWriter writer = new BinaryWriter(stream);
            writer.Write(RowIndex);
            writer.Write(ColIndex);
            writer.Write(XFIndex);
            writer.Write(Result);
            writer.Write(OptionFlags);
            writer.Write(Unused);
            writer.Write(FormulaData);
            this.Data = stream.ToArray();
            this.Size = (UInt16)Data.Length;
            base.Encode();
        }
 
    }
}