sheetjs

8 ms·

1.
by sheetjs 2y ago
Knuth is also still reviewing TAOCP-related email and issuing reward checks. A teammate received a reward check for 1 hex dollar last month after finding an error in Seminumerical Algorithms. Along with the check, there was a printout of th
2.
by sheetjs 4y ago
SheetJS | https://sheetjs.com/ | Software Developer | Full time, Remote (US) | $165K - $240K We're a bootstrapped company building open source solutions for spreadsheets and structured data. With over 1.8M unique month
3.
by sheetjs 4y ago
Last year, Bing and Edge erroneously flagged our website https://sheetjs.com/ as "dangerous": https://i.imgur.com/BvA3zrk.png At the time, there was no "Safety Report" to indicate why Bi
4.
by sheetjs 4y ago
Under the hood, modern Numbers stores values in Decimal128 (16 bytes)
5.
by sheetjs 4y ago
SheetJS | https://sheetjs.com/ | Software Developer | Full time, Remote (US) | $165K - $240K We're a bootstrapped company building open source solutions for spreadsheets and structured data. With over 1.5M unique month
6.
by sheetjs 4y ago
Under the hood, numpy and friends punt to native code. FFI / native module performance becomes a bottleneck, and Bun is correctly focusing in this area. Shumai [1] is a cool library for Bun that also punts to native code [1] https:&
7.
by sheetjs 4y ago
JavaScript has a massive and unrivaled ecosystem outside of core data analysis. The main hurdle to adoption is ecosystem and community. A generation of applied mathematicians and data scientists were trained on Python. Python overcame ol
8.
by sheetjs 4y ago
The hardest unsolved problem is document compatibility. It's not enough to have a cool tool -- you need to be able to interchange data with existing users of Excel and other workflows. This was an important piece during Excel's
9.
by sheetjs 4y ago
Unfortunately the source spreadsheet was not shared, but the root cause was a misreported codepage (which you can actually fix with a hex editor!) "Â ", where the second character is a unicode non-breaking space characters (U+00A0
10.
by sheetjs 4y ago
A Seattle Times article from 1989: > Inside Microsoft – A ‘Velvet Sweatshop’ or a High-Tech Heaven? https://www.seattletimes.com/business/archive-inside-microso...
11.
by sheetjs 4y ago
This password specifically refers to "Password to Modify" and Excel 2019 / 365 clearly warn in the reenter password popup: > Caution: Password to modify is not a security feature. ... Malicious users can edit the file and
12.
by sheetjs 4y ago
Hi, random developer that somehow ended up in the top 500 but didn't have 2FA turned on ( https://www.npmjs.com/package/xlsx )! npm inc invalidated all of our authentication tokens in mid April and we have been una
13.
by sheetjs 4y ago
Software Arts published an official technical specification of the DIF file format in 1983. [1] (to save a file in the DIF format, /S#S in VC) It is certainly an interesting format, and Excel completely mangles the data (whether it was
14.
by sheetjs 5y ago
Maybe a story from a maintainer would help. To contextualize, the main SheetJS open source project https://github.com/SheetJS/sheetjs has over 28K stars. tl;dr: the project involves "crowdsourced research" w
15.
by sheetjs 5y ago
Pre-Unicode issues still haunt us today, kept alive by various file formats that rely on system encoding. Under the Apple "Mac-Roman" encoding [1], the standard MacOS encoding before OSX switched to Unicode, byte 0xBD currently is
16.
by sheetjs 5y ago
Our story is very similar. I wrote a small library for converting XLSX and XLS files to CSV. Over the years, that grew into one of the most popular open source libraries on npm/github: https://github.com/SheetJS/
17.
by sheetjs 5y ago
> Spreadsheet evolution has been slow though. Excel has to contend with nearly 40 years of backwards compatibility (MultiPlan, the predecessor to Excel, was released in 1982) and a deep userbase that literally has decades of experience a
18.
by sheetjs 5y ago
Newer versions of Excel have native JavaScript support https://docs.microsoft.com/en-us/office/dev/add-ins/referenc...
19.
by sheetjs 5y ago
When saving as CSV, Excel will use the regional "List separator" setting. You can override this in Windows 7 with Region and Language > Additional Settings > List separator. If you are trying to generate a file that plays n
20.
by sheetjs 6y ago
We have a few customers in reinsurance, and for the most part the goal is to do the opposite of what the python solutions try to do. Instead of integrating foreign stuff into existing workbooks, the goal is to retain the existing worksheet
21.
by sheetjs 6y ago
For that type of pattern, you can also use the new LET function: LET(myval, A2+B2, IF(myval>10, myval, 10)) https://support.microsoft.com/en-us/office/let-function-3484...
22.
by sheetjs 6y ago
SheetJS was created because of a Microsoft licensing issue with a library ( https://github.com/stephen-hardy/xlsx.js/issues/8 ). The other project had a nonstandard license with a clause that only applied to b
23.
by sheetjs 6y ago
Article doesn't explain the issue, but OFFSET lets you access cells that aren't referenced in the formula. For example, OFFSET(B2,1,1,1,1) is a live reference to cell C3, which means you can use functions like COLUMN to investigat
24.
by sheetjs 6y ago
Excel predates RFC4180 by nearly 20 years (RFC4180 is October 2005, Excel 1.0 was September 1985) and this behavior was already cemented when the RFC was written. As for the actual RFC, it's worth taking a read. Any sort of value inte
25.
by sheetjs 6y ago
The correct way to generate a CSV cell with a leading 0 is ="01" You can verify this with 01,"01",="01"
26.
by sheetjs 6y ago
It was literally cited by Britain's finance minister George Osborne as justification for UK government austerity: > As Ken Rogoff himself puts it, "there's no question that the most significant vulnerability as we emerge f
27.
by sheetjs 6y ago
> If you spend some time and effort removing whatever obstacles you have in place that are keeping you from being able to do that This is literally impossible for many JS libraries. Chromium / NodeJS / other JS environments ar
28.
by sheetjs 6y ago
CSV is a very bad example. Yes, it is easy to throw together a simple regex to parse simple RFC4180 CSV strings, but Excel is its own black box with a huge number of hacks. For example, en-US excel will automagically parse TRUE and "T
29.
by sheetjs 6y ago
2020 feels like a new age because of the browser ecosystem. The actual endpoint of the "second age" is probably the combined forces of: 1) Windows 7 Support officially ended 2) Edge now switched over to Chromium With the exceptio
30.
by sheetjs 6y ago
It's even worse than the author is suggesting. For most people, "RFC4180" is meaningless, all that matters is what Excel does. And that means you need to handle a bunch of cases if you are reading AND if you are writing fil

More ›