summaryrefslogtreecommitdiff
path: root/excelize_test.go
diff options
context:
space:
mode:
authorRi Xu <xuri.me@gmail.com>2017-04-07 17:32:14 +0800
committerRi Xu <xuri.me@gmail.com>2017-04-07 17:32:14 +0800
commit6e287839ecc64396a6e40fb15cc62363fca6ca7a (patch)
tree5b72a4a5737386372c9fcae5c875f90253fe8eaf /excelize_test.go
parentc7e277a07a3e151d3622828d1670ac4b33d2f5e8 (diff)
- Set number format for a cell support;
- go test updated
Diffstat (limited to 'excelize_test.go')
-rw-r--r--excelize_test.go8
1 files changed, 5 insertions, 3 deletions
diff --git a/excelize_test.go b/excelize_test.go
index 0c33206..b5aa917 100644
--- a/excelize_test.go
+++ b/excelize_test.go
@@ -327,12 +327,13 @@ func TestSetCellStyleFill(t *testing.T) {
if err != nil {
t.Log(err)
}
- // Test only set fill for a cell.
- err = xlsx.SetCellStyle("Sheet1", "N23", "N23", `{"fill":{"type":"gradient","color":["#FFFFFF","#E0EBF5"],"shading":4}}`)
+ xlsx.SetCellValue("Sheet1", "N23", 42920.5)
+ // Test only set fill and number format for a cell.
+ err = xlsx.SetCellStyle("Sheet1", "N23", "N23", `{"fill":{"type":"gradient","color":["#FFFFFF","#E0EBF5"],"shading":4},"number_format":22}`)
if err != nil {
t.Log(err)
}
- err = xlsx.SetCellStyle("Sheet1", "N24", "N24", `{"fill":{"type":"gradient","color":["#FFFFFF","#E0EBF5"],"shading":5}}`)
+ err = xlsx.SetCellStyle("Sheet1", "N24", "N24", `{"fill":{"type":"gradient","color":["#FFFFFF","#E0EBF5"],"shading":5},"number_format":23}`)
if err != nil {
t.Log(err)
}
@@ -349,6 +350,7 @@ func TestSetCellStyleFill(t *testing.T) {
if err != nil {
t.Log(err)
}
+
err = xlsx.SetCellStyle("Sheet1", "O23", "O23", `{"fill":{"type":"pattern","color":["#E0EBF5"],"pattern":19}}`)
if err != nil {
t.Log(err)