From 0072bb731043f89ce978778b9d7fdc6160e29de0 Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Fri, 22 Feb 2019 22:17:38 +0800
Subject: resolve the issue corrupted xlsx after deleting formula of cell,
 reference #346

---
 cell.go | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'cell.go')

diff --git a/cell.go b/cell.go
index afe8635..3cf880a 100644
--- a/cell.go
+++ b/cell.go
@@ -305,6 +305,11 @@ func (f *File) SetCellFormula(sheet, axis, formula string) {
 	completeRow(xlsx, rows, cell)
 	completeCol(xlsx, rows, cell)
 
+	if formula == "" {
+		xlsx.SheetData.Row[xAxis].C[yAxis].F = nil
+		f.deleteCalcChain(axis)
+		return
+	}
 	if xlsx.SheetData.Row[xAxis].C[yAxis].F != nil {
 		xlsx.SheetData.Row[xAxis].C[yAxis].F.Content = formula
 	} else {
-- 
cgit v1.2.1