GS-Calc 16.5 has been released

Information about published new versions and updates

GS-Calc 16.5 has been released

Postby citadel5 » Tue Jun 20, 2017 1:49 pm

Changes in this version:

  • Added new "IFs" functions:

    • percentileIfs(), percentileAIfs()
    • averageIfs(), averageAIfs()
    • geoMeanIfs(), geoMeanAIfs()
    • harMeanIfs(), harMeanAIfs()
    • medianIfs(), medianAIfs()
    • maxIfs(), maxAIfs()
    • minIfs(), minAIfs()
    • varIfs(), varAIfs()
    • varpIfs(), varpAIfs()
    • stddevIfs(), stddevAIfs()
    • stddevpIfs(), stddevpAIfs()
    • modeIfs(), modeAIfs()

    The above functions offer much better performance than their non-IFs variants combined with nested array plain IF's functions. The details concerning their usage, returned error codes and examples are available in the "Formula" dialog box.

  • Users can create a simple zip archive of text files (tables) which will be opened as GS-Calc workbooks with usual worksheet folders. The import options are specified as *.xml zip streams so no interaction is required during importing/opening.

  • The "Settings > Options > General > Hide cell markers" option now also applies to printing (and specifies whether formula markers should be visible on the printout).

  • The (missing) "<>" operator has been added to all IFs functions.

  • Minor bug fixes.
User avatar
Posts: 120
Joined: Tue Apr 20, 2010 11:58 pm

Return to GS-Calc Updates

Who is online

Users browsing this forum: No registered users and 1 guest