GS-Calc 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()
  • GS-Calc 10.x and older:
    Text representations of numbers in references and arrays are inlcuded.
  • GS-Calc 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()
  • GS-Calc 10.x and older:
    Text representations of numbers in references and arrays are inlcuded.
  • GS-Calc 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)
  • GS-Calc 10.x and older:
    Specifying 0 either as the row or as the column argument causes returning the #NUM! error.
  • GS-Calc 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()
  • GS-Calc 10.x and older:
    Specifying 1 and -1 as the search mode argument requires the searched range to be in the ascending order.
  • GS-Calc 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()
  • GS-Calc 11.x:
    Those flags are no longer required and are no longer documented.
  • GS-Calc 14 and newer:
    By default no pattern matching is used and string sorting is used (that is, punctation marks are not ignored).