GS-Calc is a full featured spreadsheet that can be used for editing huge files and to build complex data models with millions of formulas and GBs of data.
Worksheets and pivot tables can use 12 million rows. No limitations for using cell references to external closed workbooks.
No limitations for the number of hyperlinks. Users can add their own DLL libraries with new functions or functions replacing the default ones, with the same performance, dynamic array ("spilling") functionality and multi-core calculations. Extensive use of regular expressions in the built-in functions (Filter(), Find(), lookups) and Find&Replace functions. Automatic use of binary searching in lookup functions with any number of ranges sorted in the background.
Opening an over 4GB workbook with over 500 million cells with random floating-point numbers and text strings (8 worksheets, ~12 million rows each) should take around 30s on a low-end office pc with 16GB RAM.
Filtering (regex/operators/formulas/duplicates) a few million rows should take a few seconds (and the result can include millions of rows as well).
GS-Calc can be installed on any portable storage device and used without performing any registry modifications.https://citadel5.com/gs-calc.htm
dcode3Gq7 50%off $9.95 [for 24 hours] incl. free new versions for one year
12 million fast binary VLOOKUP's in GS-Calchttps://www.youtube..../watch?v=EoRQghsNZUI
Saving/loading workbooks with 12 million rows and 100 million cellshttps://www.youtube..../watch?v=-_pn8rbfrNg
Creating a script in GS-Calc to mass-import tables from CSV/text/xBase/xlsx/MySQL fileshttps://www.youtube..../watch?v=kmE1-IMInbY