Last change
on this file since 12214 was
9580,
checked in by sforsten, 12 years ago
|
#1730:
- added SymbolicDataAnalysisExpressionExcelFormatter
- changed modifiers in SymbolicExpressionTreeChart of methods SaveImageAsBitmap and SaveImageAsEmf to public
- added menu item ExportSymbolicSolutionToExcelMenuItem to export a symbolic solution to an excel file
- added EPPlus-3.1.3 to ExtLibs
|
File size:
2.7 KB
|
Line | |
---|
1 | using System;
|
---|
2 | using System.Collections.Generic;
|
---|
3 | using System.Linq;
|
---|
4 | using System.Text;
|
---|
5 | using System.Xml;
|
---|
6 |
|
---|
7 | namespace OfficeOpenXml.Style.Dxf
|
---|
8 | {
|
---|
9 | public class ExcelDxfNumberFormat : DxfStyleBase<ExcelDxfNumberFormat>
|
---|
10 | {
|
---|
11 | public ExcelDxfNumberFormat(ExcelStyles styles) : base(styles)
|
---|
12 | {
|
---|
13 |
|
---|
14 | }
|
---|
15 | int _numFmtID=int.MinValue;
|
---|
16 | /// <summary>
|
---|
17 | /// Id for number format
|
---|
18 | ///
|
---|
19 | /// Build in ID's
|
---|
20 | ///
|
---|
21 | /// 0 General
|
---|
22 | /// 1 0
|
---|
23 | /// 2 0.00
|
---|
24 | /// 3 #,##0
|
---|
25 | /// 4 #,##0.00
|
---|
26 | /// 9 0%
|
---|
27 | /// 10 0.00%
|
---|
28 | /// 11 0.00E+00
|
---|
29 | /// 12 # ?/?
|
---|
30 | /// 13 # ??/??
|
---|
31 | /// 14 mm-dd-yy
|
---|
32 | /// 15 d-mmm-yy
|
---|
33 | /// 16 d-mmm
|
---|
34 | /// 17 mmm-yy
|
---|
35 | /// 18 h:mm AM/PM
|
---|
36 | /// 19 h:mm:ss AM/PM
|
---|
37 | /// 20 h:mm
|
---|
38 | /// 21 h:mm:ss
|
---|
39 | /// 22 m/d/yy h:mm
|
---|
40 | /// 37 #,##0 ;(#,##0)
|
---|
41 | /// 38 #,##0 ;[Red](#,##0)
|
---|
42 | /// 39 #,##0.00;(#,##0.00)
|
---|
43 | /// 40 #,##0.00;[Red](#,##0.00)
|
---|
44 | /// 45 mm:ss
|
---|
45 | /// 46 [h]:mm:ss
|
---|
46 | /// 47 mmss.0
|
---|
47 | /// 48 ##0.0E+0
|
---|
48 | /// 49 @
|
---|
49 | /// </summary>
|
---|
50 | public int NumFmtID
|
---|
51 | {
|
---|
52 | get
|
---|
53 | {
|
---|
54 | return _numFmtID;
|
---|
55 | }
|
---|
56 | internal set
|
---|
57 | {
|
---|
58 | _numFmtID = value;
|
---|
59 | }
|
---|
60 | }
|
---|
61 | string _format="";
|
---|
62 | public string Format
|
---|
63 | {
|
---|
64 | get
|
---|
65 | {
|
---|
66 | return _format;
|
---|
67 | }
|
---|
68 | set
|
---|
69 | {
|
---|
70 | _format = value;
|
---|
71 | NumFmtID = ExcelNumberFormat.GetFromBuildIdFromFormat(value);
|
---|
72 | }
|
---|
73 | }
|
---|
74 |
|
---|
75 | protected internal override string Id
|
---|
76 | {
|
---|
77 | get
|
---|
78 | {
|
---|
79 | return Format;
|
---|
80 | }
|
---|
81 | }
|
---|
82 |
|
---|
83 | protected internal override void CreateNodes(XmlHelper helper, string path)
|
---|
84 | {
|
---|
85 | if (NumFmtID < 0 && !string.IsNullOrEmpty(Format))
|
---|
86 | {
|
---|
87 | NumFmtID = _styles._nextDfxNumFmtID++;
|
---|
88 | }
|
---|
89 | helper.CreateNode(path);
|
---|
90 | SetValue(helper, path + "/@numFmtId", NumFmtID);
|
---|
91 | SetValue(helper, path + "/@formatCode", Format);
|
---|
92 | }
|
---|
93 | protected internal override bool HasValue
|
---|
94 | {
|
---|
95 | get
|
---|
96 | {
|
---|
97 | return !string.IsNullOrEmpty(Format);
|
---|
98 | }
|
---|
99 | }
|
---|
100 | protected internal override ExcelDxfNumberFormat Clone()
|
---|
101 | {
|
---|
102 | return new ExcelDxfNumberFormat(_styles) { NumFmtID = NumFmtID, Format = Format };
|
---|
103 | }
|
---|
104 | }
|
---|
105 | }
|
---|
Note: See
TracBrowser
for help on using the repository browser.