New features in this version include a number of new scripting methods. For example, you can use a simple two-line JScript script to merge in one worksheet up to 12 millions of rows from gsc/text/CSV/Excel xlsx files in under one minute and then open a workbook with e.g. 100 million cells in a few seconds.
To add the following sample scripts to your GS-Calc and use for any workbook, click File > Application Scripts, then in the displayed dialog box click New > JScript and copy/paste the script text - it’ll be saved automatically in your global program settings. To execute the added scripts, open that dialog box and click Run or assign some Ctrl+Shift+… shortcut to execute it using the keyboard.
Video showing adding and executing a script
https://youtu.be/kmE1-IMInbY
Merging rows from multiple text files from a given folder to the current worksheet:
https://citadel5.com/help/gscalc/com_samples.htm#s1
Merging rows from multiple Excel XLSX files from a given folder to the current worksheet:
https://citadel5.com/help/gscalc/com_samples.htm#s2
Importing tables from multiple text files from a given folder to the current workbook:
https://citadel5.com/help/gscalc/com_samples.htm#s3
Importing tables from multiple Excel XLSX files from a given folder to the current workbook:
https://citadel5.com/help/gscalc/com_samples.htm#s4
Releasing open workbook (gsc/xlsx/txt/csv…) files to allow other programs to update them at the same time:
https://citadel5.com/help/gscalc/com_samples.htm#s5
Attaching a released workbook file (gsc/xlsx/txt/csv…) to check for changes and enable saving that file:
https://citadel5.com/help/gscalc/com_samples.htm#s6
Activating the n-th worksheetin in the current workbook (ignoring subfolders):
https://citadel5.com/help/gscalc/com_samples.htm#s7
Iterating through the entire tree of subfolders of a given the current workbook:
https://citadel5.com/help/gscalc/com_samples.htm#s8
Editing worksheets:
https://citadel5.com/help/gscalc/com_samples.htm#s9
Adding worksheets and folders:
https://citadel5.com/help/gscalc/com_samples.htm#s10
Opening a text file and saving it to new *.gsc file:
https://citadel5.com/help/gscalc/com_samples.htm#s11
Using Monte Carlo simulations to find linear programming solutions
https://youtu.be/oWnGLC_STdE