Array function not working

Topics: Developer Forum
Apr 18, 2013 at 3:30 AM
Edited Apr 18, 2013 at 3:36 AM
Array functions in the existing sheet modified to normal formulae after saving the excel sheet. i am using excel2007 reader and writer. i have seen some posts about this issue but i failed to find out a solution. Can anybody help me?
These are the formulae i used in my existing sheet.
 {=AVERAGE(IF(D4:D15>0;D4:D15))}
 {=MIN(IF(I4:I15>0;I4:I15))}
Apr 18, 2013 at 10:53 AM
Can anybody answer this?
Apr 18, 2013 at 4:57 PM
Array formulas are not supported in the current version (1.7.8) but Mark has been working hard to implement: patience... or help him to ensure that it is completed more quickly.
Apr 19, 2013 at 2:52 AM
Ok. Thank you for your reply LWol