summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorxuri <xuri.me@gmail.com>2020-03-09 00:08:47 +0800
committerxuri <xuri.me@gmail.com>2020-03-09 00:08:47 +0800
commit2ccb8f62edd5d1ce039e663591964b9066fd2f4e (patch)
treece96e8b663c51291881b464a466d900a612d4660
parentcb797540684d82fdb0fab111d0efce2977b24bf3 (diff)
Remove calculated properties to make recalculate formulas in some spreadsheet applications, such as Kingsoft WPS
-rw-r--r--excelize.go3
1 files changed, 3 insertions, 0 deletions
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 {