Add AutoFilter to Format-Cell

[RamblingCookieMonster]

Per Filip Hasa's suggestion - Thanks Filip!

[RamblingCookieMonster]

Have the code written for this, but it only works in one direction (setting to true).

Will check on whether I'm doing it wrong, or whether a bug should be submitted for the EPPlus library.

[hasafi]

How about this: Spreadsheet1.ActiveSheet.AutoFilterMode = $false ?
source: https://msdn.microsoft.com/en-us/library/aa199191(v=office.10).aspx

[hasafi]

But only one direction is fine ;) Can I test it?

[RamblingCookieMonster]

sure, just committed the change!

[hasafi]

thank you

I am missing something ;( it is not working for me

On Fri, Oct 9, 2015 at 12:03 AM Warren F. notifications@github.com wrote:

sure, just committed the change!

—
Reply to this email directly or view it on GitHub
#20 (comment)
.

[RamblingCookieMonster]

Hi!

A few steps that might help:

• Re-download PSExcel from GitHub (PowerShellGallery is now behind)
• Import-Module \Path\To\PSExcel -Force # or open a new session and import without Force
• Format-Cell -AutoFilter $True # Using bool, to allow setting back to false at some point

If you open Format-Cell.ps1, you should see that parameter in the param() block:

Thanks!

[hasafi]

done. it is working like charm
have you seen this?
https://msdn.microsoft.com/en-us/library/aa199191(v=office.10).aspx