DBCS in LibreOffice Calc: Availability and Alternatives
DBCS is not a documented native Calc function in the checked release. Use JIS for the documented full-width text conversion.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
DBCS is not a supported English built-in or bundled-add-in function name in the checked LibreOffice 26.8.1.1 registry. Use JIS for the documented full-width text conversion. 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.
Convert half-width text with JIS
Calc documents JIS for converting applicable half-width characters to full-width characters. For this simple example:
=JIS("ABC123")
Expected result: ＡＢＣ１２３. These are different Unicode characters from the original ASCII letters and digits, not merely a wider font setting.
In a worksheet, put ABC123 in A2 and use =JIS(A2) in B2. Retain the original text during a cleanup so you can compare and reverse a decision if the receiving system requires half-width codes. ASC is the documented companion for the opposite width-conversion direction.
Do not confuse width conversion with byte-counting
JIS changes applicable text characters. LENB, LEFTB, RIGHTB and MIDB count or slice text using Calc’s DBCS rules. They do not make a nonexistent DBCS function valid, and their notion of a byte is not a universal UTF-8 file-length measurement.
Width-normalizing a lookup key can be useful when imported records mix full-width and half-width forms. Apply the same deliberate normalization to both sides of a comparison, and confirm that the conversion does not change meaningful identifiers. Visually similar characters can still compare differently.
Version and locale caution
Character conversion is governed by the product’s documented implementation. Test representative kana, punctuation and other production text rather than assuming an ASCII demonstration proves every Unicode transformation. Do not infer that a formula named DBCS in a different spreadsheet product can be typed unchanged in Calc.
The original DBCS examples were removed from current-use instructions. The supported replacement is JIS for the stated conversion task, not a claim that DBCS has a known retirement date.