←back to thread

Show HN: GS-Calc – A modern spreadsheet with Python integration

(citadel5.com)
95 points jpiech | 1 comments | 25 Apr 25 18:17 UTC | HN request time: 0s | source

Process large (e.g. 4GB+) data sets in a spreadsheet.

Load GB/32 million-row files in seconds and use them without any crashes using up to about 500GB RAM.

Load/edit in-place/split/merge/clean CSV/text files with up to 32 million rows and 1 million columns.

Use your Python functions as UDF formulas that can return to GS-Calc images and entire CSV files.

Use a set of statistical pivot data functions.

Solver functions virtually without limits for the number of variables.

Create and display all popular chart types with millions of data points instantly.

Suggestions for improvements are welcome (and often implemented quite quickly).

Show context
conductr ◴[25 Apr 25 22:30 UTC] No.43799083[source]▶
It all sounds very compelling , great work! But I have to ask, what’s the catch? This almost seems like it’s ready to fully replace Excel but I’ve seen many things die in that pursuit. What will Excel users miss by switching?

I’m don’t do a ton to big data stuff, but sometimes despite Excels stated row and column support- I find it effectively melts down if even 100K/100 of data and forget adding formulas.

replies(3): >>43799179 #>>43799319 #>>43799327 #
dismalaf ◴[25 Apr 25 23:08 UTC] No.43799327[source]▶
> What will Excel users miss by switching?

The ability to use legacy spreadsheets and macros.

Let's be real, Excel self perpetuates by at once being awful but also the thing everyone used to use thus must still use.

Lots of spreadsheet apps better than Excel have come and gone over the years...

replies(1): >>43799406 #
ASalazarMX ◴[25 Apr 25 23:21 UTC] No.43799406[source]▶
MS Office Macros are too easy for untrained users (that think of themselves as power users) to create, and once they grow big enough, it's very hard to port them to other applications. They're the monkey paw of spreadsheets.
replies(1): >>43800350 #
1. tobwen ◴[26 Apr 25 02:19 UTC] No.43800350{3}[source]▶
VBA and the ability to use Office files with embedded VBA are disabled in many corporations… Some malware in the past used VBA for their attacks and Microsoft never added a proper sandbox.