npoi

1
using System;
2
using System.Collections.Generic;
3
using System.Text;
4
using System.Xml.Serialization;
5
using System.ComponentModel;
6
using System.IO;
7
using System.Xml;
8
using NPOI.OpenXml4Net.Util;
9

10
namespace NPOI.OpenXmlFormats.Vml.Spreadsheet
11
{
12
    [System.ComponentModel.DesignerCategory("code")]
13
    public class CT_ClientData
14
    {
15
        public CT_ClientData()
16
        {
17
            this.rowField = new List<int>();
18
            this.columnField = new List<int>();
19
        }
20
        private ST_ObjectType objectTypeField;
21

22
        private static XmlQualifiedName MOVEWITHCELLS = new XmlQualifiedName("MoveWithCells", "urn:schemas-microsoft-com:office:excel");
23
        private static XmlQualifiedName SIZEWITHCELLS = new XmlQualifiedName("SizeWithCells", "urn:schemas-microsoft-com:office:excel");
24
        private static XmlQualifiedName ANCHOR = new XmlQualifiedName("Anchor", "urn:schemas-microsoft-com:office:excel");
25
        private static XmlQualifiedName LOCKED = new XmlQualifiedName("Locked", "urn:schemas-microsoft-com:office:excel");
26
        private static XmlQualifiedName DEFAULTSIZE = new XmlQualifiedName("DefaultSize", "urn:schemas-microsoft-com:office:excel");
27
        private static XmlQualifiedName PRINTOBJECT = new XmlQualifiedName("PrintObject", "urn:schemas-microsoft-com:office:excel");
28
        private static XmlQualifiedName DISABLED = new XmlQualifiedName("Disabled", "urn:schemas-microsoft-com:office:excel");
29
        private static XmlQualifiedName AUTOFILL = new XmlQualifiedName("AutoFill", "urn:schemas-microsoft-com:office:excel");
30
        private static XmlQualifiedName AUTOLINE = new XmlQualifiedName("AutoLine", "urn:schemas-microsoft-com:office:excel");
31
        private static XmlQualifiedName AUTOPICT = new XmlQualifiedName("AutoPict", "urn:schemas-microsoft-com:office:excel");
32
        private static XmlQualifiedName FMLAMACRO = new XmlQualifiedName("FmlaMacro", "urn:schemas-microsoft-com:office:excel");
33
        private static XmlQualifiedName TEXTHALIGN = new XmlQualifiedName("TextHAlign", "urn:schemas-microsoft-com:office:excel");
34
        private static XmlQualifiedName TEXTVALIGN = new XmlQualifiedName("TextVAlign", "urn:schemas-microsoft-com:office:excel");
35
        private static XmlQualifiedName LOCKTEXT = new XmlQualifiedName("LockText", "urn:schemas-microsoft-com:office:excel");
36
        private static XmlQualifiedName JUSTLASTX = new XmlQualifiedName("JustLastX", "urn:schemas-microsoft-com:office:excel");
37
        private static XmlQualifiedName SECRETEDIT = new XmlQualifiedName("SecretEdit", "urn:schemas-microsoft-com:office:excel");
38
        private static XmlQualifiedName DEFAULT = new XmlQualifiedName("Default", "urn:schemas-microsoft-com:office:excel");
39
        private static XmlQualifiedName HELP = new XmlQualifiedName("Help", "urn:schemas-microsoft-com:office:excel");
40
        private static XmlQualifiedName CANCEL = new XmlQualifiedName("Cancel", "urn:schemas-microsoft-com:office:excel");
41
        private static XmlQualifiedName DISMISS = new XmlQualifiedName("Dismiss", "urn:schemas-microsoft-com:office:excel");
42
        private static XmlQualifiedName ACCEL = new XmlQualifiedName("Accel", "urn:schemas-microsoft-com:office:excel");
43
        private static XmlQualifiedName ACCEL2 = new XmlQualifiedName("Accel2", "urn:schemas-microsoft-com:office:excel");
44
        private static XmlQualifiedName ROW = new XmlQualifiedName("Row", "urn:schemas-microsoft-com:office:excel");
45
        private static XmlQualifiedName COLUMN = new XmlQualifiedName("Column", "urn:schemas-microsoft-com:office:excel");
46
        private static XmlQualifiedName VISIBLE = new XmlQualifiedName("Visible", "urn:schemas-microsoft-com:office:excel");
47
        private static XmlQualifiedName ROWHIDDEN = new XmlQualifiedName("RowHidden", "urn:schemas-microsoft-com:office:excel");
48
        private static XmlQualifiedName COLHIDDEN = new XmlQualifiedName("ColHidden", "urn:schemas-microsoft-com:office:excel");
49
        private static XmlQualifiedName VTEDIT = new XmlQualifiedName("VTEdit", "urn:schemas-microsoft-com:office:excel");
50
        private static XmlQualifiedName MULTILINE = new XmlQualifiedName("MultiLine", "urn:schemas-microsoft-com:office:excel");
51
        private static XmlQualifiedName VSCROLL = new XmlQualifiedName("VScroll", "urn:schemas-microsoft-com:office:excel");
52
        private static XmlQualifiedName VALIDIDS = new XmlQualifiedName("ValidIds", "urn:schemas-microsoft-com:office:excel");
53
        private static XmlQualifiedName FMLARANGE = new XmlQualifiedName("FmlaRange", "urn:schemas-microsoft-com:office:excel");
54
        private static XmlQualifiedName WIDTHMIN = new XmlQualifiedName("WidthMin", "urn:schemas-microsoft-com:office:excel");
55
        private static XmlQualifiedName SEL = new XmlQualifiedName("Sel", "urn:schemas-microsoft-com:office:excel");
56
        private static XmlQualifiedName NOTHREED2 = new XmlQualifiedName("NoThreeD2", "urn:schemas-microsoft-com:office:excel");
57
        private static XmlQualifiedName SELTYPE = new XmlQualifiedName("SelType", "urn:schemas-microsoft-com:office:excel");
58
        private static XmlQualifiedName MULTISEL = new XmlQualifiedName("MultiSel", "urn:schemas-microsoft-com:office:excel");
59
        private static XmlQualifiedName LCT = new XmlQualifiedName("LCT", "urn:schemas-microsoft-com:office:excel");
60
        private static XmlQualifiedName LISTITEM = new XmlQualifiedName("ListItem", "urn:schemas-microsoft-com:office:excel");
61
        private static XmlQualifiedName DROPSTYLE = new XmlQualifiedName("DropStyle", "urn:schemas-microsoft-com:office:excel");
62
        private static XmlQualifiedName COLORED = new XmlQualifiedName("Colored", "urn:schemas-microsoft-com:office:excel");
63
        private static XmlQualifiedName DROPLINES = new XmlQualifiedName("DropLines", "urn:schemas-microsoft-com:office:excel");
64
        private static XmlQualifiedName CHECKED = new XmlQualifiedName("Checked", "urn:schemas-microsoft-com:office:excel");
65
        private static XmlQualifiedName FMLALINK = new XmlQualifiedName("FmlaLink", "urn:schemas-microsoft-com:office:excel");
66
        private static XmlQualifiedName FMLAPICT = new XmlQualifiedName("FmlaPict", "urn:schemas-microsoft-com:office:excel");
67
        private static XmlQualifiedName NOTHREED = new XmlQualifiedName("NoThreeD", "urn:schemas-microsoft-com:office:excel");
68
        private static XmlQualifiedName FIRSTBUTTON = new XmlQualifiedName("FirstButton", "urn:schemas-microsoft-com:office:excel");
69
        private static XmlQualifiedName FMLAGROUP = new XmlQualifiedName("FmlaGroup", "urn:schemas-microsoft-com:office:excel");
70
        private static XmlQualifiedName VAL = new XmlQualifiedName("Val", "urn:schemas-microsoft-com:office:excel");
71
        private static XmlQualifiedName MIN = new XmlQualifiedName("Min", "urn:schemas-microsoft-com:office:excel");
72
        private static XmlQualifiedName MAX = new XmlQualifiedName("Max", "urn:schemas-microsoft-com:office:excel");
73
        private static XmlQualifiedName INC = new XmlQualifiedName("Inc", "urn:schemas-microsoft-com:office:excel");
74
        private static XmlQualifiedName PAGE = new XmlQualifiedName("Page", "urn:schemas-microsoft-com:office:excel");
75
        private static XmlQualifiedName HORIZ = new XmlQualifiedName("Horiz", "urn:schemas-microsoft-com:office:excel");
76
        private static XmlQualifiedName DX = new XmlQualifiedName("Dx", "urn:schemas-microsoft-com:office:excel");
77
        private static XmlQualifiedName MAPOCX = new XmlQualifiedName("MapOCX", "urn:schemas-microsoft-com:office:excel");
78
        private static XmlQualifiedName CF = new XmlQualifiedName("CF", "urn:schemas-microsoft-com:office:excel");
79
        private static XmlQualifiedName CAMERA = new XmlQualifiedName("Camera", "urn:schemas-microsoft-com:office:excel");
80
        private static XmlQualifiedName RECALCALWAYS = new XmlQualifiedName("RecalcAlways", "urn:schemas-microsoft-com:office:excel");
81
        private static XmlQualifiedName AUTOSCALE = new XmlQualifiedName("AutoScale", "urn:schemas-microsoft-com:office:excel");
82
        private static XmlQualifiedName DDE = new XmlQualifiedName("DDE", "urn:schemas-microsoft-com:office:excel");
83
        private static XmlQualifiedName UIOBJ = new XmlQualifiedName("UIObj", "urn:schemas-microsoft-com:office:excel");
84
        private static XmlQualifiedName SCRIPTTEXT = new XmlQualifiedName("ScriptText", "urn:schemas-microsoft-com:office:excel");
85
        private static XmlQualifiedName SCRIPTEXTENDED = new XmlQualifiedName("ScriptExtended", "urn:schemas-microsoft-com:office:excel");
86
        private static XmlQualifiedName SCRIPTLANGUAGE = new XmlQualifiedName("ScriptLanguage", "urn:schemas-microsoft-com:office:excel");
87
        private static XmlQualifiedName SCRIPTLOCATION = new XmlQualifiedName("ScriptLocation", "urn:schemas-microsoft-com:office:excel");
88
        private static XmlQualifiedName FMLATXBX = new XmlQualifiedName("FmlaTxbx", "urn:schemas-microsoft-com:office:excel");
89
        private static XmlQualifiedName OBJECTTYPE = new XmlQualifiedName("ObjectType", "");
90

91
        //[XmlElement("Accel", typeof(string), DataType = "integer")]
92
        //[XmlElement("Accel2", typeof(string), DataType = "integer")]
93
        //[XmlElement("Anchor", typeof(string))]
94
        //[XmlElement("AutoFill", typeof(ST_TrueFalseBlank))]
95
        //[XmlElement("AutoLine", typeof(ST_TrueFalseBlank))]
96
        //[XmlElement("AutoPict", typeof(ST_TrueFalseBlank))]
97
        //[XmlElement("AutoScale", typeof(ST_TrueFalseBlank))]
98
        //[XmlElement("CF", typeof(ST_CF))]
99
        //[XmlElement("Camera", typeof(ST_TrueFalseBlank))]
100
        //[XmlElement("Cancel", typeof(ST_TrueFalseBlank))]
101
        //[XmlElement("Checked", typeof(string), DataType = "integer")]
102
        //[XmlElement("ColHidden", typeof(ST_TrueFalseBlank))]
103
        //[XmlElement("Colored", typeof(ST_TrueFalseBlank))]
104
        //[XmlElement("Column", typeof(string), DataType = "integer")]
105
        //[XmlElement("DDE", typeof(ST_TrueFalseBlank))]
106
        //[XmlElement("Default", typeof(ST_TrueFalseBlank))]
107
        //[XmlElement("DefaultSize", typeof(ST_TrueFalseBlank))]
108
        //[XmlElement("Disabled", typeof(ST_TrueFalseBlank))]
109
        //[XmlElement("Dismiss", typeof(ST_TrueFalseBlank))]
110
        //[XmlElement("DropLines", typeof(string), DataType = "integer")]
111
        //[XmlElement("DropStyle", typeof(string))]
112
        //[XmlElement("Dx", typeof(string), DataType = "integer")]
113
        //[XmlElement("FirstButton", typeof(ST_TrueFalseBlank))]
114
        //[XmlElement("FmlaGroup", typeof(string))]
115
        //[XmlElement("FmlaLink", typeof(string))]
116
        //[XmlElement("FmlaMacro", typeof(string))]
117
        //[XmlElement("FmlaPict", typeof(string))]
118
        //[XmlElement("FmlaRange", typeof(string))]
119
        //[XmlElement("FmlaTxbx", typeof(string))]
120
        //[XmlElement("Help", typeof(ST_TrueFalseBlank))]
121
        //[XmlElement("Horiz", typeof(ST_TrueFalseBlank))]
122
        //[XmlElement("Inc", typeof(string), DataType = "integer")]
123
        //[XmlElement("JustLastX", typeof(ST_TrueFalseBlank))]
124
        //[XmlElement("LCT", typeof(string))]
125
        //[XmlElement("ListItem", typeof(string))]
126
        //[XmlElement("LockText", typeof(ST_TrueFalseBlank))]
127
        //[XmlElement("Locked", typeof(ST_TrueFalseBlank))]
128
        //[XmlElement("MapOCX", typeof(ST_TrueFalseBlank))]
129
        //[XmlElement("Max", typeof(string), DataType = "integer")]
130
        //[XmlElement("Min", typeof(string), DataType = "integer")]
131
        //[XmlElement("MoveWithCells", typeof(ST_TrueFalseBlank))]
132
        //[XmlElement("MultiLine", typeof(ST_TrueFalseBlank))]
133
        //[XmlElement("MultiSel", typeof(string))]
134
        //[XmlElement("NoThreeD", typeof(ST_TrueFalseBlank))]
135
        //[XmlElement("NoThreeD2", typeof(ST_TrueFalseBlank))]
136
        //[XmlElement("Page", typeof(string), DataType = "integer")]
137
        //[XmlElement("PrintObject", typeof(ST_TrueFalseBlank))]
138
        //[XmlElement("RecalcAlways", typeof(ST_TrueFalseBlank))]
139
        //[XmlElement("Row", typeof(string), DataType = "integer")]
140
        //[XmlElement("RowHidden", typeof(ST_TrueFalseBlank))]
141
        //[XmlElement("ScriptExtended", typeof(string))]
142
        //[XmlElement("ScriptLanguage", typeof(string), DataType = "nonNegativeInteger")]
143
        //[XmlElement("ScriptLocation", typeof(string), DataType = "nonNegativeInteger")]
144
        //[XmlElement("ScriptText", typeof(string))]
145
        //[XmlElement("SecretEdit", typeof(ST_TrueFalseBlank))]
146
        //[XmlElement("Sel", typeof(string), DataType = "integer")]
147
        //[XmlElement("SelType", typeof(string))]
148
        //[XmlElement("SizeWithCells", typeof(ST_TrueFalseBlank))]
149
        //[XmlElement("TextHAlign", typeof(string))]
150
        //[XmlElement("TextVAlign", typeof(string))]
151
        //[XmlElement("UIObj", typeof(ST_TrueFalseBlank))]
152
        //[XmlElement("VScroll", typeof(ST_TrueFalseBlank))]
153
        //[XmlElement("VTEdit", typeof(string), DataType = "integer")]
154
        //[XmlElement("Val", typeof(string), DataType = "integer")]
155
        //[XmlElement("ValidIds", typeof(ST_TrueFalseBlank))]
156
        //[XmlElement("Visible", typeof(ST_TrueFalseBlank))]
157
        //[XmlElement("WidthMin", typeof(string), DataType = "integer")]
158
        //[XmlChoiceIdentifier("ItemsElementName")]
159
        //public List<object> Items
160
        //{
161
        //    get
162
        //    {
163
        //        return this.itemsField;
164
        //    }
165
        //    set
166
        //    {
167
        //        this.itemsField = value;
168
        //    }
169
        //}
170
        public static CT_ClientData Parse(XmlNode node, XmlNamespaceManager namespaceManager)
171
        {
172
            if (node == null)
173
                return null;
174
            CT_ClientData ctObj = new CT_ClientData();
175
            if (node.Attributes["ObjectType"] != null)
176
                ctObj.ObjectType = (ST_ObjectType)Enum.Parse(typeof(ST_ObjectType), node.Attributes["ObjectType"].Value);
177
            ctObj.column = new List<Int32>();
178
            ctObj.row = new List<Int32>();
179
            foreach (XmlNode childNode in node.ChildNodes)
180
            {
181
                if (childNode.LocalName == "Anchor")
182
                    ctObj.anchor = childNode.InnerText;
183
                else if (childNode.LocalName == "AutoFill")
184
                    ctObj.autoFill = NPOI.OpenXmlFormats.Util.XmlHelper.ReadTrueFalseBlank(childNode.InnerText);
185
                else if (childNode.LocalName == "Visible")
186
                    ctObj.visible = NPOI.OpenXmlFormats.Util.XmlHelper.ReadTrueFalseBlank(childNode.InnerText);
187
                else if (childNode.LocalName == "MoveWithCells")
188
                    ctObj.moveWithCells = NPOI.OpenXmlFormats.Util.XmlHelper.ReadTrueFalseBlank(childNode.InnerText);
189
                else if (childNode.LocalName == "SizeWithCells")
190
                    ctObj.sizeWithCells = NPOI.OpenXmlFormats.Util.XmlHelper.ReadTrueFalseBlank(childNode.InnerText);
191
                else if (childNode.LocalName == "Column")
192
                    ctObj.column.Add(Int32.Parse(childNode.InnerText));
193
                else if (childNode.LocalName == "Row")
194
                    ctObj.row.Add(Int32.Parse(childNode.InnerText));
195
            }
196
            return ctObj;
197
        }
198

199

200

201
        internal void Write(StreamWriter sw, string nodeName)
202
        {
203
            sw.Write(string.Format("<x:{0}", nodeName));
204
            XmlHelper.WriteAttribute(sw, "ObjectType", this.ObjectType.ToString());
205
            sw.Write(">");
206
            if (this.moveWithCells == ST_TrueFalseBlank.t || this.moveWithCells == ST_TrueFalseBlank.@true)
207
                sw.Write(string.Format("<x:MoveWithCells/>", this.moveWithCells));
208
            if (this.sizeWithCells == ST_TrueFalseBlank.t || this.sizeWithCells == ST_TrueFalseBlank.@true)
209
                sw.Write(string.Format("<x:SizeWithCells/>", this.sizeWithCells));
210
            if (this.anchor != null)
211
                sw.Write(string.Format("<x:Anchor>{0}</x:Anchor>", this.anchor));
212
            if (this.autoFill != ST_TrueFalseBlank.NONE)
213
                sw.Write(string.Format("<x:AutoFill>{0}</x:AutoFill>", this.autoFill));
214
            if (this.visible != ST_TrueFalseBlank.NONE)
215
                sw.Write(string.Format("<x:Visible>{0}</x:Visible>", this.visible));
216
            if (this.row != null)
217
            {
218
                foreach (Int32 x in this.row)
219
                {
220
                    sw.Write(string.Format("<x:Row>{0}</x:Row>", x));
221
                }
222
            }
223
            if (this.column != null)
224
            {
225
                foreach (Int32 x in this.column)
226
                {
227
                    sw.Write(string.Format("<x:Column>{0}</x:Column>", x));
228
                }
229
            }
230
            sw.Write(string.Format("</x:{0}>", nodeName));
231
        }
232

233

234
        public void AddNewRow(int rowNum)
235
        {
236
            if (rowField != null)
237
            {
238
                rowField.Add(rowNum);
239
            }
240
        }
241
        public void AddNewColumn(int columnNum)
242
        {
243
            if (columnField != null)
244
            {
245
                columnField.Add(columnNum);
246
            }
247
        }
248

249
        public void AddNewMoveWithCells()
250
        {
251
            this.moveWithCellsField = ST_TrueFalseBlank.t;
252
            this.moveWithCellsFieldSpecified = true;
253
        }
254
        public void AddNewSizeWithCells()
255
        {
256
            this.sizeWithCellsField = ST_TrueFalseBlank.t;
257
            this.sizeWithCellsFieldSpecified = true;
258
        }
259
        private string anchorField;
260
        [XmlElement(ElementName = "Anchor")]
261
        public string anchor
262
        {
263
            get { return this.anchorField; }
264
            set { this.anchorField = value; }
265
        }
266

267
        public void AddNewAnchor(string name)
268
        {
269
            this.anchorField = name;
270
        }
271

272
        public void AddNewAutoFill(ST_TrueFalseBlank value)
273
        {
274
            this.autoFillField = value;
275
            this.autoFillFieldSpecified = true;
276
        }
277

278
        ST_TrueFalseBlank autoFillField = ST_TrueFalseBlank.NONE;
279
        bool autoFillFieldSpecified = false;
280

281
        [XmlElement(ElementName = "AutoFill")]
282
        [DefaultValue(ST_TrueFalseBlank.NONE)]
283
        public ST_TrueFalseBlank autoFill
284
        {
285
            get { return this.autoFillField; }
286
            set { this.autoFillField = value; }
287
        }
288
        [XmlIgnore]
289
        public bool autoFillSpecified
290
        {
291
            get { return this.autoFillFieldSpecified; }
292
            set { this.autoFillFieldSpecified = value; }
293
        }
294

295
        ST_TrueFalseBlank visibleField = ST_TrueFalseBlank.NONE;
296
        bool visibleFieldSpecified = false;
297

298
        [XmlElement(ElementName = "Visible")]
299
        [DefaultValue(ST_TrueFalseBlank.NONE)]
300
        public ST_TrueFalseBlank visible
301
        {
302
            get { return this.visibleField; }
303
            set { this.visibleField = value; }
304
        }
305
        [XmlIgnore]
306
        public bool visibleSpecified
307
        {
308
            get { return this.visibleFieldSpecified; }
309
            set { this.visibleFieldSpecified = value; }
310
        }
311

312
        ST_TrueFalseBlank moveWithCellsField = ST_TrueFalseBlank.NONE;
313
        bool moveWithCellsFieldSpecified = false;
314

315
        [XmlElement(ElementName = "MoveWithCells")]
316
        [DefaultValue(ST_TrueFalseBlank.NONE)]
317
        public ST_TrueFalseBlank moveWithCells
318
        {
319
            get { return this.moveWithCellsField; }
320
            set { this.moveWithCellsField = value; }
321
        }
322
        [XmlIgnore]
323
        public bool moveWithCellsSpecified
324
        {
325
            get { return this.moveWithCellsFieldSpecified; }
326
            set { this.moveWithCellsFieldSpecified = value; }
327
        }
328
        public int SizeOfMoveWithCellsArray()
329
        {
330
            return moveWithCellsSpecified ? 1 : 0;
331
        }
332
        public int SizeOfSizeWithCellsArray()
333
        {
334
            return sizeWithCellsFieldSpecified ? 1 : 0;
335
        }
336
        ST_TrueFalseBlank sizeWithCellsField = ST_TrueFalseBlank.NONE;
337
        bool sizeWithCellsFieldSpecified = false;
338

339
        [XmlElement(ElementName = "SizeWithCells")]
340
        [DefaultValue(ST_TrueFalseBlank.NONE)]
341
        public ST_TrueFalseBlank sizeWithCells
342
        {
343
            get { return this.sizeWithCellsField; }
344
            set { this.sizeWithCellsField = value; }
345
        }
346
        [XmlIgnore]
347
        public bool sizeWithCellsSpecified
348
        {
349
            get { return this.sizeWithCellsFieldSpecified; }
350
            set { this.sizeWithCellsFieldSpecified = value; }
351
        }
352

353

354
        private List<int> columnField;
355
        [XmlElement(ElementName = "Column")]
356
        public List<int> column
357
        {
358
            get { return this.columnField; }
359
            set { this.columnField = value; }
360
        }
361
        public int GetColumnArray(int index)
362
        {
363
            return this.columnField[index];
364
        }
365
        public void SetColumnArray(int index, int value)
366
        {
367
            this.columnField[index] = value;
368
        }
369
        public void SetRowArray(int index, int value)
370
        {
371
            this.rowField[index] = value;
372
        }
373
        public void SetAnchorArray(int index, string value)
374
        {
375
            AddNewAnchor(value);
376
        }
377
        private List<int> rowField;
378

379
        [XmlElement(ElementName = "Row")]
380
        public List<int> row
381
        {
382
            get { return this.rowField; }
383
            set { this.rowField = value; }
384
        }
385

386
        public int GetRowArray(int index)
387
        {
388
            return this.rowField[index];
389
        }
390

391
        [XmlAttribute]
392
        public ST_ObjectType ObjectType
393
        {
394
            get
395
            {
396
                return this.objectTypeField;
397
            }
398
            set
399
            {
400
                this.objectTypeField = value;
401
            }
402
        }
403

404
        public string GetAnchorArray(int p)
405
        {
406
            return this.anchor;
407
        }
408
    }
409

410

411
    [Serializable]
412
    [XmlType(Namespace = "urn:schemas-microsoft-com:office:excel")]
413
    [XmlRoot(Namespace = "urn:schemas-microsoft-com:office:excel", IsNullable = false)]
414
    public enum ST_TrueFalseBlank
415
    {
416
        //[XmlEnum("")]
417
        NONE, //Blank - Default Value
418

419
        [XmlEnum("True")]
420
        @true, //Logical True
421
        t,//Logical True
422

423
        [XmlEnum("False")]
424
        @false, //Logical False
425
        f,//Logical False
426
    }
427

428

429
    [Serializable]
430
    [XmlType(Namespace = "urn:schemas-microsoft-com:office:excel")]
431
    [XmlRoot(Namespace = "urn:schemas-microsoft-com:office:excel", IsNullable = false)]
432
    public enum ST_CF
433
    {
434

435

436
        PictOld,
437

438

439
        Pict,
440

441

442
        Bitmap,
443

444

445
        PictPrint,
446

447

448
        PictScreen,
449
    }
450

451

452
    [Serializable]
453
    [XmlType(Namespace = "urn:schemas-microsoft-com:office:excel", IncludeInSchema = false)]
454
    public enum ItemsChoiceType
455
    {
456

457

458
        Accel,
459

460

461
        Accel2,
462

463

464
        Anchor,
465

466

467
        AutoFill,
468

469

470
        AutoLine,
471

472

473
        AutoPict,
474

475

476
        AutoScale,
477

478

479
        CF,
480

481

482
        Camera,
483

484

485
        Cancel,
486

487

488
        Checked,
489

490

491
        ColHidden,
492

493

494
        Colored,
495

496

497
        Column,
498

499

500
        DDE,
501

502

503
        Default,
504

505

506
        DefaultSize,
507

508

509
        Disabled,
510

511

512
        Dismiss,
513

514

515
        DropLines,
516

517

518
        DropStyle,
519

520

521
        Dx,
522

523

524
        FirstButton,
525

526

527
        FmlaGroup,
528

529

530
        FmlaLink,
531

532

533
        FmlaMacro,
534

535

536
        FmlaPict,
537

538

539
        FmlaRange,
540

541

542
        FmlaTxbx,
543

544

545
        Help,
546

547

548
        Horiz,
549

550

551
        Inc,
552

553

554
        JustLastX,
555

556

557
        LCT,
558

559

560
        ListItem,
561

562

563
        LockText,
564

565

566
        Locked,
567

568

569
        MapOCX,
570

571

572
        Max,
573

574

575
        Min,
576

577

578
        MoveWithCells,
579

580

581
        MultiLine,
582

583

584
        MultiSel,
585

586

587
        NoThreeD,
588

589

590
        NoThreeD2,
591

592

593
        Page,
594

595

596
        PrintObject,
597

598

599
        RecalcAlways,
600

601

602
        Row,
603

604

605
        RowHidden,
606

607

608
        ScriptExtended,
609

610

611
        ScriptLanguage,
612

613

614
        ScriptLocation,
615

616

617
        ScriptText,
618

619

620
        SecretEdit,
621

622

623
        Sel,
624

625

626
        SelType,
627

628

629
        SizeWithCells,
630

631

632
        TextHAlign,
633

634

635
        TextVAlign,
636

637

638
        UIObj,
639

640

641
        VScroll,
642

643

644
        VTEdit,
645

646

647
        Val,
648

649

650
        ValidIds,
651

652

653
        Visible,
654

655

656
        WidthMin,
657
    }
658

659

660
    [Serializable]
661
    [XmlType(Namespace = "urn:schemas-microsoft-com:office:excel")]
662
    [XmlRoot(Namespace = "urn:schemas-microsoft-com:office:excel", IsNullable = false)]
663
    public enum ST_ObjectType
664
    {
665

666

667
        Button,
668

669

670
        Checkbox,
671

672

673
        Dialog,
674

675

676
        Drop,
677

678

679
        Edit,
680

681

682
        GBox,
683

684

685
        Label,
686

687

688
        LineA,
689

690

691
        List,
692

693

694
        Movie,
695

696

697
        Note,
698

699

700
        Pict,
701

702

703
        Radio,
704

705

706
        RectA,
707

708

709
        Scroll,
710

711

712
        Spin,
713

714

715
        Shape,
716

717

718
        Group,
719

720

721
        Rect,
722
    }
723
}
724