From 3cfe453b38b63604aba93aff3c704b157c556821 Mon Sep 17 00:00:00 2001 From: Sergey Chebotar Date: Fri, 13 Jan 2023 08:37:22 +0300 Subject: Add zeros to final filtering --- src/Controllers/ToolBase.cs | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/Controllers') 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(); } } -- cgit v1.2.3