diff options
| author | Sergey Chebotar <s.chebotar@gmail.com> | 2023-01-13 08:37:22 +0300 |
|---|---|---|
| committer | Sergey Chebotar <s.chebotar@gmail.com> | 2023-01-13 08:37:22 +0300 |
| commit | 3cfe453b38b63604aba93aff3c704b157c556821 (patch) | |
| tree | 684709dd17a4496ddffc375db4a2ff153f7051b6 /src/Controllers/ToolBase.cs | |
| parent | 993dfe1e318ee6405d539d6217ae78bba11e12c6 (diff) | |
Add zeros to final filtering
Diffstat (limited to 'src/Controllers/ToolBase.cs')
| -rw-r--r-- | src/Controllers/ToolBase.cs | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/Controllers/ToolBase.cs b/src/Controllers/ToolBase.cs index aa766b9..1d92871 100644 --- a/src/Controllers/ToolBase.cs +++ b/src/Controllers/ToolBase.cs @@ -182,7 +182,7 @@ namespace RhSolutions.Controllers AutoFilter filter = TargetFile.Sheet.AutoFilter; int startColumn = filter.Range.Column; - filter.Range.AutoFilter(TargetFile.AmountCell.Column - startColumn + 1, "<>"); + filter.Range.AutoFilter(TargetFile.AmountCell.Column - startColumn + 1, "<>0", XlAutoFilterOperator.xlAnd, "<>"); TargetFile.Sheet.Range["A1"].Activate(); } } |