MINVERSE in Collabora Office: Invert Matrices and Verify Linear Solutions

• Introduced: original Collabora release and launch date are not established by the sources reviewed.
• Availability: documented in Collabora Office 26.04 help, scoped to the desktop-help release.
• Platform scope: support in every online or mobile deployment is not inferred from desktop documentation.
• Checked: October 14, 2026. Function-specific documentation and independently derived controls; no native Collabora test was performed.

=MINVERSE(Array)

The Collabora reference requires a square input array and describes an array output. An inverse A⁻¹ satisfies A×A⁻¹=I and A⁻¹×A=I, where I is an identity matrix. A singular matrix has no such inverse.

The output is not formed by taking the reciprocal of each cell. In general, every inverse entry depends on the matrix as a whole. Use the complete numeric controls below before applying the operation to a larger system.

These examples follow the desktop array-entry workflow documented for Collabora Office 26.04. Select the full output rectangle before entering a multi-cell formula. In the Function Wizard, select Array; for direct entry use the client-appropriate array-entry shortcut shown in the help, Ctrl+Shift+Enter or Command+Shift+Enter. Do not type the displayed outer braces manually.

Input cells and output cells must be separate. The help describes a linked array result whose cells are edited as a group; selecting too small an output rectangle does not redefine the mathematics of the source arrays. This workflow is not a claim that every online or mobile client has the same controls.

Enter these numbers in A2:B3, with no headings inside the input:

Select D2:E3 and enter as an array formula:

=MINVERSE(A2:B3)

The complete expected output is:

The determinant is 10. The two-by-two inverse rule divides the matrix with rows (3,−1) and (−2,4) by 10, giving the displayed entries. This provides an independent derivation of all four values.

With the output retained in D2:E3, select a separate two-by-two output range for each formula:

=MMULT(A2:B3;D2:E3)
=MMULT(D2:E3;A2:B3)

Both expected mathematical results are the identity matrix with rows (1,0) and (0,1). For example, the first top-left entry is 4×0.3+1×(−0.2)=1; its top-right entry is 4×(−0.1)+1×0.4=0.

In native numerical work, small residual differences may occur. The identities here are independently calculated using exact rational values; they are not screenshots or an exact floating-point tolerance guarantee.

Suppose 4x+y=9 and 2x+3y=13. Enter the right-hand side 9,13 in G2:G3. Select I2:I3 and use array entry:

=MMULT(D2:E3;G2:G3)

Expected solution: x=1.4 and y=3.4. Substitution checks both equations: 4×1.4+3.4=9, and 2×1.4+3×3.4=13.

Keep the equation order aligned with the rows of A2:B3 and G2:G3. Swapping just the right-hand-side entries changes the system. A valid matrix calculation can still solve the wrong equations if those rows are misaligned.

Double every original matrix entry, producing rows (8,2) and (4,6). Its expected inverse has rows (0.15,−0.05) and (−0.1,0.2), half the original inverse.

Keeping the right-hand side at (9,13) now gives solution (0.7,1.7). Doubling the right-hand side to (18,26) restores the original solution (1.4,3.4). This distinguishes scaling the coefficient matrix alone from scaling entire equations.

Rows (4,1) and (8,2) are dependent, so this matrix cannot be inverted. Its MDETERM result is mathematically zero. The short Collabora MINVERSE section does not establish the exact native error code or numerical singularity threshold, so neither is assigned here.

Near-dependent matrices may amplify input changes. A determinant alone is not a complete conditioning test, and explicitly forming an inverse is not universally the most stable method for solving every system. These small examples teach the function’s operation rather than certify a large numerical workflow.

Blank, text, error-valued and nonsquare inputs, maximum dimensions and every platform’s array-entry behavior remain outside native verification. MUNIT provides an explicit identity matrix; MMULT explains the row-by-column product used for the checks.

• Collabora Office 26.04: MINVERSE and array entry.
• Editorial testing standards.

Complete matrices and outputs were independently calculated using arithmetic and exact rational checks where appropriate. They are documentation-backed expectations, not native Collabora captures or a certification of every type, error and client boundary.