incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Evans <cppljev...@suddenlink.net>
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:

  Ato...OutputNet

yet cell B37, which contains formula:

  ='AfrPrefer' 'OutputNet'

displays:

  #REF!

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:

  OpenOffice.org 3.2.0
  OOO320m12(Build:9483)

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

-regards,
Larry



Mime
View raw message