GSCalc 11 introduced the following changes concerning the behavior of a few formulas to ensure better ODF files
compatibility. If you're opening a file created by the version 10.x and older, you may need to check
the Settings > Legacy Compatibility option.

SUM()
 GSCalc 10.x and older:
Text representations of numbers in references and arrays are inlcuded.
 GSCalc 11 and newer:
Text representations of numbers in references and arrays are not inlcuded.
You can also use the SUMA() function to include text representations of numbers.

AVERAGE(), MIN(), MAX(), COUNT()
 GSCalc 10.x and older:
Text representations of numbers in references and arrays are inlcuded.
 GSCalc 11 and newer:
Text representations of numbers in references and arrays are not inlcuded.
You can also use respectively the AVERAGEA(), MINA(), MAXA(), COUNTA() function
to include text representations of numbers.

INDEX(range, row, column)
 GSCalc 10.x and older:
Specifying 0 either as the row or as the column argument
causes returning the #NUM! error.
 GSCalc 11 and newer:
Specifying 0 either as the row or as the column argument
have the same meaning as specifying blank parameters: it causes
returning respectively either the full column or the full row of the range.

MATCH(), VLOOKUP(), HLOOKUP()
 GSCalc 10.x and older:
Specifying 1 and 1 as the search mode argument requires the searched
range to be in the ascending order.
 GSCalc 11 and newer:
Specifying 1 as the search mode argument requires the searched
range to be in the descending order.

NoPattern and StringSort flags in MATCH(), VLOOKUP(), HLOOKUP(), PIVOTDATA()
 GSCalc 11.x:
Those flags are no longer required and are no longer documented.
 GSCalc 14 and newer:
By default no pattern matching is used and string sorting is used (that is, punctation marks
are not ignored).