diff options
| author | Serghei Cebotari <51533848+schebotar@users.noreply.github.com> | 2022-01-28 18:49:51 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-01-28 18:49:51 +0300 |
| commit | 62cfb27784ce601acf8c45ed8470769d454921db (patch) | |
| tree | 04f8e23c0edc19fa8d793cc90bed3c8b20748f76 /src | |
| parent | ec1d38f2d4926ddd89dc8f17d29617ea4ddefa82 (diff) | |
| parent | 0fac439d951ab1162ad3e6779819814172d3b65d (diff) | |
Merge pull request #13 from schebotar/dev
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(); } } |