Excel Client:GetFilterAlias
From CoPlanner 11
Jump to navigationJump to search
Function
GetFilterAlias(BlattName, FilterName, Alias)
ThisFunction provides a filter formula of the specified filter in the filter bar.
| Parameter | Description |
| BlattName | Name of the working sheet, on which the filter is located. |
| FilterName | Name of the filter, which should be selcted. |
| Alias | Alias, under which the filter should be inserted. |
Example
GetFilterAlias("Ad-Hoc Bericht";"Products";"Article")
returns the formula "Article:=Bianchi", because "Article" is the alias for products and "Bianchi" was selected in the filter
