Fix the formula calculation result issue of the OR function (#1374)

Co-authored-by: gonghaibin <gonghaibin@qq.com>

1 files changed, 3 insertions, 0 deletions

diff --git a/calc.go b/calc.go
index 5d55992..796ca16 100644
--- a/calc.go
+++ b/calc.go
@@ -11623,6 +11623,9 @@ func (fn *formulaFuncs) OR(argsList *list.List) formulaArg {
 			return newErrorFormulaArg(formulaErrorVALUE, formulaErrorVALUE)
 		case ArgNumber:
 			or = token.Number != 0
+			if or {
+				return newStringFormulaArg(strings.ToUpper(strconv.FormatBool(or)))
+			}
 		case ArgMatrix:
 			// TODO
 			return newErrorFormulaArg(formulaErrorVALUE, formulaErrorVALUE)