Excel Client:GetFilter

From CoPlanner 10
Revision as of 13:17, 15 April 2015 by Admin (talk | contribs) (Created page with "==Function== <span {{CoPFormel}}>GetFilter(BlattName, FilterName)</span> Diese [[Excel_Client_2.0:Excel-Client_Functio...")

(diff) ← Older revision | Approved revision (diff) | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

Function

GetFilter(BlattName, FilterName)

Diese Function provides a filter formula of the specified filter in the filter bar.

Parameter Description
BlattName Name of the working sheet, Arbeitsblatts, on whicht the filter stands.
FilterName Name of the filter, which is selcted

Example

GetFilter("Ad-Hoc report";"Company") returns the formula "Company:=Bike GmbH, because "Bike GmbH" was selected in the filter

Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=Excel_Client:GetFilter&oldid=15076"