Add support for Excel array formulae
Created originally on Bitbucket by baryonyx (Kris Seraphine)
Array formulae are displayed in Excel wrapped in braces:
#!python
{=MAX(C2:C6-B2:B6)}
Within worksheet.xml they appear as:
#!xml
<c r="E1">
<f ref="E1" t="array">MAX(C2:C6-B2:B6)</f>
<v>
</v>
</c>
There is currently no way to add an array formula to a cell. The request is to provide a mechanism to do so.
Thanks for all your efforts.