ssf icon indicating copy to clipboard operation
ssf copied to clipboard

Split format function and null formats

Open andreyea opened this issue 4 years ago • 0 comments

This pull request allows specials characters (; \ * ) to be inside double quotes in format definition. For example, "***";"*_".

If a format string is defined as #,###;; (return formatted value for positives and return empty string for negatives and zeroes), it will treat all null definitions as a single space. This is a valid format in Excel.

This also covers issue SheetJS/sheetjs#2569

andreyea avatar Dec 04 '21 14:12 andreyea