# GS-Calc 18.8 has been released.

**URL:** <https://community.citadel5.com/t/gs-calc-18-8-has-been-released/191>\
**Category:** GS-Calc Updates\
**Created:** [April 23, 2023, 1:08am UTC](https://community.citadel5.com/t/gs-calc-18-8-has-been-released/191 "2023-04-23T01:08:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![citadel\_5](https://community.citadel5.com/letter_avatar_proxy/v4/letter/c/b2d939/32.png) [@citadel\_5](https://community.citadel5.com/u/citadel_5)\
**Post date:** [April 23, 2023, 1:08am UTC](https://community.citadel5.com/t/gs-calc-18-8-has-been-released/191/1 "2023-04-23T01:08:04Z")

</div>

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](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](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](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](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](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](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](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](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](https://citadel5.com/help/gscalc/com_samples.htm#s8)

Editing worksheets:  
[https://citadel5.com/help/gscalc/com\_samples.htm#s9](https://citadel5.com/help/gscalc/com_samples.htm#s9)

Adding worksheets and folders:  
[https://citadel5.com/help/gscalc/com\_samples.htm#s10](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](https://citadel5.com/help/gscalc/com_samples.htm#s11)  
  
  
Using Monte Carlo simulations to find linear programming solutions  
[https://youtu.be/oWnGLC\_STdE](https://youtu.be/oWnGLC_STdE)