search

protobi / js-xlsx

XLSX / XLSM / XLSB (Excel 2007+ Spreadsheet) / ODS parser and writer
http://oss.sheetjs.com/js-xlsx
Other
814 stars 416 forks source link

Empty cell for values zero #105

Open SyedFayaz opened 6 years ago

SyedFayaz commented 6 years ago

Cells with value=0 [i.e. v:0] are empty when style is applied.

ackuikui commented 6 years ago 
worksheet['!ref'] = "A1:F30";
worksheet['F1'] = {v: 0};
worksheet['F2'] = {v: 0, s: {fill: { patternType: 'solid', fgColor: { rgb: '00DD0000' } }}};
worksheet['F3'] = {t: 's', v: 0, s: {alignment: { wrapText: false, vertical: 'center', horizontal: 'center' }}};

They're all zero not empty