Eric P Sheets

Results 207 comments of Eric P Sheets

Excel autocorrects the format by escaping the slash. In Excel 2019, entering that format in Excel generates the format `#0;#0\-`. That format *does* work.

Not currently, but there are definitely plans to support font-aware rendering as well as reflecting the colors. Back in 2013 (wow time flies!) the goal was to convert from XLSX...

How is the HTML table being generated? Can you make that available somewhere?

It's definitely interesting but lower priority. Some notes: Most file formats store data in row-major order. For example, in the CSV format: ``` A1,B1,C1,D1,... A2,B2,C2,D2,... A3,B3,C3,D3,... A4,B4,C4,D4,... ... A1000000,B1000000,C1000000,D1000000,... ```...

Excel 2019 behavior appears to be the following: If there is a date token in the format (like `hh:mm:ss.000`), `.0` `.00` `.000` are interpreted as sub-second values. All other `.`...

Atlantic/Azores h/t @ruitalia . The timezone had fractional offset `-1:42:40` in 1900

This is not really well-defined (for example, if the ranges overlap, what should be the order of the result?). We could hypothetically add an iterator that walks the worksheet or...

As stated earlier, the operation is not really well-defined. If you can propose a well-defined solution we can reopen the issue.

Chromium bug https://bugs.chromium.org/p/v8/issues/detail?id=7863 we're looking into a workaround

Based on the 2021b tz database, the last TZ to change the universal time offset to be an integral number of minutes was `Africa/Monrovia` in 1972. Notably, it is the...