ABSDB in LibreOffice Calc: Availability and Alternatives
ABSDB is not a documented native Calc function in the checked release. Use ABS for the absolute value of a number.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
ABSDB is not a supported English built-in or bundled-add-in function name in the checked LibreOffice 26.8.1.1 registry. Use ABS for the absolute value of a number. The page is retained at its existing URL to explain the compatibility problem and give a usable next step.
Availability and version history
- First introduced: Not established. The former legacy/version claim was unsupported and has been withdrawn.
- Current status: Unsupported under this name in the verified release inventory. This is not a claim that the function was once supported and then retired.
- Last supported version / retirement: Unknown; no documented historical endpoint was found.
- Platform and edition scope: English function names in desktop Calc, including its bundled analysis/date/pricing add-ins. A third-party extension may register additional names but is not evidence for native support.
- Native testing: A representative imported-XLSX call returned #NAME? in LibreOfficeDev 26.8.0.0.alpha0 (build 2c87e51eeaa2b413ff4ae097b2705eea1995d8e5). The replacement examples below have independent expected results; selected principal examples were also cross-checked in that development build. This does not establish behavior in every stable version.
- Evidence checked: 2026-10-14.
The complete source check covered the built-in function registry, English names, analysis add-ins, date add-ins and pricing add-ins. Absence from one abbreviated web index alone was not used as proof.
Use ABS on the number you actually have
Enter -42 in A2. Use =ABS(A2) in B2. The expected result is 42. For a literal value, =ABS(-42) has the same result. Positive values are unchanged and zero stays zero.
The origin of A2 does not change ABS syntax: it can be a manually entered value, a formula result or a numeric value brought into Calc from a database. There is no need to add a database-related suffix to the function name.
If the number must first be selected from a table
DGET retrieves one value from a spreadsheet database matching criteria. That is a separate operation from taking an absolute value. First verify that the retrieval returns the intended numeric record; then apply ABS to that result cell. Do not assume a database file reference in a formula will create a database connection or field mapping.
For example, if D2 already contains -125.5 after a verified retrieval, =ABS(D2) returns 125.5. If a match fails or produces an error, ABS does not repair the lookup or turn that error into a valid number.
Practical checks
- Confirm that the input is numeric; imported text can look like a number.
- Preserve the original signed value in another column when the sign carries business meaning.
- Use ABS only when magnitude is the intended result. A negative balance or difference may need to stay negative.
The former ABSDB examples have been replaced because they relied on an unsupported name and an unsubstantiated legacy-database claim.