protobi / js-xlsx

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

Allow quotePrefix option in styles. #81

Open arnodb opened 6 years ago

arnodb commented 6 years ago

This patch allows setting the quotePrefix attribute in the style so that Excel knows that the content of the cell edition box should be prefixed by an apostrophe. That way, the generated workbook does not mutate when such a cell is edited while keeping the same value. Try "42", "'42", "=42", "'=42", all of these should have quotePrefix style in order to make Excel happy/ier.