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 | |
| parent | 993dfe1e318ee6405d539d6217ae78bba11e12c6 (diff) | |
Add zeros to final filtering
Diffstat (limited to 'src')
| -rw-r--r-- | src/Controllers/ToolBase.cs | 2 | ||||
| -rw-r--r-- | src/Properties/AssemblyInfo.cs | 4 |
2 files changed, 3 insertions, 3 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(); } } diff --git a/src/Properties/AssemblyInfo.cs b/src/Properties/AssemblyInfo.cs index 12b6799..494a624 100644 --- a/src/Properties/AssemblyInfo.cs +++ b/src/Properties/AssemblyInfo.cs @@ -32,5 +32,5 @@ using System.Runtime.InteropServices; // You can specify all the values or you can default the Build and Revision Numbers // by using the '*' as shown below: // [assembly: AssemblyVersion("1.0.*")] -[assembly: AssemblyVersion("1.2.3.0")] -[assembly: AssemblyFileVersion("1.2.3.0")] +[assembly: AssemblyVersion("1.2.3.1")] +[assembly: AssemblyFileVersion("1.2.3.1")] |