GS-Calc 11 introduced the following changes concerning the behavior of a few formulas, to ensure better ODF file compatibility. If you're opening a file created by version 10.x or 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 included.
  • GS-Calc 11 and newer:
    Text representations of numbers in references and arrays are not included.
    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 included.
  • GS-Calc 11 and newer:
    Text representations of numbers in references and arrays are not included.
    You can also use the AVERAGEA(), MINA(), MAXA() and COUNTA() functions, respectively, to include text representations of numbers.
• INDEX(range, row, column)
  • GS-Calc 10.x and older:
    Specifying 0 as either the row or the column argument causes the function to return the #NUM! error.
  • GS-Calc 11 and newer:
    Specifying 0 as either the row or the column argument has the same meaning as leaving the parameter blank: it returns either the full column or the full row of the range, respectively.
• MATCH(), VLOOKUP(), HLOOKUP()
  • GS-Calc 10.x and older:
    Specifying 1 or -1 as the search mode argument requires the searched range to be in ascending order.
  • GS-Calc 11 and newer:
    Specifying -1 as the search mode argument requires the searched range to be in descending order.
• NoPattern and StringSort flags in MATCH(), VLOOKUP(), HLOOKUP(), PIVOTDATA()
  • GS-Calc 11.x:
    These 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 applied (that is, punctuation marks are not ignored).