SUMX2PY2 Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; this is a verified release, not a final supported version.
• Scope: Desktop Calc, English function names and semicolon-separated formulas.
• Checked: October 14, 2026. Eight ordinary reference formulas were recalculated from generated ODF in 4.1.16 on Linux x86-64, Build 9816. Source and independent arithmetic were checked.

SUMX2PY2 returns Σ(x²+y²) for corresponding positions in two equally shaped arrays. It adds the individual squares; it does not square x+y and does not calculate squared differences. Release implementation.

SUMX2PY2(ArrayX;ArrayY)

• ArrayX, ArrayY: exactly two corresponding arrays or ranges. Their row and column dimensions must match.
• Use aligned numeric observations. The native examples use explicit typed numeric cell ranges.
• Do not infer general scalar broadcasting or automatic reshaping from equal-sized lists.

Enter the following values at the stated addresses. Column I is unused; keep each range’s starting row intact.

For the two-by-two examples, enter L2=1, M2=2, L3=3, M3=4 and O2=2, P2=4, O3=6, P3=8. These are numeric cells, not text representations of arrays.

The native column contains saved 4.1.16 results; independent references use high-precision arithmetic and the stated source rules. Values are shown to twelve decimal places where needed. The range examples use the numeric setup above.

Put 1,2,3 in F2:F4 and 2,4,6 in G2:G4. Their squared totals are 14 and 56, so =SUMX2PY2(F2:F4;G2:G4) gives 70. Swapping the ranges leaves the same result.

Using F2:F4 twice gives 28, twice its squared magnitude. This is not the square of the total 1+2+3, which would be 36, and it is not the paired squared-difference sum, which would be zero for identical ranges.

For complete numeric ranges, the operation equals the sum of the two separate squared magnitudes. For the two-by-two arrays [[1,2],[3,4]] and [[2,4],[6,8]], it gives 30+120=150.

The identity SUMX2PY2(X;Y)=SUMXMY2(X;Y)+2*SUMPRODUCT(X;Y) follows by expanding each squared difference. For the three-value example, SUMPRODUCT is 28, so 14+2*28=70. This independent algebra check does not replace the source’s requirements for matching shapes and numeric handling.

In the pinned implementation, the shared loop ignores a paired position when either element is a string. Blank, Boolean, error-cell and shape-mismatch behavior was not executed in this ordinary numeric fixture, so those inputs should be validated separately.

For finite real numeric data, the mathematical sum is nonnegative, but very large values can overflow. The listed small integer cases establish their exact results without proving behavior for all magnitudes. Avoid changing range boundaries independently when extending a worksheet.

SUMX2MY2, SUMXMY2, sumproduct.

• Function-specific release implementation
• Shared paired-array implementation

The generated ODF produced the informational load warning “Not all attributes could be read.” The sheet was hard-recalculated and saved separately. All eight ordinary function identities, inputs and results were reconciled; a stale SUM cache changed from 999999 to 3 and an uncached SUM returned 7. This establishes the stated examples, not every workbook style or invalid input. Other explanatory identities are independent calculations. The authoring-tool XLSX was not executed in OpenOffice, and its preview values are not the native results reported here.