Re: [libreoffice-users]

david_lynch,

In reply to your E-mail from 27-3-2013, 17:43 with subject "[libreoffice-users]".

d> The formatting in my previous message was mangled. I have reformatted using
d> | for column separator and _ for null character.


d> I can't seem to get Calc to recognise column labels in array formulas. In
d> addition, it seems to behave differently depending on whether there is
d> number or text in the cells:

d> With text

d> val|new val|result_|formula in previous column___|expected
d> _a|______|new val|{=IF('new val'="",'val','new val')}|_a
d> _a|__d___|new val|{=IF('new val'="",'val','new val')}|_d

d> With numbers

d> num|new num|result|formula in previous column______|expected
d> _12_|_______|_12_|{=IF('new num'="",'num','new num')}|_12
d> _23_|___24__|_23_|{=IF('new num'="",'num','new num')}|_24

d> David lynch


The problem is the "," it should be ";"
Like this.
=IF('new num'="";'num';'new num')


Greetings,

Piet Jan Koeleman.


-- 
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