incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Evans <>
Subject Re: [calc]Why #REF error when correct name used in column labels
Date Thu, 09 Aug 2012 22:27:59 GMT
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.



To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message