New features in GS-Calc 18.2:
-
New “Insert” commands have been added for a group of lookup, filter and sorting functions. They enable creating the corresponding formulas, setting all options, applying styles etc. with 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. -
-
The source range 16-element list is a global list created and stored in the settings file so it can be easily re-used. Subsequent source ranges are added in a circular manner by clicking one of the following:
- The “Copy as Location” menu command
-
The “Enter” toolbar button
As source data ranges in all functions can refers to closed workbooks, you can control via “Settings > Options” option how such external references should be used to achieve best performance, e.g. whether to keep the corresponding workbooks open in the background after they are referenced and automatically opened for the first time and till the main workbook is closed or to close them after each reference which can be helpful if there is no enough RAM to keep them all open.
Similar “Insert” dialog boxes are available for other functions, for example:
- VLOOKUP():
- HLOOKUP():
- MATCH():
- UNIQUE():
- SORT():
Note: This should also greatly help in using the extended versions of the VLOOKUP()/HLOOKUP()/MATCH() functions which can perform binary searches with background sorting. For very large data sets binary searches can reduce calculation times even tens to hundreds of times in comparison with their “industry standard” versions.
- Creating hyperlinks has been improved. You can now simply use one of the “Edit > Copy as Hyperlink” commands:
To paste/insert such a copied and already formatted hyperlink in the same or in other workbooks you just need to use the plain Paste command. The Ctrl+H shortcut is automatically re-assigned to the most recent “hyperlink” command variant.