https://bugs.documentfoundation.org/show_bug.cgi?id=142953
--- Comment #9 from ady <[email protected]> --- Using attachment 173044, still repro in 7.6.alpha built 2023-04-27. In attachment 173044, the named range upper-left cell is A3, but the OFFSET formula doesn't seem to take cell A3 as base. Instead, it just takes "one row up" as base (when the height and width arguments are not explicitly provided): for the formula in cell C7, the OFFSET() function is taking the base at cell A6 ("one row up"). In contrast, when the height and width arguments are provided, the base for OFFSET seems to be indeed cell A3 (upper-left cell of the range). -- You are receiving this mail because: You are the assignee for the bug.
