diff options
| author | Sergey Chebotar <s.chebotar@gmail.com> | 2022-01-28 18:46:31 +0300 |
|---|---|---|
| committer | Sergey Chebotar <s.chebotar@gmail.com> | 2022-01-28 18:46:31 +0300 |
| commit | 0fac439d951ab1162ad3e6779819814172d3b65d (patch) | |
| tree | 04f8e23c0edc19fa8d793cc90bed3c8b20748f76 /src | |
| parent | 2ad016bb4c332ecad6d12d824a84f15616ecea38 (diff) | |
Filtering quickfix
Diffstat (limited to 'src')
| -rw-r--r-- | src/PriceListTools/PriceListTool.cs | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/PriceListTools/PriceListTool.cs b/src/PriceListTools/PriceListTool.cs index 9d898e7..f6231a5 100644 --- a/src/PriceListTools/PriceListTool.cs +++ b/src/PriceListTools/PriceListTool.cs @@ -187,8 +187,9 @@ namespace RehauSku.PriceListTools protected private void FilterByAmount() { AutoFilter filter = TargetFile.Sheet.AutoFilter; + int startColumn = filter.Range.Column; - filter.Range.AutoFilter(TargetFile.amountCell.Column, "<>"); + filter.Range.AutoFilter(TargetFile.amountCell.Column - startColumn + 1, "<>"); TargetFile.Sheet.Range["A1"].Activate(); } } |