GS-Calc 18.1 has been released

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.

  • 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.
  • 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.