Softpedia >Windows >Office tools >Office suites >GS-Calc >  Changelog

GS-Calc Changelog

What's new in GS-Calc 20.7

Mar 8, 2024
  • PlaySoundIf(path, type, if_condition, loops, volume)
  • Plays inserted or external mp3 and wav files after completing updating.
  • MessageIf(message, type, if_condition, reference-as-text)
  • Displays a message box with the specified 'message', the 'OK' and 'Cancel' buttons and the
  • "goto" option.
  • ImageIf(if_condition, path_true, path_false, type)
  • Displays the specified image in a cell.
  • An option to use the sumIf() or countIf() functions with the fastest binary searching
  • Method and internal sorting (like other look-up functions do).

New in GS-Calc 20.6 (Feb 23, 2024)

  • 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 fast method is now from two times
  • to the number of times equal to the number of processors cores faster than in previous version.
  • You can now specify that the standard VLOOKUP and MATCH functions in a given workbook should the fastest binary searches without any modifications in the spreadsheet.
  • This can result in tens of times faster updating. Similarly, you can set the standard function to use regular expressions and specific sorting.
  • To use the above feature, use the "Tools > Update Options" command that overwrite the global settings for the current workbook.
  • The delay associated with entering look-up formulas for very large has been removed.
  • In general, the above features should significantly increase the performance of GS-Calc.
  • GS-Calc vs Excel:
  • It will eventually depend on the Excel version/type, but the comparison can suggest the following for large data sets still within the 1M Excel limit):
  • Loading large text files should be around 10-20 times faster in GS-Calc than in Excel.
  • Copying/pasting/filling large data blocks should be on average from several times faster in GS-Calc. For blocks containing formulas this can increase to tens of times or more.
  • Performing VLOOKUP and MATCH for newly pasted/entered data in large data sets can be executed from several times and up (possibly hundreds of times) faster in GS-Calc.
  • GS-Calc workbooks saved in its binary file format are a few times (and up) smaller than files in the Excel XLSB binary file format and can be accordingly loaded faster.
  • A number of help topics has been updated or added

New in GS-Calc 20.5 (Feb 4, 2024)

  • 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, previous GS-Calc version will inform you that a newer version is required.)
  • Text/CSV loading times has been decreased by 30-40%. The "Progress" dialog boxes show both the elapse and ETA times and numbers of rows loaded.
  • An additional option to automatically split text/CSV files with more than 32M rows to multiple sheets.
  • You can now:
  • create multiple sheets if the number of columns exceeds the specified values,
  • create multiple sheets if the number of rows exceeds the specified values,
  • discard columns or rows exceeding the maximums.
  • When saving such text files opened as multiple sheets GS-Calc offers to save all the sheets as text files in one zipped file.
  • Zipped text/CSV files are opened/edited/saved same as plain text files except that you don't have to specify each time the text open parameters as they are already added to these zip's.
  • You can create multiple selections to obtain automatic function values (means, sums, quartiles etc.) for selected cells.
  • Press Ctrl and keep on clicking the desirable cells or select ranges.
  • The table toolbar will display the "combined cells" label before the function values and the current combined references will be
  • shown as a list in the composer toolbar edit field.
  • To copy the calculated values, right-click the table toolbar: the values are copied in one column or two columns if copied with
  • labels, like

New in GS-Calc 20.4.1 (Jan 22, 2024)

  • 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).
  • The performance has been improved by several percent.
  • The "copy As HTML" command has been added. It copies a range of cells as an HTML code. You can paste that copied Clipboard data directly to any HTML page/data in other applications as one continuous block. The copied HTML data displayed in Web browsers look the same as in the worksheet window, including styles and formatting except for the text rotation. Also, the "accounting" numeric style requires that you use (for the related cells) in GS-Calc some font from the fixed-width font family, like Courier New.
  • Worksheet example: https://citadel5.com/help/gscalc/html1.png
  • The same in a web browser: https://citadel5.com/help/gscalc/html2.png
  • Significantly increased speed of copying/pasting large data blocks (e.g. with millions of cells/formulas).
  • Some additional tips regarding the worksheet performance https://citadel5.com/help/gscalc/performance.htm
  • Several missing help topics have been added to the Help file:
  • Copying cells vs duplicating copied cells
  • Using AutoScroll Range to automatically move between cells
  • Selecting functions to display within the table toolbar and related
  • options
  • Hiding view elements / maximizing the table view display areas
  • Cross-highlighting columns/rows for better readability
  • Using the Dark Mode
  • Creating mini-charts in cells
  • Inserting images, files in worksheets
  • Images and lists of images in cells

