You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Larry Evans <cp...@suddenlink.net> on 2012/08/09 21:01:19 UTC
[calc]Why #REF error when correct name used in column labels
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
Re: [calc]Why #REF error when correct name used in column labels
Posted by Larry Evans <cp...@suddenlink.net>.
On 08/09/12 17:20, Larry Evans wrote:
> On 08/09/12 14:55, Regina Henschel wrote:
>> Hi Larry,
>>
>> the associated data range goes only to column E not to column F.
>>
>> Open Insert > Names > Labels and klick on the entry containing
>> "[TabelPref...". Look below into the field "data range". In addition
>> you see a blew border around the range on the sheet.
>>
>> Kind regards
>> Regina
>>
> Thanks Regina.
>
> I did check this to make sure the range reached column F.
> I just opened the spreadsheet again and checked again.
> My OO shows a data range:
>
> $Sheet1.$B$19:$F$1048576
>
> So the range does go to column F, but what is still puzzling is why
> it goes to row 1048576, because I did limit the range to row 35.
> I also remember having to reset the row limit to row35 after,
> for some mysterious reason OO resets the limit to 1048576.
>
> Now, despite the range going to the bottom of the spreadsheet.
> B37 still shows the #REF! error.
>
> It sounds like sometimes the range is set correctly, then for some
> unknown reason, it gets reset. I've no idea why, but it does sound
> like at least a usability bug to me. By that I means that if it's so
> hard to get it right or so easy to get it wrong, then it's not very usable.
>
>
Ah!. It was the row range that was being limited to column E.
Corrected that and now it works.
Thanks.
-Larry
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: [calc]Why #REF error when correct name used in column labels
Posted by Larry Evans <cp...@suddenlink.net>.
On 08/09/12 14:55, Regina Henschel wrote:
> Hi Larry,
>
> the associated data range goes only to column E not to column F.
>
> Open Insert > Names > Labels and klick on the entry containing
> "[TabelPref...". Look below into the field "data range". In addition
> you see a blew border around the range on the sheet.
>
> Kind regards
> Regina
>
Thanks Regina.
I did check this to make sure the range reached column F.
I just opened the spreadsheet again and checked again.
My OO shows a data range:
$Sheet1.$B$19:$F$1048576
So the range does go to column F, but what is still puzzling is why
it goes to row 1048576, because I did limit the range to row 35.
I also remember having to reset the row limit to row35 after,
for some mysterious reason OO resets the limit to 1048576.
Now, despite the range going to the bottom of the spreadsheet.
B37 still shows the #REF! error.
It sounds like sometimes the range is set correctly, then for some
unknown reason, it gets reset. I've no idea why, but it does sound
like at least a usability bug to me. By that I means that if it's so
hard to get it right or so easy to get it wrong, then it's not very usable.
-regards,
Larry
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: [calc]Why #REF error when correct name used in column labels
Posted by Regina Henschel <rb...@t-online.de>.
Hi Larry,
the associated data range goes only to column E not to column F.
Open Insert > Names > Labels and klick on the entry containing
"[TabelPref...". Look below into the field "data range". In addition you
see a blew border around the range on the sheet.
Kind regards
Regina
Larry Evans schrieb:
> 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
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org