forked from carmel/gooxml
/
defaultnumberformats.go
119 lines (113 loc) · 4.4 KB
/
defaultnumberformats.go
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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
// Copyright 2017 Baliance. All rights reserved.
//
// Use of this source code is governed by the terms of the Affero GNU General
// Public License version 3.0 as published by the Free Software Foundation and
// appearing in the file LICENSE included in the packaging of this file. A
// commercial license can be purchased by contacting sales@baliance.com.
package spreadsheet
import "github.com/codrocker/gooxml/schema/soo/sml"
// StandardFormat is a standard ECMA 376 number format.
//
//go:generate stringer -type=StandardFormat
type StandardFormat uint32
// StandardFormat constants, extracted from ECMA-376 Part 1 Section 18.8.30
const (
StandardFormatGeneral StandardFormat = 0 // General
StandardFormat0 StandardFormat = 0 // General
StandardFormatWholeNumber StandardFormat = 1 // 0
StandardFormat1 StandardFormat = 1 // 0
StandardFormat2 StandardFormat = 2 // 0.00
StandardFormat3 StandardFormat = 3 // #,##0
StandardFormat4 StandardFormat = 4 // #,##0.00
StandardFormatPercent StandardFormat = 9 // 0%
StandardFormat9 StandardFormat = 9 // 0%
StandardFormat10 StandardFormat = 10 // 0.00%
StandardFormat11 StandardFormat = 11 // 0.00E+00
StandardFormat12 StandardFormat = 12 // # ?/?
StandardFormat13 StandardFormat = 13 // # ??/??
StandardFormatDate StandardFormat = 14 // m/d/yy
StandardFormat14 StandardFormat = 14 // m/d/yy
StandardFormat15 StandardFormat = 15 // d-mmm-yy
StandardFormat16 StandardFormat = 16 // d-mmm
StandardFormat17 StandardFormat = 17 // mmm-yy
StandardFormat18 StandardFormat = 18 // h:mm AM/PM
StandardFormatTime StandardFormat = 19 // h:mm:ss AM/PM
StandardFormat19 StandardFormat = 19 // h:mm:ss AM/PM
StandardFormat20 StandardFormat = 20 // h:mm
StandardFormat21 StandardFormat = 21 // h:mm:ss
StandardFormatDateTime StandardFormat = 22 // m/d/yy h:mm
StandardFormat22 StandardFormat = 22 // m/d/yy h:mm
StandardFormat37 StandardFormat = 37 // #,##0 ;(#,##0)
StandardFormat38 StandardFormat = 38 // #,##0 ;[Red](#,##0)
StandardFormat39 StandardFormat = 39 // #,##0.00;(#,##0.00)
StandardFormat40 StandardFormat = 40 // #,##0.00;[Red](#,##0.00)
StandardFormat45 StandardFormat = 45 // mm:ss
StandardFormat46 StandardFormat = 46 // [h]:mm:ss
StandardFormat47 StandardFormat = 47 // mm:ss.0
StandardFormat48 StandardFormat = 48 // ##0.0E+0
StandardFormat49 StandardFormat = 49 // @
)
func CreateDefaultNumberFormat(id StandardFormat) NumberFormat {
nf := NumberFormat{x: sml.NewCT_NumFmt()}
nf.x.NumFmtIdAttr = uint32(id)
nf.x.FormatCodeAttr = "General"
switch id {
case StandardFormat0:
nf.x.FormatCodeAttr = "General"
case StandardFormat1:
nf.x.FormatCodeAttr = "0"
case StandardFormat2:
nf.x.FormatCodeAttr = "0.00"
case StandardFormat3:
nf.x.FormatCodeAttr = "#,##0"
case StandardFormat4:
nf.x.FormatCodeAttr = "#,##0.00"
case StandardFormat9:
nf.x.FormatCodeAttr = "0%"
case StandardFormat10:
nf.x.FormatCodeAttr = "0.00%"
case StandardFormat11:
nf.x.FormatCodeAttr = "0.00E+00"
case StandardFormat12:
nf.x.FormatCodeAttr = "# ?/?"
case StandardFormat13:
nf.x.FormatCodeAttr = "# ??/??"
case StandardFormat14:
nf.x.FormatCodeAttr = "m/d/yy"
case StandardFormat15:
nf.x.FormatCodeAttr = "d-mmm-yy"
case StandardFormat16:
nf.x.FormatCodeAttr = "d-mmm"
case StandardFormat17:
nf.x.FormatCodeAttr = "mmm-yy"
case StandardFormat18:
nf.x.FormatCodeAttr = "h:mm AM/PM"
case StandardFormat19:
nf.x.FormatCodeAttr = "h:mm:ss AM/PM"
case StandardFormat20:
nf.x.FormatCodeAttr = "h:mm"
case StandardFormat21:
nf.x.FormatCodeAttr = "h:mm:ss"
case StandardFormat22:
nf.x.FormatCodeAttr = "m/d/yy h:mm"
case StandardFormat37:
nf.x.FormatCodeAttr = "#,##0 ;(#,##0)"
case StandardFormat38:
nf.x.FormatCodeAttr = "#,##0 ;[Red](#,##0)"
case StandardFormat39:
nf.x.FormatCodeAttr = "#,##0.00;(#,##0.00)"
case StandardFormat40:
nf.x.FormatCodeAttr = "#,##0.00;[Red](#,##0.00)"
case StandardFormat45:
nf.x.FormatCodeAttr = "mm:ss"
case StandardFormat46:
nf.x.FormatCodeAttr = "[h]:mm:ss"
case StandardFormat47:
nf.x.FormatCodeAttr = "mm:ss.0"
case StandardFormat48:
nf.x.FormatCodeAttr = "##0.0E+0"
case StandardFormat49:
nf.x.FormatCodeAttr = "@"
}
return nf
}