GS-Calc 10 is available for downloading.
New features and changes:
[+] 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.