From 94f197c4fe6531f96a42fe4e960c1c921a3ee0e8 Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Sat, 19 Mar 2022 00:05:47 +0800
Subject: This improved formula calculate precision and added zero placeholder
 number format support

---
 rows.go | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'rows.go')

diff --git a/rows.go b/rows.go
index ec94c64..ae7e01e 100644
--- a/rows.go
+++ b/rows.go
@@ -459,6 +459,13 @@ func (c *xlsxC) getValueFrom(f *File, d *xlsxSST, raw bool) (string, error) {
 		}
 		return f.formattedValue(c.S, c.V, raw), nil
 	default:
+		if isNum, precision := isNumeric(c.V); isNum && !raw {
+			if precision == 0 {
+				c.V = roundPrecision(c.V, 15)
+			} else {
+				c.V = roundPrecision(c.V, -1)
+			}
+		}
 		return f.formattedValue(c.S, c.V, raw), nil
 	}
 }
-- 
cgit v1.2.1