Add AutoFilter to Format-Cell

RamblingCookieMonster / PSExcel

A simple Excel PowerShell module

http://ramblingcookiemonster.github.io/PSExcel-Intro/

MIT License

245 stars 67 forks source link

Add AutoFilter to Format-Cell #20

Open RamblingCookieMonster opened 9 years ago

RamblingCookieMonster commented 9 years ago

Per Filip Hasa's suggestion - Thanks Filip!

RamblingCookieMonster commented 9 years ago

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 commented 9 years ago

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

hasafi commented 9 years ago

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

RamblingCookieMonster commented 9 years ago

sure, just committed the change!

hasafi commented 9 years ago

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 https://github.com/RamblingCookieMonster/PSExcel/issues/20#issuecomment-146699666 .

RamblingCookieMonster commented 9 years ago

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 commented 9 years ago

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