https://bz.apache.org/ooo/show_bug.cgi?id=118236
--- Comment #12 from [email protected] --- (In reply to Czesław Wolański from comment #11) > (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 Gnumeric: 16, but the "ISFORMULA()" column evaluates to "#REF!" for all cells. Google Sheets: 16 Apple's "Numbers": doesn't support the TYPE() function. > > 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. Thank you. I had no idea that feature existed. > >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? I thought "=aRef" was referring to column O which has "aRef" in O1, but apparently it doesn't, the defined name takes precedence. So what do we do now? Leave it as is, or make it return 16? -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
