# GS-Calc Updates **URL:** https://community.citadel5.com/c/gs-calc/gs-calc-updates/7.md [Latest](https://community.citadel5.com/latest.md) · [Categories](https://community.citadel5.com/categories.md) · [Tags](https://community.citadel5.com/tags.md) --- ## [About the GS-Calc Updates category](https://community.citadel5.com/t/about-the-gs-calc-updates-category/11)
**Author:** [@system](https://community.citadel5.com/u/system)\ **Replies:** 0
Information about published new versions and updates --- ## [GS-Calc 24.3 has been released](https://community.citadel5.com/t/gs-calc-24-3-has-been-released/396)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [September 26, 2026, 2:04pm UTC](https://community.citadel5.com/t/gs-calc-24-3-has-been-released/396 "2026-09-26T14:04:47Z")
Changes and new features: (1) Loading and saving OpenDocument \*.ods files should typically be 2.5 to 3 times faster. In some cases — such as a column of millions of floating-point numbers — this difference can reach 7-8… --- ## [GS-Calc 24.2 has been released](https://community.citadel5.com/t/gs-calc-24-2-has-been-released/394)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [September 9, 2026, 12:06pm UTC](https://community.citadel5.com/t/gs-calc-24-2-has-been-released/394 "2026-09-09T12:06:45Z")
Changes in GS-Calc 24.2 include: The Help has been fully overhauled: the old Windows \*.chm file has been replaced by a set of HTML pages viewable in your default browser. The Help now includes descriptions of all bu… --- ## [GS-Calc 24.0.8 / 24.0.9 has been released](https://community.citadel5.com/t/gs-calc-24-0-8-24-0-9-has-been-released/390)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [December 3, 2025, 8:41pm UTC](https://community.citadel5.com/t/gs-calc-24-0-8-24-0-9-has-been-released/390 "2025-12-03T20:41:25Z")
The 24.0.8 update displays more information about potential problems with (loading) text files: If invalid utf8 sequences are found in .txt/.csv files (which typically occurs when this is an ansi/iso text file that do… --- ## [GS-Calc 24 has been released](https://community.citadel5.com/t/gs-calc-24-has-been-released/384)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [June 11, 2025, 10:51pm UTC](https://community.citadel5.com/t/gs-calc-24-has-been-released/384 "2025-06-11T22:51:02Z")
In GS-Calc 24 Python scripting replaces the previously used JScript/VBscript script engines and adds many new functions available in scripts. Using Python and its available modules should be a huge improvement in how you… --- ## [GS-Calc 23.1 has been released](https://community.citadel5.com/t/gs-calc-23-1-has-been-released/383)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [May 20, 2025, 6:02pm UTC](https://community.citadel5.com/t/gs-calc-23-1-has-been-released/383 "2025-05-20T18:02:39Z")
GS-Calc 23.1 is a maintenance update that adds or modifies several functions to improve the compatibility with Google Sheets and Excel 365. Added: SWITCH(expression, case1, value1, \[case2, value2, …\], \[default\]) Te… --- ## [GS-Calc 23 has been released](https://community.citadel5.com/t/gs-calc-23-has-been-released/382)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [May 9, 2025, 12:52pm UTC](https://community.citadel5.com/t/gs-calc-23-has-been-released/382 "2025-05-09T12:52:26Z")
GS-Calc 23 adds and significantly improves compatibility with Google Sheets along with several new functions, improves data exchange with Excel 365 using the \*.ods format and includes numerous changes/fixes concerning… --- ## [GS-Calc 22 has been released](https://community.citadel5.com/t/gs-calc-22-has-been-released/380)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [April 20, 2025, 11:12am UTC](https://community.citadel5.com/t/gs-calc-22-has-been-released/380 "2025-04-20T11:12:45Z")
New functions in GS-Calc 22 include new chart types and more chart configuration options. Contour charts and color maps. You can create contour charts with up to 32 million data points in one data series, with full… --- ## [GS-Calc 21.4 has been released](https://community.citadel5.com/t/gs-calc-21-4-has-been-released/377)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 1\ **Last updated:** [March 22, 2025, 2:32pm UTC](https://community.citadel5.com/t/gs-calc-21-4-has-been-released/377 "2025-03-22T14:32:45Z")
GS-Calc 21.4 introduces initial Python integration in GS-Calc and fixes three problems listed below: Using Python functions as UDF() Using the built-in UDF() (user-defined-) function you can call any Python modules/fu… --- ## [GS-Calc 20.9 has been released](https://community.citadel5.com/t/gs-calc-20-9-has-been-released/358)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [July 25, 2024, 9:11am UTC](https://community.citadel5.com/t/gs-calc-20-9-has-been-released/358 "2024-07-25T09:11:09Z")
New features in GS-Calc 20.9: Various types of color gradients that can be used by cell backgrounds and fonts: New, resizable color selection windows attached to the cell/font toolbar color buttons. They offer a p… --- ## [GS-Calc 21.3 has been released](https://community.citadel5.com/t/gs-calc-21-3-has-been-released/371)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [December 4, 2024, 9:18pm UTC](https://community.citadel5.com/t/gs-calc-21-3-has-been-released/371 "2024-12-04T21:18:40Z")
GS-Calc 21.3 introduces the File \> Compare Workbooks function to find differences between two data sets. These can be: entire workbooks and any files in of any the supported file formats, e.g. text/csv files, xbase, sq… --- ## [GS-Calc 21.2 has been released](https://community.citadel5.com/t/gs-calc-21-2-has-been-released/368)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [November 12, 2024, 10:25pm UTC](https://community.citadel5.com/t/gs-calc-21-2-has-been-released/368 "2024-11-12T22:25:10Z")
Aside from changing the default font name type, in GS-Calc 21.2 you also change its size: Changing that size affects all displayed worksheets, tables, control panes/views and elements, etc. that use the default font.… --- ## [GS-Calc 21.1 has been released](https://community.citadel5.com/t/gs-calc-21-1-has-been-released/363)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [September 14, 2024, 1:29am UTC](https://community.citadel5.com/t/gs-calc-21-1-has-been-released/363 "2024-09-14T01:29:21Z")
New features in GS-Calc 21.1: It’s now possible to display pivot table data fields horizontally, in one line along with given row fields’ values. For example, the previous PivotData() function could only generate mult… --- ## [GS-Calc 21 has been released](https://community.citadel5.com/t/gs-calc-21-has-been-released/360)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 1\ **Last updated:** [September 1, 2024, 6:19pm UTC](https://community.citadel5.com/t/gs-calc-21-has-been-released/360 "2024-09-01T18:19:29Z")
New features in GS-Calc 21: Users can define their own formula syntax highlighting for all formula elements. Same cell references occurring in a given formula automatically use the same colors. --- ## [GS-Calc 20.8 has been released](https://community.citadel5.com/t/gs-calc-20-8-has-been-released/355)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [June 21, 2024, 7:19pm UTC](https://community.citadel5.com/t/gs-calc-20-8-has-been-released/355 "2024-06-21T19:19:10Z")
Hi, The 20.8 update includes the following new functionality and fixes: Following the single selection speed increase in a non-scrolling window in the previous update, in this version the worksheet display technology… --- ## [GS-Calc 20.7 has been released.](https://community.citadel5.com/t/gs-calc-20-7-has-been-released/222)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [March 2, 2024, 10:46pm UTC](https://community.citadel5.com/t/gs-calc-20-7-has-been-released/222 "2024-03-02T22:46:57Z")
New features in GS-Calc 20.7: New functions: playSoundIf(path, type, if\_condition, loops, volume) Plays mp3 and wav files. The parameters are as follows: path: Specifies the path of the file to play; if ‘type’ is 1… --- ## [GS-Calc 20.6 has been released.](https://community.citadel5.com/t/gs-calc-20-6-has-been-released/220)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [February 22, 2024, 1:52am UTC](https://community.citadel5.com/t/gs-calc-20-6-has-been-released/220 "2024-02-22T01:52:23Z")
New features in GS-Calc 20.6: The use of binary searching in the enhanced VLOOKUP and MATCH functions have been significantly improved. The first update that creates the internal sorting indexes required by this fas… --- ## [GS-Calc 20.5 has been released.](https://community.citadel5.com/t/gs-calc-20-5-has-been-released/218)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [February 2, 2024, 1:36pm UTC](https://community.citadel5.com/t/gs-calc-20-5-has-been-released/218 "2024-02-02T13:36:18Z")
New features in GS-Calc 20.5: The number of rows has been increased to 32 millions (33,554,432). (Files in the native file format remain compatible as long as you don’t exceed the previous 12 million limit. After that… --- ## [GS-Calc 20.4.1 has been released.](https://community.citadel5.com/t/gs-calc-20-4-1-has-been-released/216)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [January 16, 2024, 9:22pm UTC](https://community.citadel5.com/t/gs-calc-20-4-1-has-been-released/216 "2024-01-16T21:22:01Z")
New features in GS-Calc 20.4.1: The maximum amount of data in one worksheet has been increased from about 32GB to about 500GB. The number of formulas in one worksheet is unlimited (previously around 4 billions). T… --- ## [GS-Calc 20.3 has been released.](https://community.citadel5.com/t/gs-calc-20-3-has-been-released/212)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [November 29, 2023, 10:30pm UTC](https://community.citadel5.com/t/gs-calc-20-3-has-been-released/212 "2023-11-29T22:30:15Z")
New features in GS-Calc 20.3: Conditional cell formatting - the setFormatIf(reference, action, if\_condition, format\_true, format\_false) formula Formats a given cell or a range of cells. The numeric action parameter sp… --- ## [GS-Calc 20.2 has been released.](https://community.citadel5.com/t/gs-calc-20-2-has-been-released/211)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [November 12, 2023, 10:30pm UTC](https://community.citadel5.com/t/gs-calc-20-2-has-been-released/211 "2023-11-12T22:30:37Z")
New features in GS-Calc 20.2: Replacing formulas automatically in worksheets. GS-Calc 20.2 enables you to (“mass-”) replace formulas automatically in worksheets. You can use this for example, to: instantly mass-modi… --- ## [GS-Calc 20.1 has been released.](https://community.citadel5.com/t/gs-calc-20-1-has-been-released/210)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [October 31, 2023, 2:26pm UTC](https://community.citadel5.com/t/gs-calc-20-1-has-been-released/210 "2023-10-31T14:26:25Z")
New features in GS-Calc 20.1 and the Monte Carlo simulations: A new 128-bit pseudo-random generator replaced the previous combined MLCG generator. You can also use the hardware random generator, available in newer pro… --- ## [GS-Calc 20 has been released.](https://community.citadel5.com/t/gs-calc-20-has-been-released/207)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [October 13, 2023, 11:35pm UTC](https://community.citadel5.com/t/gs-calc-20-has-been-released/207 "2023-10-13T23:35:02Z")
New features in GS-Calc 20: Changes concerning the xlsx support. Formulas are read and saved without conversions. Output xlsx workbook files can exceed 4GB if the underlying zip format is left as zip64. The GS-Base \*.g… --- ## [GS-Calc 19.2 has been released.](https://community.citadel5.com/t/gs-calc-19-2-has-been-released/205)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [August 29, 2023, 2:08am UTC](https://community.citadel5.com/t/gs-calc-19-2-has-been-released/205 "2023-08-29T02:08:19Z")
New features in GS-Calc 19.2: A new list of recently used files and folders displayed as a separate split window. It displays file sizes, modification dates and states. You can assign one of many available built-in i… --- ## [GS-Calc 19.1 has been released](https://community.citadel5.com/t/gs-calc-19-1-has-been-released/202)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [June 27, 2023, 11:55pm UTC](https://community.citadel5.com/t/gs-calc-19-1-has-been-released/202 "2023-06-27T23:55:12Z")
New features in GS-Calc 19.1: SQLite \*.db file format support. You can load/create/edit/save databases in the SQLite \*.db file format using all SQLite field types. For each table the first row contains field descripti… --- ## [GS-Calc 19 has been released](https://community.citadel5.com/t/gs-calc-19-has-been-released/197)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [May 30, 2023, 1:09am UTC](https://community.citadel5.com/t/gs-calc-19-has-been-released/197 "2023-05-30T01:09:29Z")
New features in GS-Calc 19: The number of columns has been increased from 4K to 16,384. (The program performance and efficient memory usage remain the same.) You can load text files with up to 1 million columns. G… --- ## [GS-Calc 18.9.1 has been released.](https://community.citadel5.com/t/gs-calc-18-9-1-has-been-released/195)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [May 25, 2023, 1:01pm UTC](https://community.citadel5.com/t/gs-calc-18-9-1-has-been-released/195 "2023-05-25T13:01:01Z")
New features in this version: The new “Insert \> Password” command enables you to insert / fill selected cells with unique passwords. Increasing the length or the character set increases the probability that the generat… --- ## [GS-Calc 18.9 has been released.](https://community.citadel5.com/t/gs-calc-18-9-has-been-released/194)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [May 18, 2023, 10:55pm UTC](https://community.citadel5.com/t/gs-calc-18-9-has-been-released/194 "2023-05-18T22:55:37Z")
New features in this version: Splitting GS-Calc 12 million row workbooks into multiple Excel files or worksheets based on the user-defined number of rows. Splitting saved text/csv files into multiple files based on the… --- ## [GS-Calc 18.8 has been released.](https://community.citadel5.com/t/gs-calc-18-8-has-been-released/191)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [April 23, 2023, 1:08am UTC](https://community.citadel5.com/t/gs-calc-18-8-has-been-released/191 "2023-04-23T01:08:04Z")
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 … --- ## [GS-Calc 18.7.2 has been released.](https://community.citadel5.com/t/gs-calc-18-7-2-has-been-released/188)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [April 4, 2023, 1:36am UTC](https://community.citadel5.com/t/gs-calc-18-7-2-has-been-released/188 "2023-04-04T01:36:42Z")
New features in this version: Users can create named text file open/save settings that are stored globally in the settings file. Instead, or re-selecting all the parameters repeatedly for various text files, you can c… [Next page](https://community.citadel5.com/c/gs-calc/gs-calc-updates/7.md?page=1)