Il 27/12/2011 16:03, Csanyi Pal ha scritto:
Csanyi Pal<csanyi...@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?
I suggest you, only for debug, to output in some way, somewhere and in
the unused space in the sheet, the parameters' value of the " wrong data
type" formulas and to analize them: may be you are able to discover the
trouble yourself.
Make us to know what you'll discover n this way.
Carlo
--
For unsubscribe instructions e-mail to: users+h...@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
