[libreoffice-users] Calc: Column labels and array formulas

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

val    new val    result    formula in previous column    expected
result    num    new num    result    formula in previous column
expected result
a                   new val    {=IF('new val'="",'val','new val')}
a                 12                          12    {=IF('new
num'="",'num','new num')}    12
a          d       new val    {=IF('new val'="",'val','new val')}
d                23          24             23    {=IF('new
num'="",'num','new num')}    24

David lynch

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