KPRODUCT and G_PRODUCT in 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.

KPRODUCT multiplies collected factors through the full-value product helper, starting from 1. Its name is separate from PRODUCT, whose helper has a special zero result for an empty collection. Supplied text and logical values are still converted; the initial 1 does not make invalid text disappear. Function-specific official reference.

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

Supply at least one value or array. A no-argument formula is rejected before an empty-product identity could apply. 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().

KPRODUCT(2;4;8) gives 64, and KPRODUCT(-2;-3;-4) gives −24. Three negative factors produce a negative result. With a zero factor, the product is zero.

KPRODUCT(“abc”) also gives zero in the tested engine. That string is a supplied element converted to zero; it is not an empty range. KPRODUCT(“9”) gives 9, and a TRUE value contributes 1. These distinctions matter when a factor column contains imported text or status markers.

The mathematical product over an empty set is conventionally 1, which explains the helper’s initial value. However, KPRODUCT() is not a valid demonstration of that identity because the registration requires at least one argument. A worksheet blank-range experiment would need its own cell-based evidence.

For real supplied factors 1.05,0.98,1.10, KPRODUCT and PRODUCT both give 1.1319 in the executed comparison. The initialization distinction does not alter this ordinary nonempty case. Multiplying an opening amount of 1000 by the factor gives 1131.9 before any separately chosen rounding policy.

The executed advanced check was:

=KPRODUCT(1.05;0.98;1.1)-PRODUCT(1.05;0.98;1.1)

Its engine result was 0.

The tested direct and array 1/0 inputs propagate #DIV/0!. Nonnumeric text instead becomes zero; numeric text is parsed. Do not infer a “skip all text” policy from the handbook’s short empty-numeric description.

G_PRODUCT shares this callback as a compatibility spelling. That source comment does not establish a currently supported native English name in another spreadsheet program. This guide establishes Calligra’s selected engine expressions and the source contract only.

• Function-specific implementation
• Versioned function help
• Product Walk helper
• Sum Product helper
• Conversion 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.

=G_PRODUCT(value1[;value2;...]) is another active Calligra spelling for KPRODUCT. Keep the underscore in the name. Both accept one or more values or arrays and share the same argument handling and calculation in 26.08.2 source. G_PRODUCT is present in 2.4.0 source; its first introduction is not established. The source’s compatibility comment does not prove a current native English function name in another product.

All eight reference inputs and sixteen boundary inputs shown for KPRODUCT were also executed as G_PRODUCT in the 25.04.2 engine, with identical typed results and error flags. The additional expression =G_PRODUCT(2;3;4)-KPRODUCT(2;3;4) returned 0. Thus G_PRODUCT(2;4;8) gives 64, and G_PRODUCT({1;2|3;4}) gives 24 by multiplying four factors, rather than performing matrix multiplication. No blank-cell range or import behavior is inferred from these expressions.

PRODUCT, SUM, POWER.