From 2ccb8f62edd5d1ce039e663591964b9066fd2f4e Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Mon, 9 Mar 2020 00:08:47 +0800
Subject: Remove calculated properties to make recalculate formulas in some
 spreadsheet applications, such as Kingsoft WPS

---
 excelize.go | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'excelize.go')

diff --git a/excelize.go b/excelize.go
index e12e769..0962122 100644
--- a/excelize.go
+++ b/excelize.go
@@ -273,6 +273,9 @@ func replaceStyleRelationshipsNameSpaceBytes(contentMarshal []byte) []byte {
 //    </row>
 //
 func (f *File) UpdateLinkedValue() error {
+	wb := f.workbookReader()
+	// recalculate formulas
+	wb.CalcPr = nil
 	for _, name := range f.GetSheetMap() {
 		xlsx, err := f.workSheetReader(name)
 		if err != nil {
-- 
cgit v1.2.1