@mduan/gsheet-utils
Advanced tools
Comparing version 1.0.17 to 1.0.18
{ | ||
"name": "@mduan/gsheet-utils", | ||
"version": "1.0.17", | ||
"version": "1.0.18", | ||
"description": "", | ||
@@ -5,0 +5,0 @@ "main": "src/index.ts", |
@@ -240,5 +240,11 @@ import isEqual from 'lodash/isEqual'; | ||
} | ||
const sanitizedValues = allValues.map((value) => { | ||
// NOTE: need to convert 0 to string, otherwise it will be treated as empty cell | ||
const sanitizedValue = value === 0 ? `0` : value; | ||
return [sanitizedValue]; | ||
}); | ||
range.getSheet() | ||
.getRange(rowOffset, range.getColumn(), allValues.length, 1) | ||
.setValues(allValues.map((value) => [value])); | ||
.setValues(sanitizedValues); | ||
}); | ||
@@ -245,0 +251,0 @@ } |
13430
11
280