# Latest **URL:** https://community.citadel5.com/latest.md [Latest](https://community.citadel5.com/latest.md) · [Categories](https://community.citadel5.com/categories.md) · [Tags](https://community.citadel5.com/tags.md) --- ## [Welcome to Citadel5! 👋](https://community.citadel5.com/t/welcome-to-citadel5/5)
**Author:** [@system](https://community.citadel5.com/u/system)\ **Replies:** 0\ **Last updated:** [March 22, 2024, 9:08pm UTC](https://community.citadel5.com/t/welcome-to-citadel5/5 "2024-03-22T21:08:25Z")
We are so glad you joined us. Citadel5 A place to discuss all things related to GS-Calc and GS-Base. Here are some things you can do to get started: :speaking\_head: Introduce yourself by adding your picture and info… --- ## [GS-Base 22.6 has been released](https://community.citadel5.com/t/gs-base-22-6-has-been-released/398)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [October 13, 2026, 12:48pm UTC](https://community.citadel5.com/t/gs-base-22-6-has-been-released/398 "2026-10-13T12:48:01Z")
New features and changes in GS-Base 22.6 include: (1) CSV & TXT File Performance Improved loading for .csv and .txt files with mixed content (text, numbers, dates). For example, with a popular sample file—the 1.8 GB ye… --- ## [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-Base 22.5 has been released](https://community.citadel5.com/t/gs-base-22-5-has-been-released/395)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [September 9, 2026, 12:10pm UTC](https://community.citadel5.com/t/gs-base-22-5-has-been-released/395 "2026-09-09T12:10:49Z")
Changes in GS-Base 22.5 include: The Help has been fully overhauled: the old Windows \*.chm file has been replaced by a set of HTML pages copied to the “(…) GS-Base\\Help” folder and viewable in your default browser. … --- ## [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 delay in program execution](https://community.citadel5.com/t/gs-calc-delay-in-program-execution/369)
**Author:** [@waltmc](https://community.citadel5.com/u/waltmc)\ **Replies:** 4\ **Last updated:** [July 9, 2026, 10:23pm UTC](https://community.citadel5.com/t/gs-calc-delay-in-program-execution/369 "2026-07-09T22:23:43Z")
Since installing GS-Calc v21.1.2, there is a 3-5 second delay in the start of the program’s execution. I am curious if any other user(s) are experiencing the same symptom. This version introduced Installation (command l… --- ## [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-Base 22.4.2 has been released](https://community.citadel5.com/t/gs-base-22-4-2-has-been-released/389)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [December 3, 2025, 8:34pm UTC](https://community.citadel5.com/t/gs-base-22-4-2-has-been-released/389 "2025-12-03T20:34:31Z")
This is a minor update that clarifies how to use the text file loading options. The “Convert text to numbers” check box label has been changed to a more adequate one: “Analyze and select matching field types (no inform… --- ## [Importing files to GS-Calc](https://community.citadel5.com/t/importing-files-to-gs-calc/388)
**Author:** [@waltmc](https://community.citadel5.com/u/waltmc)\ **Replies:** 0\ **Last updated:** [November 11, 2025, 8:51pm UTC](https://community.citadel5.com/t/importing-files-to-gs-calc/388 "2025-11-11T20:51:12Z")
I have been working with files and spreadsheets created or maintained by various software programs. Sometimes they do not convert to GS-Calc format easily. I have had success with these files by doing the following: - I… --- ## [Is there a way to Hide a Column?](https://community.citadel5.com/t/is-there-a-way-to-hide-a-column/386)
**Author:** [@Raymond](https://community.citadel5.com/u/Raymond)\ **Replies:** 1\ **Last updated:** [July 21, 2025, 9:16pm UTC](https://community.citadel5.com/t/is-there-a-way-to-hide-a-column/386 "2025-07-21T21:16:22Z")
Is there a way to hide a column? I set the width to 1 for now but was wondering if there was a better way… The data is still important but I do not want to see it all the time… --- ## [GS-Base 22.2 / 22.3 has been released](https://community.citadel5.com/t/gs-base-22-2-22-3-has-been-released/381)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [April 25, 2025, 2:10pm UTC](https://community.citadel5.com/t/gs-base-22-2-22-3-has-been-released/381 "2025-04-25T14:10:12Z")
New features in GS-Base 22.2 In the “Verify Files” window you can now specify a list of locations (disks, folders) to be scanned using one list. Simply add subsequent locations separated by the semicolon “;” If you… --- ## [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-Base 22.1 has been released](https://community.citadel5.com/t/gs-base-22-1-has-been-released/376)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [March 1, 2025, 11:07pm UTC](https://community.citadel5.com/t/gs-base-22-1-has-been-released/376 "2025-03-01T23:07:53Z")
New features in GS-Base 22.1 include Python integrations, new built-in functions and command to make using formulas in fields (of all types) much more easier. FIELDS(start, end) Creates an array with field values from… --- ## [GS-Base 22 has been released](https://community.citadel5.com/t/gs-base-22-has-been-released/374)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [December 29, 2024, 8:00pm UTC](https://community.citadel5.com/t/gs-base-22-has-been-released/374 "2024-12-29T20:00:58Z")
New features: Adding text notes, images/files and code snippets outside of tables/records. To add various types of notes to the database files, use the View \> Pivot Tables / Notes command to open the bottom window pane… --- ## [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-Base 21.3 has been released](https://community.citadel5.com/t/gs-base-21-3-has-been-released/370)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [November 18, 2024, 9:31pm UTC](https://community.citadel5.com/t/gs-base-21-3-has-been-released/370 "2024-11-18T21:31:55Z")
In the new “Drop-down lists” dialog box the following two options have been added: Validation Choosing the “Validate entered text” option ensures that a given text will be accepted in the edited field only if it’s al… --- ## [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… --- ## [Default font size in long text](https://community.citadel5.com/t/default-font-size-in-long-text/367)
**Author:** [@GSilva](https://community.citadel5.com/u/GSilva)\ **Replies:** 3\ **Last updated:** [November 10, 2024, 4:06pm UTC](https://community.citadel5.com/t/default-font-size-in-long-text/367 "2024-11-10T16:06:00Z")
Hello. How can I set a default font size for the long text panel? I know how to set a default font size for fields of the type text using the menu “Format→Font” but I never could set a default font size for fields of the… --- ## [GS-Base 21.2 has been released](https://community.citadel5.com/t/gs-base-21-2-has-been-released/366)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [November 7, 2024, 12:53am UTC](https://community.citadel5.com/t/gs-base-21-2-has-been-released/366 "2024-11-07T00:53:10Z")
Along with the “Verify Files” command, GS-Base introduces a few additional “file management” commands to “mass-” rename, copy/move, delete files on your disks. To rename specific files on your disks, use the “Verify… --- ## [GS-Base 21.1 has been released (21.1.1)](https://community.citadel5.com/t/gs-base-21-1-has-been-released-21-1-1/364)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [September 27, 2024, 12:50am UTC](https://community.citadel5.com/t/gs-base-21-1-has-been-released-21-1-1/364 "2024-09-27T00:50:01Z")
Pivot table data fields can be now displayed horizontally, in one line along with given row fields’ values. Previous GS-Base versions displayed data field values in one columns, one row below another: The new op… --- ## [Registered email address](https://community.citadel5.com/t/registered-email-address/365)
**Author:** [@rnmerchant](https://community.citadel5.com/u/rnmerchant)\ **Replies:** 4\ **Last updated:** [October 18, 2024, 6:29pm UTC](https://community.citadel5.com/t/registered-email-address/365 "2024-10-18T18:29:44Z")
I’ve recently been forced to change email provider. I’ve been able to change the email on the ‘forums’ but I don’t see a way to change specifically the email under which the programs are registered. Is there a way to … --- ## [Username - password problems](https://community.citadel5.com/t/username-password-problems/362)
**Author:** [@rnmerchant](https://community.citadel5.com/u/rnmerchant)\ **Replies:** 2\ **Last updated:** [October 17, 2024, 12:49am UTC](https://community.citadel5.com/t/username-password-problems/362 "2024-10-17T00:49:54Z")
I seem to be having username and password problems on both the forum sites and on the Citadel5.com program site. Has something recently changed where usernames have been reset or something? I did a password reset and … --- ## [GS-Base 21 has been released](https://community.citadel5.com/t/gs-base-21-has-been-released/356)
**Author:** [@Citadel5](https://community.citadel5.com/u/Citadel5)\ **Replies:** 0\ **Last updated:** [July 6, 2024, 9:44am UTC](https://community.citadel5.com/t/gs-base-21-has-been-released/356 "2024-07-06T09:44:57Z")
New features in GS-Base 21: You can now open multiple databases at once and use can use a tabbed interface with several options, like the positions of the tabs, whether to enlarge the tabs and display file icons etc. … --- ## [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. [Next page](https://community.citadel5.com/latest.md?page=1)