MAXA Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with no retirement established.
• Scope: Desktop Sheets with the Math module. Examples use English semicolon-separated formulas.
• Checked: October 14, 2026. Selected formulas ran through the official 25.04.2 engine library. Source and independent mathematics were checked. This is engine evidence, with no GUI-cell or import verification; 26.08.2 was source-checked only.

MAXA returns the largest converted value. It includes numeric strings and logical values, unlike the numeric-only MAX collection. Nonnumeric strings convert to zero, which can dominate a set of negative measurements. The tested maximum walker propagates an input error. Function-specific official reference.

=MAXA(value1[;value2;...])

At least one argument is required. Values and inline arrays can be combined; the comparison operates on their collected elements. Brackets indicate optional arguments and are not entered in the formula. Registration and implementation.

The engine and mathematical columns are separate. Results are rounded to twelve decimal places, or thirteen significant digits in scientific notation for very small or large values. This is a display choice, not an accuracy guarantee. Inline arrays in braces are formula values, not a workbook-import test. Their semicolons separate columns and vertical bars separate rows. Strings remain explicitly quoted, and booleans use TRUE()/FALSE().

MAXA(1;2;“9”) returns 9. The text “9” is parsed numerically rather than sorted alphabetically or ignored. MAXA(1;2;“abc”) returns 2 because the failed text conversion contributes zero. With negative values, a zero marker can instead become the maximum, so validate text before aggregation.

TRUE contributes 1 and FALSE contributes 0. For clean numeric values −2,−3,−4, the maximum remains −2; the function does not automatically start a valid numeric maximum at zero.

For finite numeric inputs, a positive rescaling preserves which observation is largest. A negative rescaling reverses order, so max(−x)=−min(x). This is an arithmetic identity, not a guarantee that two different function walkers treat errors alike.

The advanced comparison uses 1,2 and the numeric string “9”. MAXA returns 9, while MAX ignores the string and returns 2, producing a difference of 7. Choose deliberately whether imported numerical text belongs in the calculation.

The executed advanced check was:

=MAXA(1;2;"9")-MAX(1;2;"9")

Its engine result was 7.

MAXA(1;2;1/0) and the corresponding inline-array case return #DIV/0! in the tested engine. This propagation remains in force when the error comes first or when a negative number is present. MINA has a different error-conversion path; do not generalize its behavior to MAXA.

Calling MAXA without arguments gives #VALUE!. Quoted "" and a genuinely blank cell are different inputs; only the quoted-string cases are in this fixture. GUI, referenced blank ranges and other locales were not tested.

• Function-specific implementation
• Versioned function help
• Min Max Walk helper
• Numeric Conversion helper
• Comparison helper
• Min Max helper
• Defaults helper
• Array Parser helper

The math module and value-calculation helpers are byte-identical between the inspected 25.04.2 and 26.08.2 sources. That comparison supports the source discussion but does not establish later-version execution, GUI-cell behavior or other locales.

MAX, MIN, COUNT.