incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Evans <>
Subject [calc]Why #REF error when correct name used in column labels
Date Thu, 09 Aug 2012 19:01:19 GMT
In the attached, the column labels on Row18 include:


yet cell B37, which contains formula:

  ='AfrPrefer' 'OutputNet'



The help shows:

  #REF invalid reference

The cell below, B38 contains formula:

  ='AfrPrefer' 'OutputGross'

and shows no error.

I've made sure the column labels include all of Ato...OutputNet; hence,
that can't be the problem.

I've spent hours trying to figure what to do; hence, any help
would be greatly appreciated.

OpenOffice version: 3.2.0

Operating system:

  Linux evansl-desktop 2.6.32-41-generic #90-Ubuntu SMP Tue May 22
11:29:51 UTC 2012 x86_64 GNU/Linux


View raw message