From 846547d6d905e0dbee73cd9c62760ea43bb88134 Mon Sep 17 00:00:00 2001 From: Sergey Chebotar Date: Sun, 9 Jan 2022 15:47:54 +0300 Subject: Add SaveAs Dialog after export --- src/PriceListTools/CombineTool.cs | 4 +++- src/PriceListTools/ExportTool.cs | 4 +++- src/PriceListTools/MergeTool.cs | 4 +++- src/PriceListTools/PriceListSheet.cs | 2 +- 4 files changed, 10 insertions(+), 4 deletions(-) (limited to 'src/PriceListTools') diff --git a/src/PriceListTools/CombineTool.cs b/src/PriceListTools/CombineTool.cs index 303146c..cf02059 100644 --- a/src/PriceListTools/CombineTool.cs +++ b/src/PriceListTools/CombineTool.cs @@ -63,7 +63,9 @@ namespace RehauSku.PriceListTools filter.Range.AutoFilter(offer.amountColumnNumber - firstFilterColumn + 1 + exportedLists, "<>"); offer.Sheet.Range["A1"].Activate(); - offer.Sheet.Application.StatusBar = $"Экспортировано {exportedValues} строк из {sourcePriceLists.Count} файлов"; + AddIn.Excel.StatusBar = $"Экспортировано {exportedValues} строк из {sourcePriceLists.Count} файлов"; + + Forms.Dialog.SaveWorkbookAs(); } public void Dispose() diff --git a/src/PriceListTools/ExportTool.cs b/src/PriceListTools/ExportTool.cs index be76dff..a93097d 100644 --- a/src/PriceListTools/ExportTool.cs +++ b/src/PriceListTools/ExportTool.cs @@ -113,7 +113,9 @@ namespace RehauSku.PriceListTools filter.Range.AutoFilter(offer.amountColumnNumber - firstFilterColumn + 1, "<>"); offer.Sheet.Range["A1"].Activate(); - offer.Sheet.Application.StatusBar = $"Экспортировано {exportedValues} строк из {SkuAmount.Count}"; + AddIn.Excel.StatusBar = $"Экспортировано {exportedValues} строк из {SkuAmount.Count}"; + + Forms.Dialog.SaveWorkbookAs(); } public void Dispose() diff --git a/src/PriceListTools/MergeTool.cs b/src/PriceListTools/MergeTool.cs index 4f5522c..493f8a8 100644 --- a/src/PriceListTools/MergeTool.cs +++ b/src/PriceListTools/MergeTool.cs @@ -52,7 +52,9 @@ namespace RehauSku.PriceListTools filter.Range.AutoFilter(offer.amountColumnNumber - firstFilterColumn + 1, "<>"); offer.Sheet.Range["A1"].Activate(); - offer.Sheet.Application.StatusBar = $"Экспортировано {exportedValues} строк из {sourcePriceLists.Count} файлов"; + AddIn.Excel.StatusBar = $"Экспортировано {exportedValues} строк из {sourcePriceLists.Count} файлов"; + + Forms.Dialog.SaveWorkbookAs(); } public void Dispose() diff --git a/src/PriceListTools/PriceListSheet.cs b/src/PriceListTools/PriceListSheet.cs index e10913b..8a34c2f 100644 --- a/src/PriceListTools/PriceListSheet.cs +++ b/src/PriceListTools/PriceListSheet.cs @@ -31,7 +31,7 @@ namespace RehauSku.PriceListTools if (amountCell == null || skuCell == null) { - Sheet.Application.StatusBar = $"Лист {Name} не распознан"; + AddIn.Excel.StatusBar = $"Лист {Name} не распознан"; return false; } -- cgit v1.2.3