[libreoffice-users] Re: LibreOffice 3.4.4 - Error: wrong data type.

Csanyi Pal <csanyipal@gmail.com> writes:

Sorry I was unclear again!

> I have in the range of O23:O27 on one sheet formulas:
cell O23: =DARABTELI(K5:K24;ÉS(K5:K24>=5;K5:K24<=7))
cell O24: =DARABTELI(K5:K24;ÉS(K5:K24>=8;K5:K24<=15))
cell O25: =DARABTELI(K5:K24;ÉS(K5:K24>=16;K5:K24<=25))
cell O26: =DARABTELI(K5:K24;ÉS(K5:K24>=26;K5:K24<=34))
cell O27: =DARABTELI(K5:K24;">=35")

> The cell K5 has the formula:
> =HA(CELLA("contents";'1.'.T$28)<>0;CELLA("contents";'1.'.T$28);".")

The cells bellow of K5 (K6:K24) has same formulas except addresses is
different, eg.:

instead of '1.'.T$28 there is '2.'.T$28 and so on, like:
=HA(CELLA("contents";'2.'.T$28)<>0;CELLA("contents";'2.'.T$28);".")

> In the cells: O23, O24, O27 everything is well.
>
> But in cells O25 and O26 I get ### (or #VALUE! if I set the column
> wider) instead of some result and in the status line there is an
> error: 'Error: wrong data type.' when those cells are active (one by
> one of course). 

These formulas are the same, uses the same range so I don't understand
what could be the problem here? 

-- 
Regards, Pal


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted