# GS-Calc Updates **URL:** https://community.citadel5.com/c/gs-calc/gs-calc-updates/7.md?page=1 [Latest](https://community.citadel5.com/latest.md) · [Categories](https://community.citadel5.com/categories.md) · [Tags](https://community.citadel5.com/tags.md) **Page:** 2 --- ## [GS-Calc 18.7 has been released.](https://community.citadel5.com/t/gs-calc-18-7-has-been-released/185)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [March 19, 2023, 11:33pm UTC](https://community.citadel5.com/t/gs-calc-18-7-has-been-released/185 "2023-03-19T23:33:36Z")
New features in this version: In-cells charts as cell formats. With one click you can create any number of mini-charts displayed in cells. All parameters and display options are set up automatically. The number of in-… --- ## [GS-Calc 18.6 has been released.](https://community.citadel5.com/t/gs-calc-18-6-has-been-released/184)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [March 8, 2023, 2:14pm UTC](https://community.citadel5.com/t/gs-calc-18-6-has-been-released/184 "2023-03-08T14:14:07Z")
New features in this version: New drop-down lists with checkboxes and multiple columns. You can display list items in 1 to 99 columns. Dragging the vertical gridlines in the list window resizes all these list columns.… --- ## [GS-Calc 18.5 has been released.](https://community.citadel5.com/t/gs-calc-18-5-has-been-released/182)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [February 9, 2023, 8:00pm UTC](https://community.citadel5.com/t/gs-calc-18-5-has-been-released/182 "2023-02-09T20:00:15Z")
New features in this version: GS-Calc can now both load and save multiple text files in one zip file. The corresponding “Files of Type” filter name in the “(File) Open” dialog box is: “Text | Text Archive (.txt;.csv;.t… --- ## [GS-Calc 18.4 has been released.](https://community.citadel5.com/t/gs-calc-18-4-has-been-released/181)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [January 30, 2023, 6:54pm UTC](https://community.citadel5.com/t/gs-calc-18-4-has-been-released/181 "2023-01-30T18:54:41Z")
New features in this version: The default underlying GS-Calc \*.gsc file format has been changed form the standard Windows ZIP to ZIP64. For compatibility reasons, when saving workbooks that can be used in older versio… --- ## [GS-Calc 18.3 has been released.](https://community.citadel5.com/t/gs-calc-18-3-has-been-released/180)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [January 14, 2023, 12:24am UTC](https://community.citadel5.com/t/gs-calc-18-3-has-been-released/180 "2023-01-14T00:24:13Z")
New features in this version: The “File \> Data Checksums” command enables you to create SHA-256 checksums/hashes for a given workbook or its selected essential data sections (excluding formatting, column/row widths, co… --- ## [GS-Calc 18.2 has been released](https://community.citadel5.com/t/gs-calc-18-2-has-been-released/171)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [October 4, 2022, 11:44pm UTC](https://community.citadel5.com/t/gs-calc-18-2-has-been-released/171 "2022-10-04T23:44:11Z")
New features in GS-Calc 18.2: New “Insert” commands have been added for a group of lookup, filter and sorting functions. They enable creating the corresponding formulas, setting all options, applying styles etc. with … --- ## [GS-Calc 18.1 has been released](https://community.citadel5.com/t/gs-calc-18-1-has-been-released/169)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [August 19, 2022, 12:45pm UTC](https://community.citadel5.com/t/gs-calc-18-1-has-been-released/169 "2022-08-19T12:45:12Z")
New features in GS-Calc 18.1: Filtering data/tables. The new FILTER() function enables you to filter data with the number of filters up to the max. number of columns, sort the results using compound keys consisting of… --- ## [GS-Calc 18 has been released](https://community.citadel5.com/t/gs-calc-18-has-been-released/168)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [July 1, 2022, 12:28pm UTC](https://community.citadel5.com/t/gs-calc-18-has-been-released/168 "2022-07-01T12:28:55Z")
Changes in this version (July 1, 2022): Drawing 2D charts with large data series has been significantly optimized. For example, for 0.5 million data points with a proper category axis “interval” value drawing charts sh… --- ## [GS-Calc 17.9 has been released](https://community.citadel5.com/t/gs-calc-17-9-has-been-released/165)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [May 9, 2022, 7:37pm UTC](https://community.citadel5.com/t/gs-calc-17-9-has-been-released/165 "2022-05-09T19:37:44Z")
Changes in this version (5/15/2022): Exchanging data with GS-Base via the \*.xls format: https://citadel5.com/help/gscalc/xls\_files.htm https://citadel5.com/help/gsbase/xmls\_files.htm A number of various changes and … --- ## [GS-Calc 17.8 has been released](https://community.citadel5.com/t/gs-calc-17-8-has-been-released/162)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [February 13, 2022, 10:53pm UTC](https://community.citadel5.com/t/gs-calc-17-8-has-been-released/162 "2022-02-13T22:53:11Z")
Changes in this version (ver. 17.8, March 3, 2022): The “dark mode”. It can be turned on to save energy consumption in notebooks, to reduce the harmful blue light, to help with eye strain and falling asleep faster. D… --- ## [GS-Calc 17.7 has been released.](https://community.citadel5.com/t/gs-calc-17-7-has-been-released/161)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [January 26, 2022, 2:06am UTC](https://community.citadel5.com/t/gs-calc-17-7-has-been-released/161 "2022-01-26T02:06:32Z")
Changes in this version: Definable cross-highlighting https://citadel5.com/help/gscalc/gsc17.7\_scr1.png Ranges with locally redefined cursor/Enter keys actions https://citadel5.com/help/gscalc/gsc17.7\_scr2.png … --- ## [GS-Calc 17.6 has been released](https://community.citadel5.com/t/gs-calc-17-6-has-been-released/159)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [December 27, 2021, 9:53pm UTC](https://community.citadel5.com/t/gs-calc-17-6-has-been-released/159 "2021-12-27T21:53:21Z")
Changes in this version: The “Scripts” command on the “Find & Replace” toolbar can be used to perform quick multiple text replacing for the whole worksheet or selected ranges using regular expressions (RegEx). Find and… --- ## [GS-Calc 17.5 has been released](https://community.citadel5.com/t/gs-calc-17-5-has-been-released/155)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [October 3, 2021, 1:00pm UTC](https://community.citadel5.com/t/gs-calc-17-5-has-been-released/155 "2021-10-03T13:00:56Z")
Changes in this version: Custom lists to insert data series. List items can be embedded in cell strings. Manage Series dialog box https://citadel5.com/help/gscalc/custom-lists.png Fill toolbar button https://citadel5… --- ## [GS-Calc 17.4 has been released](https://community.citadel5.com/t/gs-calc-17-4-has-been-released/150)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [May 4, 2021, 7:40am UTC](https://community.citadel5.com/t/gs-calc-17-4-has-been-released/150 "2021-05-04T07:40:29Z")
Changes in this version: A new alternative spell checking engine (Hunspell) which is now available in GS-Calc. As the free high quality dictionaries are widely available for this engine, users can now check spelling f… --- ## [GS-Calc 17.3 has been released](https://community.citadel5.com/t/gs-calc-17-3-has-been-released/147)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [March 3, 2021, 2:34am UTC](https://community.citadel5.com/t/gs-calc-17-3-has-been-released/147 "2021-03-03T02:34:23Z")
Changes in this version: A number of new functions has been added to the COM interfaces and the help file now includes their full list along with examples how to use them in users own client programs (which was not doc… --- ## [GS-Calc 17.2 has been released](https://community.citadel5.com/t/gs-calc-17-2-has-been-released/140)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [October 23, 2019, 12:56am UTC](https://community.citadel5.com/t/gs-calc-17-2-has-been-released/140 "2019-10-23T00:56:59Z")
Changes in this version: The following (mainly statistical) Excel functions have been added. A part of them already exists (and stays) in GS-Calc but they are using different names. BINOM.DIST(), COVARIANCE.P(), COVAR… --- ## [GS-Calc 17.1 has been released](https://community.citadel5.com/t/gs-calc-17-1-has-been-released/136)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [June 14, 2019, 11:18am UTC](https://community.citadel5.com/t/gs-calc-17-1-has-been-released/136 "2019-06-14T11:18:42Z")
Changes in this version: New commands and modified menus in the Pivot Table pane: reports, copying. https://citadel5.com/upd\_screens/gsc17.1/gsc17.1\_upd1.png https://citadel5.com/upd\_screens/gsc17.1/gsc17.1\_upd2.png … --- ## [GS-Calc 17 has been released](https://community.citadel5.com/t/gs-calc-17-has-been-released/133)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [March 31, 2019, 1:31am UTC](https://community.citadel5.com/t/gs-calc-17-has-been-released/133 "2019-03-31T01:31:20Z")
Changes in this version: GS-Calc (ver. 17 and later) can be configured to use functions written by users in C/C++ as plain DLL libraries. Such functions can be even used as a replacement for the default built-in functi… --- ## [GS-Calc 16.9 has been released](https://community.citadel5.com/t/gs-calc-16-9-has-been-released/127)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [December 22, 2018, 10:12pm UTC](https://community.citadel5.com/t/gs-calc-16-9-has-been-released/127 "2018-12-22T22:12:21Z")
Changes in this version: This update adds Monte Carlo simulations that can be used for many purposes like optimizations (finding maximum or minimum for given calculations/functions), integration or analyzing business m… --- ## [GS-Calc 16.8 has been released](https://community.citadel5.com/t/gs-calc-16-8-has-been-released/124)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [December 3, 2017, 7:22pm UTC](https://community.citadel5.com/t/gs-calc-16-8-has-been-released/124 "2017-12-03T19:22:01Z")
Changes in this version: A number of new pivot table function have been added: geometric and harmonic means, variances and standard deviations, counting specific numbers, counting strings based on regular expressions, … --- ## [GS-Calc 16.5 has been released](https://community.citadel5.com/t/gs-calc-16-5-has-been-released/119)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [June 20, 2017, 1:49pm UTC](https://community.citadel5.com/t/gs-calc-16-5-has-been-released/119 "2017-06-20T13:49:57Z")
Changes in this version: Added new “IFs” functions: percentileIfs(), percentileAIfs() averageIfs(), averageAIfs() geoMeanIfs(), geoMeanAIfs() harMeanIfs(), harMeanAIfs() medianIfs(), medianAIfs() maxIfs(), maxAIfs() m… --- ## [GS-Calc 16.3 has been released](https://community.citadel5.com/t/gs-calc-16-3-has-been-released/116)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [December 13, 2016, 6:24pm UTC](https://community.citadel5.com/t/gs-calc-16-3-has-been-released/116 "2016-12-13T18:24:10Z")
Changes in this version: Pivot tables can be now optionally created in a new view pane with much more convenient editing options and page selection. Both stand-alone and formula pivot tables use the formatting of the r… --- ## [GS-Calc 16 has been released](https://community.citadel5.com/t/gs-calc-16-has-been-released/109)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [November 8, 2015, 8:08pm UTC](https://community.citadel5.com/t/gs-calc-16-has-been-released/109 "2015-11-08T20:08:49Z")
Changes in this version: Parts of the toolbars have been modified and several new commands have been added. http://www.citadel5.com/upd\_screens/gsc16.0/gsc16\_scr1.png The “-\>” button near the “Location” toolbar edit… --- ## [GS-Calc 15.2 has been released](https://community.citadel5.com/t/gs-calc-15-2-has-been-released/108)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [October 19, 2015, 1:02pm UTC](https://community.citadel5.com/t/gs-calc-15-2-has-been-released/108 "2015-10-19T13:02:45Z")
Changes in this version: Regular expression syntax highlighting/coloring has been added to the “Find & Replace” toolbar. It should help users to avoid entering the Regex control characters (e.g. ?+\*().{}|^$) and sequen… --- ## [GS-Calc 15.1 has been released](https://community.citadel5.com/t/gs-calc-15-1-has-been-released/104)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [August 25, 2015, 12:59am UTC](https://community.citadel5.com/t/gs-calc-15-1-has-been-released/104 "2015-08-25T00:59:53Z")
Changes in this version: Syntax coloring/highlighting for JScript and VBScript scripts in the “Scripts” window. http://www.citadel5.com/upd\_screens/gsc15.1/scripts.png Optional syntax coloring when editing cells (e.… --- ## [GS-Calc 15 has been released](https://community.citadel5.com/t/gs-calc-15-has-been-released/103)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [August 8, 2015, 6:47pm UTC](https://community.citadel5.com/t/gs-calc-15-has-been-released/103 "2015-08-08T18:47:19Z")
Changes in this version: Improvements and fixed issues concerning the ODF \*.ods file format. (GS-Calc had problems with displaying charts and drop-down lists in \*.ods files created by other spreadsheets and \*.ods files… --- ## [GS-Calc 14.6 has been released](https://community.citadel5.com/t/gs-calc-14-6-has-been-released/101)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [May 31, 2015, 1:36pm UTC](https://community.citadel5.com/t/gs-calc-14-6-has-been-released/101 "2015-05-31T13:36:11Z")
Changes in this version: The “Insert Cells” and “Remove Cells” commands have been added to the “Tools” menu. http://www.citadel5.com/gsc14.6/gsc14.6\_tools.png http://www.citadel5.com/gsc14.6/gsc14.6\_cells.png The “… --- ## [GS-Calc 14.4 has been released](https://community.citadel5.com/t/gs-calc-14-4-has-been-released/100)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [April 3, 2015, 11:32pm UTC](https://community.citadel5.com/t/gs-calc-14-4-has-been-released/100 "2015-04-03T23:32:54Z")
Changes in this version: Significantly increased speed for many formatting actions and the “auto-fit column width” actions. (From several up to tens of times for very large files.) A new (global) option to automaticall… --- ## [GS-Calc 14.2 has been released](https://community.citadel5.com/t/gs-calc-14-2-has-been-released/97)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [February 16, 2015, 3:17pm UTC](https://community.citadel5.com/t/gs-calc-14-2-has-been-released/97 "2015-02-16T15:17:54Z")
Changes in this version: The command to change the color of worksheet grid-lines has been added to the “View” menu. (“View \> Gridline Color”) Added option to hide (initially) the worksheet tree pane for new workbooks (… --- ## [GS-Calc 14 has been released](https://community.citadel5.com/t/gs-calc-14-has-been-released/95)
**Author:** [@citadel\_5](https://community.citadel5.com/u/citadel_5)\ **Replies:** 0\ **Last updated:** [December 26, 2014, 10:09pm UTC](https://community.citadel5.com/t/gs-calc-14-has-been-released/95 "2014-12-26T22:09:13Z")
Changes in this version: Full Unicode support (entering any characters using a few methods). A new “Chart” dialog box with easier access to all the chart data; multiline titles and subtitles; user-defined (grid-) x-lin… [Previous page](https://community.citadel5.com/c/gs-calc/gs-calc-updates/7.md) [Next page](https://community.citadel5.com/c/gs-calc/gs-calc-updates/7.md?page=2)