https://bz.apache.org/ooo/show_bug.cgi?id=118236
--- Comment #11 from Czesław Wolański <[email protected]> --- (In reply to damjan from comment #10) > > Does it matter that the TYPE function returns #VALUE!- as shown > > in the attached .ods file? > > Yes it might. What do Excel, LO, Gnumeric do? Don't know/use Gnumeric. OpenOffice: #VALUE! LibreOffice: #VALUE! Excel 2010: 16 Excel Online: 64 > And how does that .ods file work? What kind of range is "aRef" > when it's not > listed under Data -> Select Range. "aRef" was created via Insert -> Names -> Define. >Why do the values in each column differ > despite having the same formula? The values do not differ in _each_ column. Do you mean the columns with the #VALUE! error or all columns with values that differ? > Why does it say aRef is A2:A3 when cell O1 > has "aRef" in it? The first row acts as a header and only provides information about what was used in the formulae. I should have formatted that row as text first. Apologies for any confusion caused. You'll shall get the same result whether the formulae use a range, a name (Insert -> Names -> Define) or a database range (Data -> Define Range). -- You are receiving this mail because: You are on the CC list for the issue. You are the assignee for the issue.
