GS-Calc 18.8 has been released.

Information about published new versions and updates
Post Reply
User avatar
citadel5
Posts: 224
Joined: Tue Apr 20, 2010 11:58 pm

GS-Calc 18.8 has been released.

Post by citadel5 »

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
Post Reply