CURRENT Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; no final supported release is established.
• Scope: English desktop Calc, semicolon-separated formulas and local workbook references.
• Checked: October 14, 2026. Eight examples were recalculated in 4.1.16 on Linux x86-64, Build9816. Generated-ODF identities, saved results and controls were checked; no manual-entry or different-release test is claimed.

CURRENT exposes the intermediate value at its position in the current formula calculation. The inspected interpreter duplicates the top value on its evaluation stack. That makes expression order and parentheses important. It is not a reference to the previous saved value of the cell or to the active selection. Release implementation.

CURRENT()

CURRENT has no arguments. Use it only where the containing expression has already produced the intended intermediate value. The function’s ordinary use is demonstrated inside the complete expressions below, not as a stand-alone input value.

The eight formulas below are self-contained. They use only constants and SUM; no worksheet input cells, formatting changes or external data are required.

All eight formulas were recalculated. Quotation marks identify text results; unquoted #N/A identifies an error. Logical tests in the explicitly number-formatted output cells are shown as 1/0. Reference expectations follow the inspected callback, workbook structure and ordinary arithmetic.

In =2*3+CURRENT(), multiplication first produces 6. CURRENT duplicates that intermediate 6, so the final addition produces 12. An explicit =2*(2*3) would describe the same small calculation more directly; CURRENT is most useful for understanding an existing formula whose evaluation path must be retained.

The subtraction and division cases make the reuse visible: =10-CURRENT() gives 0, while =5/CURRENT() gives 1. CURRENT is not independently generating 10 or 5; it is reading the available intermediate operand.

Compare =2+3*CURRENT() with =(2+3)*CURRENT(). In the first, CURRENT sees the most recent operand 3 before multiplication, giving 2+3*3 = 11. In the second, parentheses make 2+3 complete first; CURRENT sees 5 and the result is 5*5 = 25.

The successful =SUM(1;2)+CURRENT() shows that a completed function call can also provide the intermediate value: SUM returns 3, which CURRENT duplicates before addition, producing 6.

These cases follow the actual interpreter callback, which removes one stack token and pushes it twice. That source contract explains the results without pretending that CURRENT is a named variable or a general way to cache arbitrary subexpressions. Moving it within a formula can change which intermediate token is available.

Do not simplify a CURRENT expression solely by reading the formula from left to right; apply the actual operator precedence and parentheses. When a reusable calculation is clearer in a helper cell, an explicit reference usually makes its dependency easier to audit.

A stand-alone CURRENT call with no preceding value was not executed here. The source has an empty-stack error branch, but this guide does not assign an observed result to that untested path. The examples also make no claim about volatile recalculation, previous-cell state, styling side effects or array behavior.

The saved ODF uses ORG.OPENOFFICE.CURRENT; the inspected English registry maps that operation to CURRENT. This is storage-name evidence and successful generated-ODF execution, not an additional manual-entry test.

sum, product, IF.

• Function-specific implementation
• Release function description and argument metadata
• English function identity
• ODF storage identity

The generated ODF was opened in the native GUI, hard-recalculated and saved separately. The informational “Not all attributes could be read” load warning was retained. A deliberately stale SUM cache refreshed to 3, and an uncached SUM returned 7. The exact local inputs, sheet order, formula identities and saved values were reconciled. The authoring-tool XLSX and its previews were not used as native calculation evidence. Only the listed cases and release are covered.