Eric P Sheets

@monqkim the `v` values are coming from the file itself directly, which means that Excel likely stored the values with the remainder. Can you share a sample file?

Just so we're on the same page here, the `v` values are exactly what is stored in the Excel file. To see, go to https://sheetjs.com/cfb-editor/ then drag and drop the...

@phillipperalez There's a grammar for the format string but the specifications don't actually explain how Excel converts a value to a specific type. Excel's time behavior behavior, at least based...

@hy9be can confirm that is an issue as part of the second part of a conditional format. Simpler repro: ```js SSF.format(';($0.0)', -200); ```

@n8agrin The "official grammar" is in [[MS-XLS] 2.4.126](https://msdn.microsoft.com/en-us/library/dd944946.aspx) and there's an attempt to describe the behavior in ECMA-376 18.8.30-18.8.31 (pages 1776-1792 of the Fifth Edition PDF, I exported the relevant...

It's scheduled for after the great merge. Basically, the API right now is structured to take strings and return strings, but that wont work once colors etc are involved. The...

@wilg there are actually two issues here. 1) Excel magic: If you input that manually into Excel 2013, it autocorrects to `#,###.??;(#,###.??);0` (this may very well be locale-specific). That type...

Are you sure the cells are numeric? As a quick test, add the line ```diff if(!worksheet[ref]) continue; + console.log(worksheet[ref].t); if(worksheet[ref].t != 'n') continue; ``` ... and verify you are seeing...

If there is formatted text, utilities will use the cached values. Delete the formatted text as follows: ```diff if(worksheet[ref].t != 'n') continue; + delete worksheet[ref].w; worksheet[ref].z = fmt; ```

To format the entire column, there are three parts: 1) Formatting each extant cell in the column. This loop is fairly straightforward: ```js var range = XLSX.utils.decode_range(ws["!ref"]); range.s.c = range.e.c...