# GS-Calc 9.0 has been released

**URL:** <https://community.citadel5.com/t/gs-calc-9-0-has-been-released/37>\
**Category:** GS-Calc Updates\
**Created:** [May 29, 2011, 10:05pm UTC](https://community.citadel5.com/t/gs-calc-9-0-has-been-released/37 "2011-05-29T22:05:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![citadel\_5](https://community.citadel5.com/letter_avatar_proxy/v4/letter/c/b2d939/32.png) [@citadel\_5](https://community.citadel5.com/u/citadel_5)\
**Post date:** [May 29, 2011, 10:05pm UTC](https://community.citadel5.com/t/gs-calc-9-0-has-been-released/37/1 "2011-05-29T22:05:21Z")

</div>

New features and changes:

[+] 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.