New in GS-Calc 20.3 (Dec 1, 2023)

  • 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 specifies which formatting attributes to set or clear (restore defaults).
  • Usually, it's convenient to keep all the formatting functions in a separate worksheet. A single cell selection/value can control the appearances of other worksheets.
  • The function can be applied both to existing cells and empty regions without any previous formatting (and in this scenario the 1st update can be slightly slower).
  • There are no limitations for the number or complexity concerning this function. You can use millions of conditionally formatted cells or regions same as any other formulas and nested IFs.
  • If the reference argument specifies entire columns or rows, the formatting action will be applied respectively to column and row styles. The formatting layers are as follows: a table style < column styles < row styles < cell styles (and optionally colors defined in custom style patterns). Cell styles overwrite all other styles.
  • The format_true and format_false parameters be -1 to restore the default cell state for a given attribute or the following:
  • 1 - numeric style (style index relative to the toolbar style list or the name)
  • 2 - custom style pattern (custom style pattern like $#,##0.00)
  • 3 - font size (4 to 256)
  • 4 - font name (string)
  • 6 - bold font (0 | 1)
  • 7 - italic font (0 | 1)
  • 8 - underline font (0 | 1)
  • 9 - strikeout font (0 | 1)
  • 11 - font color (RGB numeric value or a RGB string like "#FFEE00" or color name like "green")
  • 14 - horizontal alignment (0 - left, 1 - center, 2 - right)
  • 15 - vertical alignment (0 - top, 1 - center, 2 - bottom)
  • 16 - wrap text (0 | 1)
  • 17 - horizontal indent (a number of pixels 0 to 64)
  • 18 - vertical indent (a number of pixels 0 to 64)
  • 19 - text rotation (a value in degrees between -180 to 180)
  • 20 - cell borders (a string "position width style color" like "bottom 1px solid blue" or "all 1pt dotted #FF0000" or "dotted red")
  • 21 - borders around selection (a string "width style color" like "1px solid blue" or "thin solid #FF0000" or "dotted red")
  • 22 - cell background color (RGB numeric value or a RGB string like "#FFEE00" or color name like "green")
  • 25 - don't print / print cells (0 | 1)
  • 26 - hyperlink (0 | 1)
  • 27 - cell with filters used by the filter() formula (0 | 1)
  • 28 - cell with image lists (identified by built-in names, like "star start star-half") (0 | 1)
  • 29 - area in-cell chart (with the data series in cells pointed by the cell alignment, e.g. to the left) (0 | 1)
  • 30 - column in-cell chart (0 | 1)
  • 31 - bar in-cell chart (0 | 1)
  • 32 - apply all 1-31 attributes at once as a named custom style (strings specified for custom styles in the "Format > Custom Cell Styles" dialog box
  • The 32nd action type sets all possible cell formatting/style attributes at once. Custom cell styles are added to a workbook with the Format > Custom Cell Styles dialog box and are saved in a workbook. Custom cell styles in a workbook can be saved to or loaded from a global GS-Calc cache using the Save As Default App Styles and Load Default App Styles commands in the Custom Cell Styles dialog box.

New in GS-Calc 20.3 (Dec 1, 2023)

  • 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 specifies which formatting attributes to set or clear (restore defaults).
  • Usually, it's convenient to keep all the formatting functions in a separate worksheet. A single cell selection/value can control the appearances of other worksheets.
  • The function can be applied both to existing cells and empty regions without any previous formatting (and in this scenario the 1st update can be slightly slower).
  • There are no limitations for the number or complexity concerning this function. You can use millions of conditionally formatted cells or regions same as any other formulas and nested IFs.
  • If the reference argument specifies entire columns or rows, the formatting action will be applied respectively to column and row styles. The formatting layers are as follows: a table style < column styles < row styles < cell styles (and optionally colors defined in custom style patterns). Cell styles overwrite all other styles.
  • The format_true and format_false parameters be -1 to restore the default cell state for a given attribute or the following:
  • 1 - numeric style (style index relative to the toolbar style list or the name)
  • 2 - custom style pattern (custom style pattern like $#,##0.00)
  • 3 - font size (4 to 256)
  • 4 - font name (string)
  • 6 - bold font (0 | 1)
  • 7 - italic font (0 | 1)
  • 8 - underline font (0 | 1)
  • 9 - strikeout font (0 | 1)
  • 11 - font color (RGB numeric value or a RGB string like "#FFEE00" or color name like "green")
  • 14 - horizontal alignment (0 - left, 1 - center, 2 - right)
  • 15 - vertical alignment (0 - top, 1 - center, 2 - bottom)
  • 16 - wrap text (0 | 1)
  • 17 - horizontal indent (a number of pixels 0 to 64)
  • 18 - vertical indent (a number of pixels 0 to 64)
  • 19 - text rotation (a value in degrees between -180 to 180)
  • 20 - cell borders (a string "position width style color" like "bottom 1px solid blue" or "all 1pt dotted #FF0000" or "dotted red")
  • 21 - borders around selection (a string "width style color" like "1px solid blue" or "thin solid #FF0000" or "dotted red")
  • 22 - cell background color (RGB numeric value or a RGB string like "#FFEE00" or color name like "green")
  • 25 - don't print / print cells (0 | 1)
  • 26 - hyperlink (0 | 1)
  • 27 - cell with filters used by the filter() formula (0 | 1)
  • 28 - cell with image lists (identified by built-in names, like "star start star-half") (0 | 1)
  • 29 - area in-cell chart (with the data series in cells pointed by the cell alignment, e.g. to the left) (0 | 1)
  • 30 - column in-cell chart (0 | 1)
  • 31 - bar in-cell chart (0 | 1)
  • 32 - apply all 1-31 attributes at once as a named custom style (strings specified for custom styles in the "Format > Custom Cell Styles" dialog box
  • The 32nd action type sets all possible cell formatting/style attributes at once. Custom cell styles are added to a workbook with the Format > Custom Cell Styles dialog box and are saved in a workbook. Custom cell styles in a workbook can be saved to or loaded from a global GS-Calc cache using the Save As Default App Styles and Load Default App Styles commands in the Custom Cell Styles dialog box.

New in GS-Calc 20.2 (Nov 18, 2023)

  • 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-modify/add/remove functions in formulas or some parameters/arguments used by functions in large workbooks without the risk of making mistakes in long formulas,
  • replace existing functions with your own ones,
  • replace some Excel-specific functions from the Excel latest version with GS-Calc functions,
  • replace in xlsx files some recently added Excel functions that are not implement in e.g. Excel 2019,
  • in general: converting formulas from any spreadsheet software using its own extensions.
  • To replace any function(s) in all your formulas instantly, use the "Tools > Convert Function in Formulas" command.
  • You can easily replace a given function by any other functions or expressions that uses some or all of the original parameters in any order, embed them in any other functions or expressions, mix this with cell references
  • or constant values etc.
  • In the first edit field you need to specify how the function look like in formulas.
  • Replace actual parameters with subsequent letters a...z. In real formulas in your worksheet these parameters can be any expressions and nested functions, for example:
  • VLOOKUP(a, b, c, d, e, f)
  • TRIM(a)
  • IF(a, b, c)
  • MATCH(a, b, c)
  • In the second edit field you must specify the expression that will replace that function, for example:
  • MY_VLOOKUP(abs(a) + 1, b, b100:b1000, e, d, 2) + 1
  • TRIM(a & " of" & d10)
  • IF(a, b, IF(c < b, b, c)) * 2
  • MATCH(a, b, 0, 1, 1)
  • After clicking "OK", all found formulas will be updated. You can specify whether these changes are to be
  • performed for the current selection only, for the entire worksheet or for all worksheets in the current workbook.
  • If the replacing expression includes new cell references and you want them to updated in subsequent cells same as when
  • e.g. when filling cells, check the "Update relative cell references" check box.
  • Updating is fast. Millions of formulas can be changed instantly.
  • GS-Calc displays information on how many formulas has been modified.
  • Besides changing GS-Calc worksheets you use this procedure to change Excel *.xlsx data.
  • For example, if you have an Excel worksheet using the new XMATCH or XLOOKUP Excel formula and have Excel 2019
  • that doesn't have these functions. For example, to convert/replace
  • XMATCH(a, b, c, d)
  • You can use:
  • For vertical binary searching (where COLS(b)=1):
  • MATCH(a, b, c, IF((d)=2, 8, IF((f)=-2, 16, IF((c)=-1, 512, 0))))
  • For the classic linear searching returning that last match:
  • MATCH(a, b, c, IF((c)=-1, 512, 0))
  • For the classic linear searching:
  • MATCH(a, b, c)
  • To convert/replace
  • XLOOKUP(a, b, c, d, e, f)
  • You can use a construction similar to the following one:
  • For vertical binary searching (where COLS(b)=1):
  • INDEX(c, MATCH(a, b, e, IF((f)=2, 8, IF((f)=-1, 512, 256))), )

New in GS-Calc 20.1 (Nov 4, 2023)

  • A new 128-bit pseudo-random generator replaced the previous combined MLCG generator.
  • You can also use the hardware random generator, available in newer processors.
  • You can now specify in your worksheet cells that will contain the number of total
  • loops already executed and loops not rejected due to the specified conditions.
  • You can add to the simulation report (containing all intermediate data for not rejected loops) statistics for each output formula specified in a worksheet.

New in GS-Calc 20.0 (Oct 18, 2023)

  • Changes regarding the xlsx format support. Formulas are read and saved from/to xlsx files without conversions. Output xlsx workbook files can exceed 4GB
  • The GS-Base *.gsb format is supported directly and the *.gsb files are loaded as data table collections and saved in the simple GS-Base file format
  • The "Recently Used Files and Folders" window now includes dates in the "Recent Folders" section. They show when a given folder was accessed for the last time
  • Improvements concerning the ODF *.ods file format

New in GS-Calc 19.2 (Sep 8, 2023)

  • 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 icons to each file or folder. Both lists (of files and folders)
  • Can include up to 50 items each and new items are added in a cyclic manner. Both lists can be locked to prevent any new additions or re-ordering. The Default button above the lists opens a folder specified in the Settings > Options > General > Start Folder field.
  • If you want to restore the old short (icon only) Open button, in the settings.xml text
  • File change the line <OldRecentFileList>0<OldRecentFileList> To <OldRecentFileList>1<OldRecentFileList>

New in GS-Calc 19.1 (Jun 28, 2023)

  • 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 descriptions: field_name, field definition.
  • SQLite is the most widely deployed and used database engine.
  • The SQLite *.db format is a popular format that is a useful alternative to the CSV/text files because all column types and encoding are predefined and there is no risk of possible
  • inconsistencies and differences when opening the file in different programs.
  • MySQL *.sql file format support:
  • You can load/create/edit/save databases in the *.sql file format using all types of SQL fields. Similarly to the SQLite format, for each table the first row contains field descriptions: field_name, field definition.
  • Displaying a message after opening a text file (as well as *.db and *.sql files) if the loaded data was partially truncated due to exceeding the maximum number of GS-Calc rows (12 millions), column or the maximum number of characters in a cell.
  • The corresponding scripting functions (for merging records, tables, loading/saving) have been added for the above new file formats.

New in GS-Calc 19.0 (May 31, 2023)

  • New features:
  • 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. GS-Calc will automatically create multiple sheets based on the maximum number of columns per sheet (that you can freely change to anything from 1 to 16,384).
  • If multiple worksheets are created by GS-Base, trying to save back such a set of split sheets as a text file will result in prompting for a new ZIP64 file archive file name instead of overwriting the original source single text file. To load such ZIP text archive later for editing, simply choose the "Text | Text Archive (*.txt, *.csv, *tsv, *.zip)" filter in the "Open File" dialog box.
  • By default, if you choose the "Text | Text Archive (*.txt, *.csv, *tsv, *.zip)" filter in the "Save File" dialog box to save a given *.gsc workbook as text, only the current sheet is saved as a standalone text file. If you want to save all sheets at once, you need to specify a file name with the *.zip extension. This will tell GS-Base to save all created text files to one ZIP64 text archive (along with a short XML file that specifies used text parameters so you won't have to re-enter them when opening that ZIP64 file in the future). When saving ZIP text archives the options to split sheets based on the number of rows is inactive.
  • Improved file compression ratio: in might be not optimal in some cases.

New in GS-Calc 18.9 (May 19, 2023)

  • ew 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 user-defined number of rows.
  • Minor parameter fixes in the (solver) mixed binary and integer linear prog. functions.
  • The "Save Excel File" dialog box
  • The "Open Excel File" dialog box
  • The "Save Text File" dialog box

New in GS-Calc 18.8 (Apr 25, 2023)

  • 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

New in GS-Calc 18.7.2 (Apr 6, 2023)

  • 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 choose quickly any previously defined text file settings with single click in the "Open Text File" dialog box.
  • New "Open Text File" dialog box:
  • Other improvements include re-starting the "Open Text File" dialog and procedure automatically if the utf8 encoding error was encountered in the file. You no longer have to re-open the file manually.
  • Displaying the text file name in the "Open Text File" dialog box.

New in GS-Calc 18.7.1 (Mar 23, 2023)

  • A bug fix: when saving PDF's in-cell line charts were saved as bar charts.

New in GS-Calc 18.6 (Mar 11, 2023)

  • 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. To resize the list window, drag its bottom-right corner or its edges.
  • You can create up to 100 list in one workbook. The maximum number of list items is the same as the maximum number of rows in a spreadsheet: 12 millions. Drop-down lists with millions of items are displayed instantly when you start editing a given cell.
  • Other list options include: AutoAppend, AutoComplete, Sort, multiple-selection separator, validation.
  • Additional information about using drop-down lists added to the Help file.

New in GS-Calc 18.5 (Feb 11, 2023)

  • New features 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;*.tsv;*.tab;*.zip)"
  • To save such a zip for the first time using "Save As", you just need to select this filter and enter both the file name and the ".zip" extension.
  • The advantages of this functionality include:
  • All worksheets can be saved at once as text files in one zip; there is no need for all the merging and copying of text files.
  • You don't have to repeatedly enter or switch between various text file options (separators, encoding, parsing data etc.);
  • when opening such a zipped set of text files, the "Text File Options" dialog box is displayed only once for all files (although you can choose to display it for any of the files individually).
  • Once the zip file is saved, with one or any number of text files, GS-Calc saves in it a short *.xml file with parameters so you can keep on editing/processing/saving/loading such text files without the "Text File Options" dialog boxes and without bothering with re-selecting proper text options.
  • All nested subfolders of the worksheet tree are retained and recreated when you save a *.gsc file to such a zip archive.
  • You can make using such archives even more automatic generating such zip with multiple *.xml options (for some or all text files).
  • If a given text file is to be opened entirely as text (with no numbers and formulas parsing), all worksheet columns created from that file are automatically formatted using the "Text" style.
  • Thus, you no longer have to carefully enter the leading ' when editing cells to keep them all as text.
  • To delete the "Text" file from a given column, click its header and either press Del then "Formatting" or choose the "Default style" on the formatting toolbar.
  • The "Auto-fit column widths" option (to automatically resized column widths in the opened text file) is now available directly in the "Open Text File" dialog box (in addition to its previous location in the "Settings" dialog box.
  • In the "Open Text File" dialog the "Use escaping" option is now turned off by default as it requires careful use and leaving an incorrect escaping symbol can lead to missing characters in the loaded data.

New in GS-Calc 18.4 (Feb 1, 2023)

  • New features 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 versions of GS-Calc and when saving xlsx and ods files (which are also ZIP32's) users can switch back to the older ZIP32.
  • ZIP64 bypasses the standard ZIP limitations: 2GB max. file size and up to approx. 64K streams (worksheets, images) in one file. The ZIP64 *.gsc file sizes can be virtually unlimited.
  • Loading a GS-Calc *.gsc over 4GB file with over 500 million random floating point numbers and text strings (8 worksheets, ~12 million rows each) should take around 10-30s on a computer with 16GB RAM or more.
  • Status bar zip options:
  • Image
  • Inserting files - you can insert any number of (non-executable) files (up to 4GB each). They are displayed as the associated app icons with file names, sizes and the last modification dates.
  • If there are any files inserted in a given workbook file, older GS-Calc versions will display a message that a newer version is required to open that workbook.
  • Sample screen with inserted files:
  • https://citadel5.com/help/gscalc/inserted_files.png
  • Creating backups when saving GS-Calc workbooks. After checking the "Settings > Options > General > Create backups (...)" option when saving an already exiting workbook, its previous version is preserved and renamed by adding the .bak extension.

New in GS-Calc 18.2.0.0 (Oct 7, 2022)

  • 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 just two mouse clicks.
  • For example, the "Insert > FILTER()" command displays a dialog box that determines the optimum parameters including the filters range, hyperlink styles and creates the formula.
  • On the screen below the "Insert > FILTER()" command was used to filter data in the "sample.gsc -> orders" worksheet with a single "OK" click.
  • Creating hyperlinks has been improved. You can now simply use one of the "Edit > Copy as Hyperlink" commands

New in GS-Calc 18.1.0.0 (Aug 30, 2022)

  • 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 up to six columns and pre- or post-filter the data to find compound duplicates consisting of up to 100 keys.
  • Filters include: Regex, Excel-style patterns, all the variants of numeric and literal =, <, > relations, similar ("fuzzy") searches, ranges, content length comparisons, empty cells, duplicates.
  • On an average PC you should expect to perform filtering for a few millions of rows in a few seconds or nearly instantly.
  • Entering filters is easy: you can use the new "Search Filter" special format style for the desirable cells. This will display nicely formatted filters with e.g. syntax coloring for Regex expressions and graphic sort order indications. When editing such cells, GS-Calc displays a cell-aligned dialog box with all the filter specification and sort options
  • Filtered records can be easily edited. You simply specify in the FILTER() function an option to include hyperlinks to the source data as the 1st column of the results. You can click it (or press Space), jump to the source table and after completing editing you just click the "back" bookmark toolbar button (Alt+F11) to go to the same cell in the results.
  • https://citadel5.com/help/gscalc/filtering.htm
  • The new "hyperlink" special style enabling you to use a single click to:
  • jump to any locations in the workbook or in other workbooks and go back
  • with another single click (via the "back" bookmark toolbar button);
  • open websites, open e-mail clients, files etc. Supported protocols/prefixes
  • include: wbook://, http://, https://, file://, mailto:, ftp://, gopher://,
  • nntp://, news://, wais://, telnet://, prospero://, res://
  • Workbooks can contain any number of hyperlinks. They don't slow down workbooks nor make them larger.
  • https://citadel5.com/help/gscalc/hyperlinks.htm
  • The new "Image" special style enabling you to enter in a cell any sequence of different image names and then display the result in one line in a cell. The predefined image names include various buttons, flags and symbols. For example, entering in a cell
  • star, star, star, start, star-half, star-empty, star-empty
  • will display in a cell a 7-star-style rating with 4.5 stars
  • Other improvements:
  • a shortcut to open/close the bottom functional panes;
  • significantly increased speed when loading text files if the you select; the option to parse formatted dates and positive/negative time periods;
  • scrolling speed/responsiveness has been increased;
  • the "Background image" dialog box has been changed to handle both built-in and user-added workbook images and to make it more convenient to use.

New in GS-Calc 18.0.0.0 (Jul 3, 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 should be 30-40 times faster (which means instant) and even more for larger series. At the same time such charts should be more readable and all data peaks remain exact and clearly visible.
  • Improved category axes. If no category labels are specified, the "interval" and (inner) "divisor" axis parameters are now active and apply to the data point cardinal numbers, same as for XY charts. Charts can use up to 32 axes with individually set parameters and styles or as shared axes and any axis can be displayed in the "dual" mode.
  • 2D Pie charts can be mixed with any other 2D chart.
  • Selecting colors for pie charts (and for individual data points on any chart type in general) has been improved. You no longer need to press the "Apply" button individually after adding each new color.
  • Adding new series has been improved: chart classes for new series are now always automatically set based on the recently selected series. Various 2D charts can be easily mixed by simple changing any series chart class.
  • A fix: previously, user-defined Y-grid lines caused turning off existing user-defined X-grid lines.
  • Now you can easily define up to 16 vertical and horizontal chart custom grid lines at the same time using
  • various styles and modes, statically or based on some worksheet cell values.

New in GS-Calc 17.9 (May 18, 2022)

  • Exchanging data with GS-Base via the *.xls format:
  • A number of various changes and fixes to the "Excel 2003 XML" format to ensure it enables transferring all the applicable data between GS-Calc and the latest Excel versions.
  • Added (explicitly) the "Custom" number style category.
  • The "Text" style behavior has been changed to conform to how it's used in Excel.
  • The (Settings > Editing >) "Evaluate expressions without leading =" option has been added. When entering a formula without "=" it causes inserting its value (a number/text/array result).
  • Fixes concerning ignoring some cell border width attributes in the OpenDocument *.ods format.

New in GS-Calc 17.6 (Dec 30, 2021)

  • 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).
  • The RegEx menu used in GS-Calc to insert RegEx sequences easier has been extended to include the Unicode/Non-ASCII sequences as well.
  • The "Find & Replace toolbar > Options > Search Range/Worksheet" options have been removed as they might be difficult to track/notice and use search ranges adequately. In GS-Calc 17.6 selecting a range of cells automatically limits the searching and replacing procedure to that range. Clicking a worksheet (any cell) invalidates the active search range and searching is performed within the whole worksheet till a new selection is made. Changing search/replace options or text strings also initiates a new search with the current (new) selection.
  • The new "Update" toolbar button, the "Manage Bookmarks" menu attached to the "Add Bookmark" button.
  • The amount of memory used by the "Replace All" command to enable the Undo action has been minimized. (Previously the allocated memory was proportional to the whole table, which might make it difficult to use.)

New in GS-Calc 17.5 (Oct 15, 2021)

  • Changes in this version:
  • Custom lists to insert data series. List items can be embedded in cell strings.
  • Built-in series with day/month names.
  • Formula based series. This enables you to define any type of data series including those referring to resources elsewhere in your workbooks. Used formulas are saved as a "recently used" list and references are updated automatically when applied to another worksheet location. Random series generated directly via a dialog box. (The previous used functionality based on the formula is still an option.) Generating series of strings randomly selected from a given custom list.

New in GS-Calc 17.4 (May 7, 2021)

  • 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 for all popular languages and create their own dictionaries.
  • Each dictionary, either the Windows system dictionary or Hunspell dictionaries can be extended dynamically. Words added by users are saved in the specified folders in easily editable text files.
  • Multi-language spell checking is now available by specifying the font language in the "Cell Format" dialog box.

New in GS-Calc 17.3 (Mar 4, 2021)

  • 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 documented in the recent versions).
  • New COM functions/methods include new methods for inserting data, for example: [Get|Insert]NumberRC(), [Get|Insert]TextRC(), [Get|Insert]FormulaRC() etc.
  • They can be used instead the [Get|Insert]Data() method when filling large worksheets. They don't perform auto-formatting, activating the undo and auto-repainting the screen (which is usually not needed in such cases). If the client app is a compiled program as in the above examples, they will perform up to several hundred times faster than the older [Get|Insert]Data().
  • An additional "regular expression" flag was added to the "find()" function: SEARCH::RegExStr.
  • If it's specified, instead of the index the function returns the substring that matches the pattern.
  • For example:
  • =find("wd{2,3}", "abc4567ghr", 1, SEARCH::RegEx) returns 3
  • =find("wd{2,3}", "abc4567ghr", 1, SEARCH::RegExStr) returns "c456"
  • Minor updates like: shortcuts related to the "After pressing Enter" options in the "Settings" dialog box, setup improvements, faster screen redrawing in some cases.

New in GS-Calc 17.2 (Nov 22, 2019)

  • Over 60 new (mainly statistical) functions has been added.
  • Updating speed has been increased by 10-15%.
  • New commands and menus in the Pivot Table pane: saving reports, copying.
  • Additional "Replace" menu options.

New in GS-Calc 17.0.2 (Nov 22, 2019)

  • 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 functions. They can accept and return all the argument types and additionally they can also return images displayed directly in worksheets or messages displayed after each update. What's important, using these functions GS-Calc retains the complete multicore support, the same speed and memory requirements.
  • The status bar displays the recent update/recalculation time in s or ms. (Click it to display a context menu.)

New in GS-Calc 16.9 (Dec 23, 2018)

  • 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 models.
  • Minor changes and bug fixes: added missing help for the "Edit > Operations" command and a fix issue concerning using the optional formula-based rule in the "Operations" dialog box.

New in GS-Calc 16.8.5 (Dec 4, 2018)

  • 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,
  • kurtosis,
  • skewness,
  • most frequently occurring numbers and strings.
  • To maximize performance, (most of) the pivot functions can make use
  • of up to 64 processor cores.
  • Added optional chi-square tests for generated pivot tables.
  • Sample screen:
  • (Hints: tables must specify the "Grand total" column and row; if there are not any column fields, the expected test chi2 values are assumed to be uniformly distributed.)
  • Sort ranges and keys can be saved and re-used easily.
  • In the IF() functions now only one of the two conditional parameters is evaluated. Previously both were calculated so in this update IF() functions will be proportionally faster.
  • The chitest() function now returns P(X > c^2) instead of the P(X < c^2). The "Settings > Legacy Compatibility" option enables preserving the previous behavior.

New in GS-Calc 16.5 (Jul 19, 2017)

  • Added new "IFs" functions:
  • percentileIfs(), percentileAIfs()
  • averageIfs(), averageAIfs()
  • geoMeanIfs(), geoMeanAIfs()
  • harMeanIfs(), harMeanAIfs()
  • medianIfs(), medianAIfs()
  • maxIfs(), maxAIfs()
  • minIfs(), minAIfs()
  • varIfs(), varAIfs()
  • varpIfs(), varpAIfs()
  • stddevIfs(), stddevAIfs()
  • stddevpIfs(), stddevpAIfs()
  • modeIfs(), modeAIfs()
  • The above functions offer much better performance than their non-IFs variants combined with nested array plain IF's functions. The details concerning their usage, returned error codes and examples are available in the "Formula" dialog box.
  • Users can create a simple zip archive of text files (tables) which will be opened as GS-Calc workbooks with usual worksheet folders. The import options are specified as *.xml zip streams so no interaction is required during importing/opening.
  • The "Settings > Options > General > Hide cell markers" option now also applies to printing (and specifies whether formula markers should be visible on the printout).
  • The (missing) "<>" operator has been added to all IFs functions.
  • Minor bug fixes.

New in GS-Calc 16.3 (Dec 20, 2016)

  • 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 re
  • A new pivot table setup dialog box with additional options. Also, the "display empty cells are zeroes" has been replaced by the "Treat empty data fields as zero values" option.
  • New filtering options similar to those known from GS-Base.
  • A new option to prevent displaying the "Functions List" dialog box after clicking the toolbar formula edit field.
  • A new find/replace option to limit searching to the selected cell range.

New in GS-Calc 16.0.1 (Jan 22, 2016)

  • Update
  • The workbook update/recalculation speed has been increased. For most workbooks the speed gain should fall into the 25% - 40% range. For workbooks containing very long formulas with single cell references this percentage can be significantly higher.
  • Faster opening ODF files containing large numbers of cell styles. The average improvement should be between 15% and 30% and will be even more significant for very large *.ods files which additionally contain some extremely large numbers of cell styles.
  • Faster sorting.
  • Added resizable "File Open/Save" dialog boxes.
  • Bug fixes:
  • Fixed issue concerning named ranges.
  • Fixed bug concerning saving Open Document *.ods files with formulas containing "nearly" the maximum (1024) number of characters.
  • Worksheet names starting with the "True" or "False" string were not recognized in formulas correctly.
  • Corrected descriptions of the minMC(), minSimplex() and mtxSVD() functions. (Missing some useful information, switched values of a parameter in one case.)

New in GS-Calc 16 (Nov 10, 2015)

  • Changes in this version:
  • Parts of the toolbars have been modified and several new commands have been added.
  • The "->" button near the "Location" toolbar edit field now switches (in a cyclic manner) between three modes of displaying the references: plain ranges, ranges with worksheet names and full names including the file paths.
  • The "Bookmark" toolbar combo box has been removed. The three newly added "Bookmark" buttons are: "* - Add bookmark", " - Go to the next bookmark". Bookmark names are no longer used and to add a bookmark, a single click is sufficient. Bookmarks are now stored separately for each workbook.
  • The "Formula" toolbar combo box has been replaced by a new edit field (supporting syntax highlighting). Cell formulas are no longer displayed automatically in that edit field - you need to click the "Sigma" button to "load" them. Thanks to this it should be easier to create compound and e.g. similar formulas in multiple cells. The new "+" button adds data entered in the "Location" edit field described above.
  • The "Formula Composer" dialog has been removed. The new dialog box is simply called "List of formulas" and it's attached to the cell edit field and to the toolbar "Formula" edit field (where it's activated by clicking that field):
  • The "List Of Formulas" dialog box updates the selected formula name
  • automatically as you write (updates/searches are triggered by
  • entering the opening "(" in the function names):
  • If a given name is incorrect, the "List Of Formulas" dialog box display
  • suggestions:
  • Pressing "Enter" or double-clicking copies the selected function name
  • and replaces the previous one.
  • The bottom pane previously occupied by the "Inspect cells" view now contains a tabbed set of views:
  • Inspect Formula
  • Named Ranges
  • Bookmarks
  • Notes
  • Search Results
  • The "Notes" edit field now features line numbering and more consistent editing without the former formatting (font sizes and colors) options.
  • The "Search Results" view contains cells found after choosing the new "Find All" command on the "Find And Replace" toolbar.
  • This command searches either the entire worksheet or the current selection for cells matching either the specified "Find" filter (typically, a regular expression) or any of the other criteria, including searching for duplicates in rows:
  • Help updates.

New in GS-Calc 15.2 (Oct 19, 2015)

  • 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 sequences accidentally, which could result in unexpected search results.
  • New "Insert" buttons and menus related to Regex have been added to the "Find & Replace" toolbar. The menus contain (typically) most frequently used Regular Expression control characters along with their short descriptions. It should simplify the usage of Regex and make it easier to take the full advantage of the flexibility and strength of that search mode.

New in GS-Calc 15.1 (Aug 26, 2015)

  • Syntax coloring/highlighting for JScript and VBScript scripts in the "Scripts" window.
  • Optional syntax coloring when editing cells (e.g. cell references, strings and error highlighting).
  • Spell checking is now available as a separate menu command (as opposed to the previous "always on" state in every cell) with the standard dialog box layout, language and spelling options.
  • Many changes/improvements concerning cell editing actions to make it work more like in Excel (for example: separate "enter" and "edit" modes, same cursor "behavior", tips displayed after clicking or scrolling to a given function in the edited cell etc.).

New in GS-Calc 15 (Aug 10, 2015)

  • 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 saved by GS-Calc often couldn't be opened correctly by some popular spreadsheets.) Internally, drop-down lists are now saved/stored as validation rules
  • When saving *.ods files GS-Calc displays a list of possible compatibility issues resulting from the use of features (e.g. more than two chart axes, more than 1 mln rows etc.) that might not be processed correctly in other spreadsheets
  • Shared chart axes. You can specify any x- or y-axis to be used by multiple series and the "shared" displayed data range will be calculated automatically. Previous versions required you to specify "manually" the same axis parameters for each axis in such a group and leaving only one of them visible
  • Various new parameters and configuration/display options concerning chart data series, axes, chart walls (e.g. axes without labels, labels without axes, separate error bar styles) and fixes
  • After selecting a chart and printing it, it's now printed either using it's original size or it's scaled proportionally to fit to the printed page. GS-Calc 14.x always stretched a given chart "unproportionally" to fit to the whole page
  • Merging cells. The "Merge Cells" and "Split Cells" commands have been added to the "Format" menu. The previously existing similar "Edit" menu commands have been renamed to "Merge Cell Contents" and "Split Cell Contents"
  • The "Insert Copied Cells" command has been added to the "Edit" menu
  • Additional confirmations are now required before executing the "File > Reload", "File > Save As" (to a non-spreadsheet format, which results in stripping off formatting etc.) and "Inspect Cells > Remove All" commands
  • The "Find & Add" menu in the "Inspect Cells" pane contains three more commands/categories: "Merged Cells", "Cells With Validation Rules", "Protected Cells", "Not Printed Cells"
  • Added two new help topics concerning merging cells and the "Inspect Cells" pane/commands usage
  • Two new help topics concerning merging cells and the "Inspect Cells" pane/commands usage
  • Changed the way references are modified via the "Insert Cells" and "Remove Commands" commands. (Previously: similarly to the Copy/Paste operations. Now: similarly to the Insert Column/Row operations.)

New in GS-Calc 14.6 (Jun 1, 2015)

  • The "Insert Cells" and "Remove Cells" commands have been added to the "Tools" menu.
  • The "Tools" menu items representing various "Insert Columns/Rows" variants have been replaced by a single command that displays a dialog box with all the corresponding options.
  • The "Tools" menu items representing various local (workbook) overwrites of the global update options have been replaced by a single dialog box.
  • The "Insert > Date" command now displays a dialog box with a calendar control enabling users to choose some specific date, to specify the long date format, to include the current time and to specify the time zone. Similarly, the "Insert > Time" command enables users to specify the time zone.
  • Two new help sections have been added. They describe in details how to use splitted views, how the "manual" and "automatic" splitting modes work and how to use the synchronization commands/options.
  • A number of shortcuts used in L.O. and Excel have been added. For example:
  • CTRL+SHIFT+Plus Inserts cells.
  • CTRL+SHIFT+Minus Remove cells.
  • CTRL+; Inserts date.
  • CTRL+SHIFT+; Inserts time.
  • CTRL+SHIFT+$ Applies the Currency format with two decimal places.
  • CTRL+SHIFT+% Applies the Percentage format with no decimal places.
  • CTRL+SHIFT+^ Applies the Exponential number format with two decimal places.
  • CTRL+SHIFT+# Applies the Date format with the day, month, and year.
  • CTRL+SHIFT+@ Applies the Time format with the hour and minute, and AM or PM.
  • CTRL+SHIFT+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
  • Some minor changes/fixes: the default grid color is darker now, a few labels in dialog boxes were slightly truncated in some screen configurations.

New in GS-Calc 14.4.2 (Apr 7, 2015)

  • 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 automatically fit column to their contents in opened text and xBase files. Selecting this option might slow down opening very large text and xBase files - for best performance allow GS-Calc to use more/all of the available processor cores in the "Options > Updating" dialog box (as calculating column widths can now make use of all processor cores as well). The Auto-fitting can be performed within the min. and max. limits specified optionally by the user. (Please see the "Settings" help topic for more details.)
  • A new (global) option to automatically close the "Chart" dialog box when you switch to another worksheet. (Leaving this option unchecked will be useful if the chart data is to be selected in different worksheet(s).)
  • In the "Open Text File" dialog box the "Quoting symbol" and the "Escaping symbol" are now optional which should help you
  • to open text files that don't conform to this standard cell quoting rules.
  • Modified/improved mouse wheel handling. Fixed problems with the "hyper-fast" scrolling functionality offered by some mice. Additionally, in the "Options" dialog box you can specify whether the smallest wheel rotation should result in line scrolling or page scrolling.
  • The help file was updated to include more information about text files and about necessary steps to register scripting interfaces and using scripts.

New in GS-Calc 14.4.1 (Apr 7, 2015)

  • A fixed bug concerning splitting worksheet view by clicking the splitter lines/bars (placed near the scroll bars). In some systems GS-Calc could stop responding. (Splitting views with the "View" menu commands worked correctly.)

New in GS-Calc 14.2 (Feb 17, 2015)

  • 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 (and opened text and xBase files)
  • Fixed issues concerning importing GS-Calc 6.0 files
  • Minor fixes and help / GUI changes

New in GS-Calc 14 (Dec 27, 2014)

  • 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-lines and y-lines; textual cues/tips in edit fields; disabling 3d or 2d non-applicable to the currently edited chart type.
  • Chart templates. Creating a complete chart with all data settings, formatting options, styles and sizes using a single click.
  • More flexible and complete options to select automatically the initial data series, series names and categories / x-domain values.
  • For non-XY charts, the default legend symbol is automatically set to the largest rectangle symbol. (Previously it was the medium one, which required editing the "Series Style" tab.). Legend symbols can still be freely changed on the "Series Style" tab.
  • Similarly to printing a given selected chart on the whole single page or printing a cell range, the corresponding PDF saving functionality was added to "Edit" menu as the "Copy As PDF To...". (Side by side with the "Save Page" command in the "Print Preview" mode.)
  • The "Copy" and "Paste" commands copy and paste the Unicode UTF-16 text to the Clipboard and use the default quoting mechanism to include multiline text etc. (whereas previously used UTF8 might cause various problems when exchanging data with other applications, especially when pasting multiline text, including not responding).
  • The "Transpose" and "Reverse Columns/Rows" commands have been explicitly added to the "Edit" menu (instead of the previously used "Copy" command variants).
  • The "Open File"/"Save File" dialog boxes include additional options to handle different text code pages.
  • The "Edit" menu has been reorganized to include a few new commands: "Copy With Options" (which offers the same options as the "Save Text File" dialog box), "Paste With Options" (which offers the same options as the "Open Text File" dialog box), "Paste Image" (which explicitly pastes an image from the Clipboard; when using the plain "Paste" the text format has always precedence over other available data formats), "Merge Cells" (which merges cell contents from subsequent columns using a given separator), "Split Cells (which splits cell contents to subsequent columns using a given separator).
  • Aside from the text/cell data, the "Copy" command now also automatically makes available (upon request) the corresponding picture representation of the copied data.
  • The "Sort" dialog box now includes 10 sort keys.
  • Added/modified options in the "Sort" dialog box. Saving recently used sorting options to the settings file.
  • When editing cells GS-Calc optionally uses the default system spell checker in Windows 8.x/10.
  • The cell protection is now also active when explicitly deleting cells. (Previously it was activated only when the deletion resulted from any other actions.)
  • All the user-defined data styles are now added to the toolbar drop down list of styles.
  • The top edit fields in the "Statistics" dialog are now inactive till the corresponding check boxes are selected (to avoid situations where forgetting to select that check box resulted in not saving the specified range parameters).
  • Optionally using extended formatting toolbar buttons states (checked/unchecked/undetermined), which provides more information about the formatting of a given range but results in slower selecting. (Previously only binary states was supported and only the top-left cell was checked.)
  • New options in the "Options" dialog box.
  • The "Preview" window in the "Background Image" dialog box is now updated to reflect the currently specified image formatting options.
  • The ::NoPattern and ::StringSort flags used in MATCH(), V-/HLOOKUP and PIVOTDATA() functions are no longer required/used (and documented) as using no simple wildcard patterns and ignoring punctuation are now the default state. To (still) use them, turn on the respective option in the "Legacy Compatibility" dialog box. (Users are encouraged to use the regular expressions instead.) Additionally, the following search/sort flags have been added: ::IgnorePunctuation ::Pattern and ::NeutralSortOrder (using system-language independent "character" sort order).
  • A number of various cosmetic changes/improvements.
  • Bug fixes.

New in GS-Calc 11.7 (Jun 5, 2014)

  • Changes in this version:
  • The "Auto" column/row width/height commands act in a binary way now. (Previously the width/height had to be re-set explicitly.)
  • Double-clicking column/row header edge auto-adjusts the width/height but this no longer activates/sets the permanent "auto" mode.
  • Using the point-and-click parameter selection no longer requires pressing the "Ctrl" key. The edit field remains in place when selecting cells/ranges and scrolling the view. If the editing mode is started by double-clicking or if the point-and-click action is performed, GS-Calc will display three additional buttons along with the edit field:
  • the location of the edited cell,
  • the "Ok" and "Cancel" buttons (that can be used instead of Enter/Esc).
  • Changing the active worksheet "suspends" editing and it's re-started after switching back to that worksheet. The "location" ("Go To") toolbar field displays now the full cell references along with worksheet/folder paths. You can copy/paste it to select formula parameters in different worksheets.
  • Renaming a worksheet or folder requires entering a unique name.
  • After renaming a worksheet, the references are changed accordingly now.
  • Bug fixes:
  • The workDay() functions ignored the "minus" sign when specifying past days.
  • Using the "Reload" command resulted in resetting the "Undo" level to the minimum value (of 2).
  • Repeating sequences of the "Insert Worksheet", "Insert Folder", "Delete Worksheet" and "Undo" commands in certain specific order could cause crashing.
  • xBase memo files (dBase, Clipper, Fox Pro) larger than 2GB couldn't be opened correctly.
  • Clipper files with memo files saved as the *.fpt variant could not be opened. At the moment GS-Calc reads and preserves the existing memo format for Clipper files, still using the *.dbt variant for new files.

New in GS-Calc 11.6.1 (May 5, 2014)

  • A new "Allow empty matches" command has been added to the "Options" menu of the "Find" toolbar. Empty matches occur for regular expression like a? or \A\z (which lets you now search for e.g. empty cells within a block of data).
  • Fixed bug which may occur when you try to paste plain text from an external source.

New in GS-Calc 11.4.2 (Nov 30, 2013)

  • If the selected chart data and options result in displaying over 65,536 gridlines or axis "ticks" for one data series / chart axis, GS-Calc will freeze for some longer time and eventually will run out of memory.

New in GS-Calc 11.4.1 (Nov 26, 2013)

  • The following bugs have been fixed in this update:
  • The "display factor" option for the "general" and "currency" data styles is ignored when it's used to format chart axis labels
  • Handling user-defined data styles has been improved

New in GS-Calc 11.4 (Nov 26, 2013)

  • During the installation GS-Calc incorrectly/unnecessary caused Windows 7/8.x to ask for permission elevation even though GS-Calc doesn't perform any action requiring administrator permissions
  • Under certain circumstances subsequent setting, adding and deleting cell background images could cause crashing or could cause displaying a write error when using the binary *.gsc format
  • The height of edit controls in dialog boxes has been increased to align the attached "up-down" controls in Windows 7/8.x better
  • Fixed bug that occurs when opening a text file which contains such quoted cells that there are leading and/or trailing spaces respectively between the opening quotation mark and the previous cell separator symbol and between the closing quotation mark and the next cell separator symbol
  • Fixed bug that occurs when the last cell of a given imported text file is quoted. In such a case that cell was displayed in GS-Calc along with the quotation marks
  • The option of importing "escaped" character in text files has been added. The escape symbol can be specified in the "Open Text File" dialog box
  • The corresponding uninstall section for GS-Calc in the "Control Panel" now contains more detailed information about GS-Calc
  • The setup was partially modified which includes removing the the *.gsc file type registration and COM registration from the setup options. These optional Windows registry modifications are now performed via the "Settings > Register (...)" commands when GS-Calc is launched with administrator permissions

New in GS-Calc 11.3.2 (Nov 22, 2013)

  • The following bugs have been fixed in this update:
  • A bug that occurs if you select a very large range of non-empty cells (in practice, at least several millions), then quickly - before the top table/view information field gets updated - execute the "Save" command using the .gsc format. In this scenario GS-Calc will crash.
  • This bug concerns only the .gsc file format. It doesn't occur for the .ods or any of the remaining formats. It also doesn't occur if the stats pane of that top table/view information field is hidden/turned off or limited to the fast counting functions only.
  • It's also unlikely to occur when using relatively fast computers as those statistical functions are updated more or less instantly.
  • A bug that occurs if the chart data series field specifies a formula which contains references to worksheet cells which contain other formulas. In this case, after opening a file containing such a chart, you had to perform some editing action (or explicitly use the "Update" command) to redraw that chart as initially it displayed a series of zero values.
  • A bug that occurs if you open a file with some selected range of cells. In such a case the stats functions within the top table/view information field/toolbar initially contained zero/null values and you had to perform some action to refresh them for the first time.

New in GS-Calc 11.3.1 (Nov 22, 2013)

  • The following bugs have been fixed in this update:
  • Fixed bug which occurs when formatting very large cell ranges that occupy +50% of the free memory. (The max. limits for the 32-bit GS-Calc are: 2GB in 32bit OS and 4GB in 64bit OS). Under certain circumstances this bug could cause crashing when GS-Calc allocates the "Undo" buffer for that formatting action
  • Tip - To change the font (or any other formatting property) for the whole worksheet it might be more convenient to use "Format > Cell Style Palette > Edit Style Properties" (of the default style)
  • Solved problem with very slow font property modifications for cell ranges with a large number of rows. Such formatting should be tens of times faster now
  • Solved problem with table status line updating and calculations: when closing a workbook immediately after some very large range (tens of millions of cells or more) was selected GS-Calc displayed information about pending update, not specifying which update that message refers to
  • As table stats calculation doesn't concern the workbook contents, this type of updates are now terminated automatically when closing workbooks

New in GS-Calc 11.3 (Nov 22, 2013)

  • Changes and bug fixes:
  • The "Cell Style" dialog box now uses a drop-down list to specify the negative data style. The "with-minus-and-in-red" option was added
  • The "general" and "currency" styles can use the "display factor" property (which scales down the displayed numbers by the power of 1000)
  • The "Recent Files" menu/list has been (additionally) attached to the "Open" toolbar button. The list now contains two sections: "Recent Files" and "Recent Folders"
  • The new "View > Splitter Line Width" menu enables you to modify the width of the splitter lines separating various panes in a workbook window
  • Selected cells are now rendered with darker/"dimmed" colors (no color inversion is performed). The flickering associated with selecting has been reduced
  • Added option to reset the creation parameters in the "Statistics" dialog box
  • Added tooltips for all toolbar buttons (as some buttons didn't have them previously)
  • Fixed bug concerning editing charts: if (1) some chart formatting property was changed in the "chart property" dialog box and (2) the "Save" command was performed without closing that dialog box and (3) further chart formatting was performed, GS-Calc crashes
  • Fixed bug concerning saving to PDFs: if a chart uses a data series with a large number of data points (+ several thousands), GS-Calc crashes when executing that "Save to PDF" command
  • Fixed problem with bad font quality for text in selected cells if the ClearType mode is turned on

New in GS-Calc 11.2 (Oct 12, 2013)

  • All the "copy" operations are much faster now (nn-times or more for very large ranges). Previously GS-Calc copied the data both to the internal buffer for its own use and - as text - to the Clipboard, for other applications at the same time. Currently that 2nd copying stage is delayed until some application actually requests such text data accessing the Clipboard.
  • Text copied to the Clipboard by some of the "Edit > Copy Options" commands was truncated. (This didn't affect GS-Calc directly as it uses an internal buffer for copying and pasting.)
  • The "2-mins" and "3-mins" values on the "AutoSave" and "AutoClose" lists in the "Options" dialog box were switched. Additionally, those combo boxes are now replaced by edit fields.

New in GS-Calc 11.1 (Jun 19, 2013)

  • Increased maximum memory usage up to 4GB in 64bit systems (which is the maximum value for a 32bit application; the previous limit was 2GB for both 32- and 64-bit systems).
  • Displaying open/save progress dialog boxes for all available file formats when saving/opening files.
  • Support for UTF-16 Unicode text files.
  • Significantly reduced memory usage when loading text files.
  • New "Edit > Paste As Text" command causing inserting all cells as text.
  • New "Parse Dates in formatted cells only" setting in the "Options" dialog box (causing converting of the entered date/time strings to date/time serial numbers only in cells that are formatted as date/time).
  • New "Open Text File" dialog box showing file data sample and the list of recently used fixed column widths.
  • Removing trailing spaces in the "fixed column width" text files.
  • Saving more parameters (including all recently used settings from the "Open Text File" and "Save Text File" dialog boxes) to the profile/settings file.
  • Significantly reduced memory usage when inserting and deleting columns and rows.
  • Significantly increased speed of inserting and deleting columns and rows for very large files.
  • Automatic undo buffer freeing/resetting when performing some editing action and the "out-of-memory" state is encountered.
  • Increased GS-Calc "responsiveness" when editing cells in very large files. (Editing with Auto-update "on" and "off" should now look more or less the same.)
  • Layout changes in the "Options" dialog box.
  • Bug fixes and other minor changes.

New in GS-Calc 11.0.3 (May 2, 2013)

  • New features and changes:
  • GS-Calc 11 supports scripting using both JScript and VBScript scripts. Scripts can be both global (stored in the
  • configuration/settings file) and local (stored in workbooks). Scripts are stored in a tree-like structure which should
  • allow you to manage them with ease.
  • Significantly improved compatibility with *.ods files saved by Excel 2010 / 2013:
  • When using optional formula parameters using explicitly the blank
  • parameters is not longer required. Previously this caused the #SYNTAX!
  • errors when opening *.ods files saved by Excel.
  • Named ranges. (At the moment they can be managed by scripting only.)
  • Changes in some function behavior (SUM, INDEX) to ensure better Excel
  • compatibility. The previous state can be restored with
  • the "Settings > Legacy Compatibility" command.
  • Modified data styles to accept all complex/mixed data styles etc.
  • Regular expressions in "Find & Replace" and in several formulas including Find(), Replace(), vLookUp(), hLookUp()
  • and Match(). (For the details and examples, please see the respective help section).
  • A new, improved "Find & Replace" toolbar.
  • Dragging and Dropping can be used to open files in any of the available formats.
  • Modified column/row resizing. The screen update is now instant.
  • Double-clicking column and row headings re-sizes them to fit the maximum width and height of the cells they contain.
  • Fixed problem concerning slow cell selecting (and scrolling) in very large worksheets.
  • This was caused by the table toolbar statistics displayed at the top of the table and could be improved only
  • by turning off the individual sections of that toolbar. Right now the selected toolbar functions are calculated
  • as the background process.
  • Modified and improved setup.
  • Significant number of bug fixes and minor improvements.

New in GS-Calc 10.1 (Jan 21, 2013)

  • some possible stability problems when running out of memory,
  • problems with nested multiple pane splitting when using the (non-default) "free-hand" view splitting mode.

New in GS-Calc 10 (Jul 4, 2012)

  • A new alternative binary *.gsc file format enabling you to create files from a few to even hundreds of times smaller than the current Open Document *.ods format. The actual compression depends on whether there are some detectable data or formula patterns in a given workbook. Loading and saving times should be improved by the same factor as well.
  • Each *.gsc file is a zip file that may contain some additional useful information like thumbnails or notes that can be accessed without GS-Calc.
  • A new "File > Saved Content & Statistics" window that contains various information about the file: creation and save parameters, editing cycles and editing time. In this window you can also specify that only some formula values should be saved (which increases the compression ratio even further) and define thumbnail image options.
  • The "Insert > Series" command can be now used to create series of cells with interleaving blank cells and series of formulas. Formula series can feature both increasing and decreasing referenced row or column numbers, both horizontally and vertically. (For more information, examples and tips, deselect any ranges and press the F8 key.)
  • New options in the "Sort Cell Range" dialog box. You can now specify whether the word sort or case-sensitive sort order should be used. Additionally, when sorting GS-Calc can be forced to treat all data as text strings or to convert text strings that look like numbers to numbers.
  • Flicker-free screen updates.
  • Notes that can be added to each documents. They are displayed and edited in two new optional panes turned of/off via the "View > Notes - Left Pane / Bottom Pane" commands. Notes are edited and stored as fully formatted RTF text. Right- click it to view the available formatting commands.
  • A new optional dialog box displayed when deleting (Del) cells. It enables you to specify what should be deleted: numeric or textual data, formulas, formatting, drop-down lists or comments.
  • Re-designed SEARCH::AutoSort flag/functionality in the "match()" and lookup functions. It's now possible to perform "mixed-data" searches in both the linear and the quick searching mode. GS-Calc handles all the necessary conversions for you. For more information, please see the "Lookup functions > match()" help topic and the sample usage in the "sample.gsc" file.

New in GS-Calc 9.4.3 (May 23, 2012)

  • New features and changes:
  • The match(), vlookup() and hlookup() functions now accept negative values of the "startFrom" and "occurrence" parameters. The positive "startFrom" parameter denotes the start search cell and the negative value denotes the end/stop cell. The negative "occurrence" parameter triggers bottom-up searches.
  • Examples of the match(), vlookup() and hlookup() functions using the SEARCH::AutoSort (used to perform fast searches for unsorted data) flag are now included in the sample.ods file.
  • Bug fixes:
  • Crashing when pasting after copying data with the "Edit > Advanced Copy Options > Copy & Transpose / Reverse" commands.
  • A bug concerning exporting files in the Excel XML format (preventing some Excel versions from opening them).
  • [The optional "extended-parameter" syntax was not available for the hLookUp() function.
  • The SEARCH::AutoSort flag was not available for the vLookUp() function despite the help file stating otherwise.
  • The "percentage" style behavior was inconsistent with the remaining styles. (It was reset when after entering a number in the default/general format.)
  • A minor bug concerning displaying frames.

New in GS-Calc 9.3 (Mar 1, 2012)

  • All the multi-core recalculation/update options can now be configured to use
  • both the global settings and individual workbook settings.

New in GS-Calc 9.2 (Nov 28, 2011)

  • GS-Calc 9.2 introduces multi-core calculation support. You can specify the number of threads/CPUs that should be used when updating formulas. Additionally, this new version enables you to specify several other options to "tweak" the multi-core recalculation depending on the construction of your workbooks.

New in GS-Calc 9.1 (Sep 26, 2011)

  • The style management tools/options have been significantly extended. You can now edit both custom/user-defined styles and the current palette styles; this enables you to change the entire workbook appearance with a few clicks. All properties of the default workbook style can be modified as well.
  • The Match() and vLookUp() functions can now be used with a new "SEARCH::AutoSort" flag. This flag is used along with the "SEARCH::NoPattern" flag and with either the "SEARCH::SortAscending" or the "SEARCH::SortDescending" flag. "AutoSort" used in Match() and vLookUp() for searching unsorted data causes automatic, internal (transparent to the user) sorting of ranges used in those two functions in a given workbook. Thanks to this the much faster binary search algoritm can be used instead of the linear one.
  • For worksheets/workbooks processing data that is not sorted by default this functionality may mean tens, hundreds (or more) of times faster updates for both the 1st and subsequent updates/recalculations.

New in GS-Calc 9.0 (Jun 2, 2011)

  • Workbooks are now updated/recalculated several (and more) times faster
  • New Match(), vLookUp() and hLookUp() function can optionally use more advanced
  • flags/options aside from the standard 1,0,-1. Depending of those options the functions
  • can perform linear and binary (tens/hundreds of times faster) searches, use specific
  • sort options, string comparisons funcions, pattern matching etc
  • GS-Calc 9.0 offers pivot tables as pivotData() array formulas. Using a new
  • "Insert > Pivot Table Formula" dialog box it's easy to enter even the most complex
  • pivotData() formulas
  • New formatting tools/windows
  • Bug fixes and other minor improvements and changes

New in GS-Calc 8.4.1 (Apr 1, 2011)

  • Additional sorting options and minor bug fixes

New in GS-Calc 8.4.0 (Oct 28, 2010)

  • Updating formulas in background processes (not blocking any other GS-Calc functions; for details please see the context help in the "Settings > Options" dialog).
  • Several new commands: the "Paste Text" command preserving formatting, a group of "Copy Values" commands, a group of "Insert Columns/Rows" command for inserting columns and rows with various options.
  • Additional diagnostic/warning messages after inserting/deleting columns/rows and pasting cells that result in invalid references in formulas.
  • Faster saving certain types of very large files.
  • More alignment options and cell text overflow options.
  • Improved cell borders rendering (they are now sorted by both thickness and color before rendering).
  • Additional minimal border thickness for better printing and saving to PDF.
  • Minor bug fixes.

New in GS-Calc 8.3.0 (Sep 8, 2010)

  • A new "Options > Settings > Cell Text Overflow" option that enables you to control whether and how text strings exceeding cell widths should be displayed in adjoining cells.
  • If a displayed text is only partially visible, GS-Calc now displays small markers in the bottom left and/or right cell corners instead of inserting the "..." sequence into the (middle of the) text.
  • An optional date picker and calendar displayed when editing dates. You can turn it on/off via the "Options > Settings > Use date picker" option. The "Editing and filling cells" help section contains a list of key shortcuts used with that controls.
  • Some minor changes regarding handling date formats and using the "Insert > Date" commands in non-US Windows.
  • Fixed problem with adding comments for some textual (returning labels) formulas.

New in GS-Calc 8.2.1 (Aug 27, 2010)

  • If the encoding data entered in the "Advanced PDF Save Options" is invalid (that is, if the encoding doesn't conform to the specification described in the help), GS-Calc may hang.
  • An interior of an empty cell preceeding another empty cell which has a width comparable to the minimum cell indents (which is a few pixels) might not be displayed. This concerns displaying, printing and saving to pdf.
  • Possible problems with opening old 6.x and 7.x files using the binary variant of the old native *.gsc/*.gsb format.

New in GS-Calc 8.2.0 (Jul 2, 2010)

  • Changes and new features include:
  • Saving PDF files - GS-Calc can save entire workbooks preserving the worksheet tree, single worksheets, single pages, page or cell ranges, single charts etc.
  • When saving PDF files GS-Calc uses PDF operators (and not images) to save cells and charts - thanks to this the files are very small and you can copy/paste the data using a PDF viewer. All formatting information and cell comments are preserved as well.
  • A bunch of minor changes and corrections concerning the user interface.
  • A number of bug fixes (e.g. various problems with the "Chart" dialog, a memory leak when displaying charts, some issues with 3D series/charts selections etc.)
  • More examples (additional sample 2D and 3D pie charts) of charts in the "sample.gsc" file.

New in GS-Calc 8.1.3 (Jul 2, 2010)

  • This version fixes one possible issue concerning using the same workbook in systems with different default languages - in some cases it may cause incorrect encoding of non-US (non-ASCII) characters in cells.
  • It also features a new "Font" dialog which enables you to specify the country/language pair and font shadow options.

New in GS-Calc 8.1 RC (Jul 2, 2010)

  • New features:
  • Worksheet windows can now be splitted into multiple (up to 100) panes. Panes enable you to view different portions of the same worksheet or different worksheets at the same time, in the same document window. Such views can be synchronized independently (the top-left column and/or row and/or the current selection move together).
  • Table toolbars displaying cell source values, some stats info, chosen formulas values for the currently selected ranges, cell comments and more.
  • Optional hiding/displaying row and column headings, scrollbars, headings highlighting.
  • New navigation and command shortcuts following now strictly Excel shortcuts. The navigation shortcuts/commands are listed in the menu attached to the "Go To" button.
  • Cell comments.
  • Optional scrolling back to the selection origin when selecting cells. This option can be specified in the "Settings > Options" dialog.

New in GS-Calc 8.0.0.4 (Nov 13, 2009)

  • New features:
  • A versatile and easy-to-use spreadsheet.
  • 12 mln rows x 4,096 columns.
  • ODF spreadsheet format as the default file format.
  • Around 300 built-in formulas including specialized numerical functions:
  • matrix decompositions; linear equation sets with improving iterations; least
  • squares (weighted, constrained), regression with orthogonal polynomials;
  • time series analysis; minimization; linear, integer and quadratic
  • programming.
  • Array formulas and 3D-formulas; UDF functions accepting and returning
  • arrays.
  • Workbooks containing any number of hierarchically organized worksheets.
  • 2D/XY and 3D charts capable of handling very large amount of data.
  • Strong password protection and encryption; password-protecting workbook
  • structures and individual cells.
  • Hidden formulas and cells excluded from printing. Printing watermarks.
  • Dual COM interfaces enabling you to use GS-Calc functionality in your own
  • applications.
  • Standard editing and formatting tools and options; optional Excel-,
  • OpenFormula- and GoogleDocs-compatible formula syntax, predefined numeric
  • styles and user-defined styles.
  • Clean installation (no registry entries are required); optional fully
  • portable setup.
  • Importing, exporting and editing text, dBase III-IV, Clipper, FoxPro 2.x
  • and Excel XML files.