12-05-2019
03:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
12-05-2019
03:32 PM
i could not find a way to set the default filters but you could create your own filter. The following i logic code will filter all rows that have the letter "e" in the 3e cell. (that is ofcource not usefull but maby a start point for your own filter)
Dim doc As DrawingDocument = ThisApplication.ActiveDocument
Dim sheet As Sheet = doc.ActiveSheet
For Each row As PartsListRow In sheet.PartsLists.Item(1).PartsListRows
Dim cell As PartsListCell = row.Item(3)
If (cell.Value.Contains("e")) Then
row.Visible = False
Else
row.Visible = True
End If
Next
Jelte de Jong
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Blog: hjalte.nl - github.com