From b02f864eab5edb2155601b9dd640f99fbd442cb3 Mon Sep 17 00:00:00 2001
From: raochq <31030448+raochq@users.noreply.github.com>
Date: Sun, 15 Aug 2021 01:19:49 +0800
Subject: This closes #844, support get shared formula

---
 lib.go | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'lib.go')

diff --git a/lib.go b/lib.go
index 712576d..81f1e53 100644
--- a/lib.go
+++ b/lib.go
@@ -93,13 +93,12 @@ func readFile(file *zip.File) ([]byte, error) {
 //
 func SplitCellName(cell string) (string, int, error) {
 	alpha := func(r rune) bool {
-		return ('A' <= r && r <= 'Z') || ('a' <= r && r <= 'z')
+		return ('A' <= r && r <= 'Z') || ('a' <= r && r <= 'z') || (r == 36)
 	}
-
 	if strings.IndexFunc(cell, alpha) == 0 {
 		i := strings.LastIndexFunc(cell, alpha)
 		if i >= 0 && i < len(cell)-1 {
-			col, rowstr := cell[:i+1], cell[i+1:]
+			col, rowstr := strings.ReplaceAll(cell[:i+1], "$", ""), cell[i+1:]
 			if row, err := strconv.Atoi(rowstr); err == nil && row > 0 {
 				return col, row, nil
 			}
-- 
cgit v1.2.1