private void SpreadsheetControlOnActiveSheetChanged(object sender, ActiveSheetChangedEventArgs e)
{
var workbook = spreadsheetControl.Document;
var oldTabColor = workbook.Worksheets[e.NewActiveSheetName].ActiveView.TabColor;
workbook.Worksheets[e.NewActiveSheetName].ActiveView.TabColor = SelectedTabColor;
workbook.Worksheets[e.OldActiveSheetName].ActiveView.TabColor = oldTabColor;
}
//시트가 바뀔때마다 새로고침
private void Workbook_ActiveSheetChanged(object sender, ActiveSheetChangedEventArgs e)
{
/*
* //피벗테이블이 있는 시트번호
* Worksheet worksheet_2 = workbook.Worksheets[1];
* Worksheet worksheet_3 = workbook.Worksheets[0]; //보여줄것
* //피벗테이블이 있는 시트번호
* Worksheet worksheet_PivotTable_01 = workbook.Worksheets["Pivot_01"];
* Worksheet worksheet_PivotTable_02 = workbook.Worksheets["Pivot_02"];
* Worksheet worksheet_PivotTable_03 = workbook.Worksheets["Pivot_03"];
* Worksheet worksheet_PivotTable_04 = workbook.Worksheets["Pivot_04"];
*
* //보여줄 현황 시트(차트있는 시트)
* Worksheet worksheet_Chart_01 = workbook.Worksheets["제품입고현황"];
* Worksheet worksheet_Chart_02 = workbook.Worksheets["기간별생산실적현황"];
* Worksheet worksheet_Chart_03 = workbook.Worksheets["제품미출고현황"];
* Worksheet worksheet_Chart_04 = workbook.Worksheets["제품재고현황"];
*
* // 피벗시트에서 피벗테이블 범위 알아오기 -> 차트에 범위 갱신
* Range PivotTable_range_01 = worksheet_PivotTable_01.GetDataRange();
* Range PivotTable_range_02 = worksheet_PivotTable_02.GetDataRange();
* Range PivotTable_range_03 = worksheet_PivotTable_03.GetDataRange();
* Range PivotTable_range_04 = worksheet_PivotTable_04.GetDataRange();
*
* //범위 재정의 저장
* ////피벗테이블쪽 차트
* worksheet_PivotTable_01.Charts[0].SelectData(PivotTable_range_01);
* worksheet_PivotTable_02.Charts[0].SelectData(PivotTable_range_02);
* worksheet_PivotTable_03.Charts[0].SelectData(PivotTable_range_03);
* worksheet_PivotTable_04.Charts[0].SelectData(PivotTable_range_04);
* ////실제 사용자용 차트
* worksheet_Chart_01.Charts[0].SelectData(PivotTable_range_01);
* worksheet_Chart_02.Charts[0].SelectData(PivotTable_range_02);
* worksheet_Chart_03.Charts[0].SelectData(PivotTable_range_03);
* worksheet_Chart_04.Charts[0].SelectData(PivotTable_range_04);
*
*/
workbook.Worksheets.ActiveWorksheet = workbook.Worksheets[0];
workbook.PivotCaches.RefreshAll();
}
//Sheet激活时触发，用于响应Sheet切换事件
public void spreadsheetMain_ActiveSheetChanged(object sender, ActiveSheetChangedEventArgs e)
{
RefreshCurrentSheet();
if (app.statu == SysStatu.Designer)
{
return;
}
try
{
currentSheet = app.getRSheetByName(e.NewActiveSheetName);
if (currentSheet.getInitFlag() == false)
{
executer.executeCmd(currentSheet, SysEvent.Sheet_Init);
}
executer.executeCmd(currentSheet, SysEvent.Sheet_Change);
app.setSheetVisiable(e.NewActiveSheetName);
}
catch (Exception)
{
spreadsheetMain.Document.Worksheets[e.OldActiveSheetName].Cells[0, 0].Select();
spreadsheetMain.Document.Worksheets.ActiveWorksheet = spreadsheetMain.Document.Worksheets[e.OldActiveSheetName];
}
}
private void spreadsheetTemplate_ActiveSheetChanged(object sender, ActiveSheetChangedEventArgs e)
{
var form = this.listBoxTemplatedForm.SelectedItem as form;
UpdateTemplate(form);
}
private void spreadsheetMain_ActiveSheetChanged(object sender, ActiveSheetChangedEventArgs e)
{
control.spreadsheetMain_ActiveSheetChanged(sender, e);
}
private void spreadsheetControl_ActiveSheetChanged(object sender, ActiveSheetChangedEventArgs e)
{
//XtraMessageBox.Show(e.NewActiveSheetName);
}
private void spsVessel_ActiveSheetChanged(object sender, ActiveSheetChangedEventArgs e)
{
//Worksheet worksheet = spsVessel.ActiveWorksheet;
//callSheetActive(worksheet);
}
