Collabora Office DROP: Remove edge rows or columns with source-specific limits
Remove leading or trailing array edges in the new Linux desktop build and understand the inspected equal-size and oversized DROP behavior.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =DROP(A1:C3;1;-1) removes the first row and last column of a 3 × 3 source, giving a 2 × 2 array. Positive counts remove from the beginning; negative counts remove from the end.
Important build-specific limit: in the inspected source, removing an entire axis or more does not produce an empty array. The evaluator changes an axis only when ABS(count) is strictly smaller than its size. Equal or larger counts leave that axis unchanged. Check counts before using DROP to suppress all records.
Syntax and dimensions
=DROP(Array; Rows [; Columns])
The 26.04 help describes Rows as the number to remove from the top, or bottom when negative. Optional Columns applies the same rule from left or right. Omitted Columns retains all columns. Use integer counts; the source converts numerical counts to integers rather than offering fractional-row selection.
Zero Rows leaves the row dimension unchanged in this source, so =DROP(A1:C3;0;1) can remove a column only. Although the evaluator accepts an array-only call and missing positions, keep the documented Rows position explicit for portable, readable formulas.
Worked example: crop a numeric block
Enter A1:C3 as follows:
| Row | A | B | C |
|---|---|---|---|
| 1 | 1 | 2 | 3 |
| 2 | 4 | 5 | 6 |
| 3 | 7 | 8 | 9 |
- Start with
=DROP(A1:C3;1). The independently derived rows are[4,5,6]and[7,8,9]. - Change to
=DROP(A1:C3;-1). The expected rows are[1,2,3]and[4,5,6]. - Use
=DROP(A1:C3;1;-1)to remove both edges. The complete expected output is:
| Output 1 | Output 2 |
|---|---|
| 4 | 5 |
| 7 | 8 |
These results follow ordinary coordinate slicing, independently of the vendor evaluator. DROP does not sort values, inspect headers or remove rows according to their content. It returns the selected subarray; it does not delete worksheet rows.
Advanced use: separate a heading and a check column
Imagine A1:C3 is a small imported report with a heading row and a final check column. The combined formula above creates the remaining rectangular data region. For a wider real report, derive the counts from the layout specification, not from whether the heading happens to contain text.
To keep every row while excluding the first column, =DROP(A1:C3;0;1) independently yields [2,3], [5,6], [8,9]. The zero is intentional and is not an instruction to return an empty result.
For the ordinary safe case, a source with R rows and C columns yields (R−ABS(Rows)) × (C−ABS(Columns)), provided each nonzero removal is strictly smaller than its corresponding dimension. An omitted or zero removal keeps that dimension. Do not apply this size formula to a count that reaches the source size in this build.
Boundary behavior that needs an explicit guard
For the source above:
| Formula | Inspected-source expected result |
|---|---|
=DROP(A1:C3;3) |
Original 3 × 3 array |
=DROP(A1:C3;4) |
Original 3 × 3 array |
=DROP(A1:C3;-3) |
Original 3 × 3 array |
The same strict comparison applies independently to columns. This behavior follows ScTakeOrDrop(false), not a claim about another spreadsheet product. It has not been executed in Collabora here. It is particularly risky in pipelines where “remove all” is supposed to mean “no records”: validate that each intended removal lies strictly inside the source dimension and handle the empty-data case separately.
Genuine blank source cells are copied as empty matrix cells. Their displayed appearance and spill placement are unverified. Invalid array arguments or allocation failures can follow error paths, but this guide does not invent an empty-array error for an overlarge count when the inspected branch keeps the original axis.
Product scope, compatibility and evidence
This guide covers the new Collabora Office desktop for Linux, using the Flathub source tag coda-26.04.4.3-1 and commit 81339d176148d0d5c81ff05d82540f58f8aaa117. The official desktop release notes and Linux package manifest identify that product/build. The package manifest is a dated observation from October 18, 2026, rather than an installed-binary check.
The 26.04 function help and exact evaluator source were inspected on October 18, 2026. Expected examples were independently calculated; no Collabora application was run. Output grids describe evaluator results, not a verified spill or keyboard-entry workflow. Classic, Online/CODE, other operating systems and file-format round trips require their own checks.
The help identifies this function as outside OpenDocument 1.3 and uses the extension name COM.MICROSOFT.DROP. That does not establish lossless export to every spreadsheet format. The first Collabora release introducing it is not established by these sources. It is documented here as available, with no cited retirement or deprecation notice; an undocumented introduction date is not a deprecation claim.
Related functions
- CHOOSEROWS: list specific row positions instead of cropping
- CHOOSECOLS: select specific columns
- EXPAND: pad an array to larger dimensions