Adding FILTER Function

[GarethParry1]

trafficstars

HI, i am using the Epplus library and i am trying to add the FILTER function to a sheet.

if i use

wsdt_Performance.Cells("D8").CreateArrayFormula("=_xlfn.FILTER('Graph Data'!A2:G15,'Graph Data'!A2:A15 = D2,"" "")")

in excel i get

{=FILTER('Graph Data'!A2:G15,'Graph Data'!A2:A15 = D2," ")}

and only by entering the cell do the curly brackets disappear and the function works

if i remove the _xlfn section i get an error when the sheet opens

am i doing something wrong?

thanks

Gareth

[JanKallman]

Hi, EPPlus currently don't support the FILTER function. The FILTER function requires dynamic array formula support, currently not implemented in EPPlus. We will start to look at this in the comming versions.

[GarethParry1]

Hi,

Ok no worries. Thanks for coming back to me

I added it by adding a VBA macro module until its implemented

thanks

Gareth Parry Head of Systems & Business Improvement Breezemount Mobile: +44 (0) 7800 528327 Email: @.*** Web: www.breezemount.comhttp://www.breezemount.com/

From: Jan Källman @.> Sent: 22 November 2021 08:02 To: EPPlusSoftware/EPPlus @.> Cc: Gareth Parry @.>; Author @.> Subject: Re: [EPPlusSoftware/EPPlus] Adding FILTER Function (Issue #534)

ALERT: This message originated outside of breezemount network. BE CAUTIOUS before clicking any link or attachment.

Hi, EPPlus currently don't support the FILTER function. The FILTER function requires dynamic array formula support, currently not implemented in EPPlus. We will start to look at this in the comming versions.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/EPPlusSoftware/EPPlus/issues/534#issuecomment-975221987, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWSMEDLZUOXSDP5N5Y37KIDUNH2JBANCNFSM5ILZS6IQ. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

This email is sent on behalf of Breezemount Group Ltd and its associated companies and is strictly confidential and intended solely for the addressee(s). If you are not the intended recipient of this email you must: (i) not disclose, copy or distribute its contents to any other person nor use its contents in any way or you may be acting unlawfully; (ii) contact @.*** immediately quoting the name of the sender and the addressee then delete it from your system. Breezemount Group Ltd have taken reasonable precautions to ensure that there are no viruses contained in this email, but does not accept any responsibility once this email has been transmitted. You should scan attachments (if any) for viruses. Breezemount Group Ltd. Registered in Northern Ireland no. NI635494. Correspondence Office: The Abbey, Market Square, Daventry, NORTHANTS, NN11 4XG.

[linnjason678]

HI, i am using the Epplus library and i am trying to add the FILTER function to a sheet.

if i use

wsdt_Performance.Cells("D8").CreateArrayFormula("=_xlfn.FILTER('Graph Data'!A2:G15,'Graph Data'!A2:A15 = D2,"" "")")

in excel i get

{=FILTER('Graph Data'!A2:G15,'Graph Data'!A2:A15 = D2," ")}

and only by entering the cell do the curly brackets disappear and the function works

if i remove the _xlfn section i get an error when the sheet opens

am i doing something wrong?

thanks

Gareth

⁵

[swmal]

The FILTER function is implemented in EPPlus 7 which supports dynamic arrayformulas.