MUNIT Function in ONLYOFFICE Spreadsheet Editor: Build Identity Matrices

=MUNIT(dimension)

No argument is optional, and there is no implied default. For MUNIT, the input is a dimension rather than a source matrix.

Vendor-confirmed: the documented input is a positive integer and the function is an array formula. The official MUNIT page does not give an explicit native error code for zero, negative values, fractional dimensions or text. Such cases are out of the documented domain, but exact error text requires native testing.

Start with a blank worksheet. Type each entry as a numeric cell (not as quoted text), then place results only in the indicated unused output cells. The sample is deliberately small enough for manual checking.

Select a blank output area before entering each formula. Never overwrite these input ranges with array-formula results. Use one clean worksheet per guide, or reset your worksheet to this exact baseline before moving between scenarios.

How to enter a matrix result correctly

For multi-cell results, first highlight an appropriately sized blank output rectangle; then enter the formula in the formula bar and use Ctrl+Shift+Enter as explained in the ONLYOFFICE array-formula instructions. The editor adds array braces in the formula bar automatically. If you only press Enter, the vendor’s array guide warns that some functions return the first value rather than filling the requested result range. Always select the exact output shape and compare all cells, not just the upper-left cell. The array guide also says you cannot change only part of an entered array: select the entire array to delete or re-enter it.

Each displayed matrix is written as rows inside [[...],[...]]. For example [[2,-1],[-3,2]] means output row one 2, -1 and output row two -3, 2; it is not a formula literal to paste into the spreadsheet. Fill the indicated output rectangle using the actual formula, not by typing the expected array. These predictions were calculated with exact rational SymPy mathematics and do not represent measurements from ONLYOFFICE.

Out-of-domain inputs: Try =MUNIT(0), =MUNIT(-2) and =MUNIT(2.5) in a disposable test workbook to record the actual native results; the cited source does not specify an error code for these calls. Make sure the output range you preselect matches the requested positive integer dimension.

Multiplying any conformable matrix by an identity matrix of the matching dimension should leave the source matrix unchanged: A×I₂=A and I₂×A=A. Try =MMULT(A2:B3,MUNIT(2)) in a 2×2 result range and separately =MMULT(MUNIT(2),A2:B3). Both have the independent expected matrix [[2,1],[3,2]]. These nested array calls require native verification in the particular ONLYOFFICE edition. MUNIT provides a quick control matrix when checking MINVERSE: MMULT(A,MINVERSE(A)) should resemble MUNIT(2) within numerical tolerance.

• MMULT — related matrix operation, with its own documented signature and error conditions.
• MINVERSE — related matrix operation, with its own documented signature and error conditions.
• MDETERM — related matrix operation, with its own documented signature and error conditions.
• Function entry and argument-picker instructions.
• Array formula entry and array editing.
• Formula language and regional settings.

This guide is based on the current, unversioned English ONLYOFFICE help pages on 2026-10-13 (UTC) and independent numerical reasoning. The sample values below are expected values, not results observed in a running ONLYOFFICE Spreadsheet Editor. No screenshot, workbook execution, web edition test, Desktop edition test, or historic version support test was performed. Use the official function catalogue.

Edition and compatibility: ONLYOFFICE’s documentation describes the current Docs Spreadsheet Editor; its Desktop changelog and Docs changelog are distinct records. None of the cited function pages establishes a first-supported Desktop or web version for this function; do not infer universal historical compatibility or claim that an XLSX exported to another spreadsheet program evaluates identically. Where a function returns an array, the current ONLYOFFICE array-entry guide explicitly describes selecting the complete output range, entering the formula and pressing Ctrl+Shift+Enter. Do not manually type the surrounding { }. In some editions, dynamic-array behaviour may differ and must be tested.

Formula language and separators: The examples use English names, A1-style references, a decimal point, and commas between arguments. The official function-entry guide shows these conventions. The Advanced Settings guide documents configurable formula language, region and numeric separators; it does not provide a verified translation or formula argument separator for every locale. Change regional settings as appropriate and verify the resulting formula entry in the target edition rather than blindly substituting commas with semicolons.