[Bug] xlsx: shared-formula children are not expanded; #OCLI_NOTEVAL! on empty cached values, and dependents lose their cached values on save

Summary

Shared-formula children (<f t="shared" si="N"/> cells that inherit the master's formula) are not expanded:

1. get and view … annotated show an empty formula for them.
2. When such a cell's cached value is an empty string, it is reported as #OCLI_NOTEVAL! (evaluated=false).
3. On save, a cell that depends on it is recomputed from that empty cached value and its own cached value is dropped, even though the edit touched an unrelated cell.

Point 3 is a data change on a file the user only meant to edit elsewhere: a reader of cached values (Excel before recalculation, openpyxl data_only=True, any downstream tool) now sees an empty cell where the file held a number.

Environment

officecli 1.0.149 (Homebrew, dotnet 10.0.400), macOS 26.4.1 arm64.

Minimal reproduction

A stale-cache workbook, the shape Excel add-ins and templates commonly save with fullCalcOnLoad set: B1:B3 is a shared formula whose children carry empty cached strings, and D1 depends on B2 and holds a cached number.

import re, shutil, zipfile
from openpyxl import Workbook

wb = Workbook(); ws = wb.active; ws.title = "Sheet1"
for i in range(1, 4): ws.cell(i, 1, i); ws.cell(i, 2, "x")
ws["D1"] = 4; ws["E1"] = 1
wb.save("min_shared.xlsx")

def fn(x):
    x = re.sub(r'<c r="B1"[^>]*>.*?</c>', '<c r="B1" t="str"><f t="shared" ref="B1:B3" si="0">IF(A1&gt;1,A1*2,"")</f><v></v></c>', x, count=1, flags=re.S)
    x = re.sub(r'<c r="B2"[^>]*>.*?</c>', '<c r="B2" t="str"><f t="shared" si="0"/><v></v></c>', x, count=1, flags=re.S)
    x = re.sub(r'<c r="B3"[^>]*>.*?</c>', '<c r="B3" t="str"><f t="shared" si="0"/><v></v></c>', x, count=1, flags=re.S)
    x = re.sub(r'<c r="D1"[^>]*>.*?</c>', '<c r="D1"><f>IF(ISNUMBER(B2),B2,"")</f><v>4</v></c>', x, count=1, flags=re.S)
    return x

src = zipfile.ZipFile("min_shared.xlsx"); out = zipfile.ZipFile("tmp.xlsx", "w", zipfile.ZIP_DEFLATED)
for info in src.infolist():
    data = src.read(info.filename)
    if info.filename == "xl/worksheets/sheet1.xml": data = fn(data.decode()).encode()
    out.writestr(info, data)
out.close(); src.close(); shutil.move("tmp.xlsx", "min_shared.xlsx")

export OFFICECLI_NO_AUTO_RESIDENT=1
officecli get min_shared.xlsx /Sheet1/B2
# /Sheet1/B2 (cell) "#OCLI_NOTEVAL!" type=String formula= evaluated=false
officecli get min_shared.xlsx /Sheet1/D1
# /Sheet1/D1 (cell) "4" type=Number formula=IF(ISNUMBER(B2),B2,"") cachedValue=4 computedValue= evaluated=true
officecli view min_shared.xlsx annotated
#   D1: [4] ← =IF(ISNUMBER(B2),B2,"")
#   B2: [#OCLI_NOTEVAL!] ← =

cp min_shared.xlsx edited.xlsx
officecli set edited.xlsx /Sheet1/E1 --prop value=9      # an unrelated cell

xl/worksheets/sheet1.xml, cell D1:

With a numeric cached value on B2 the child is shown with cachedValue=4 and D1 keeps its value, so the engine is using the child's cached value in place of the formula it cannot see.

Where it was found

A vendor .xlsm with 899 shared-formula children across three sheets: 336 of them (the ones with empty cached strings) came back as #OCLI_NOTEVAL!, and after a one-cell edit several dependent cells had their cached numbers dropped or replaced (0 where the file held an empty string, and vice versa). Excel recomputes on open because the file sets fullCalcOnLoad, so the user never sees it, but anything reading the cached values does.

Expected

Shared formulas are expanded from the master's ref and formula (adjusting relative references per child), so the children evaluate like any other formula cell; and a cell whose inputs cannot be evaluated keeps its cached value rather than having it removed.