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.

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 back to the same cell in the results.

Online help page

The new "hyperlink" special style enabling you to use a single click to:

• jump to any locations in the current 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.

Online help page

Format > Images style enable you to enter in a cell any sequence image names and then display the result in one line in a cell.

The predefined image names (available in every workbook) 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:

Online help page

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 shortcuts: Alt+F7 to open the bottom (pivot table) pane, Alt+F11/F12 to use bookmarks.