Does axlsx support array functions? (cntl-shift-enter)

[gregory...@gmail.com]

I've been trying to add a row to a worksheet using the following:

total_xls.add_row ["='Results'!A#{r}",
"=IF(COUNTIF('Missing'!D:D,\"*\"&A#{r}&\"*\"),\"NO GO\",\"GO\")",
"{=IF(ISNA(MATCH(1,(\"true\"='Miscompares'!C:C)*(A#{r}='Miscompares'!A:A),0)),\"GO\",\"NO GO\")}",
"=IF(COUNTIF(B#{r}:E#{r},\"*\"&\"NO GO\"&\"*\"),\"NO GO\",\"GO\")"], :style => r_entry

The 2nd entry is an array function (entered via CNTL-SHIFT-ENTER in Excel). I have tried it with and without the surrounding curley braces. Is this a supported feature?

Greg

[Randy Morgan]

Some work has been added to master recently that may help here. 

I'm not expecting to be in a position to do a release for at least another 6 weeks - but you might give it a go.

Best

Randy

--
You received this message because you are subscribed to the Google Groups "axlsx" group.
To unsubscribe from this group and stop receiving emails from it, send an email to axlsx+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.