//�˴�Ϊ��̬������ݷ��� private void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet) { int[] TableYearsAry = TC.GetTableYears(this.GetType().Name); int startrow = 2; int itemlength = 9; string sqlwhere = " ProjectID='" + Tcommon.ProjectID + "'"; IList<PS_Table_AreaWH> ptalist = Services.BaseService.GetList<PS_Table_AreaWH>("SelectPS_Table_AreaWHByConn", sqlwhere); //�����趨���� obj_sheet.RowCount = startrow + (ptalist.Count + 1) * itemlength; string sqlwheretemp = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "'"; IList phlisttemp= Services.BaseService.GetList("SelectPs_HistoryBYconnstr", sqlwheretemp); DataTable dttemp = DataConverter.ToDataTable(phlisttemp, typeof(Ps_History)); Ps_History AllRk = new Ps_History(); Ps_History CZrk = new Ps_History(); DataRow RowAllrk = dttemp.NewRow(); ; DataRow RowCZrk = dttemp.NewRow(); RowAllrk = DataConverter.ObjectToRow(AllRk,RowAllrk); RowCZrk = DataConverter.ObjectToRow(CZrk, RowCZrk); for (int i = 0; i < ptalist.Count; i++) { AddItems(obj_sheet, ptalist[i].Title, startrow + i * itemlength); string sqlwhere2 = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "' and Title='" + ptalist[i].Title + "'"; IList<Ps_History> phlist = Services.BaseService.GetList<Ps_History>("SelectPs_HistoryBYconnstr", sqlwhere2); if (phlist.Count > 0) { string sqlwhere3 = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "' and ParentID='" + phlist[0].ID + "'"; IList phlist3 = Services.BaseService.GetList("SelectPs_HistoryBYconnstr", sqlwhere3); DataTable dt = DataConverter.ToDataTable(phlist3, typeof(Ps_History)); DataRow[] rows1 = dt.Select("Title like 'һ��%'"); DataRow[] rows2 = dt.Select("Title like '����%'"); DataRow[] rows3 = dt.Select("Title like '����%'"); DataRow[] rows4 = dt.Select("Title like '�˿�%'"); DataRow[] rows7=null; DataRow[] rows8 = null; if (rows4.Length!=0) { string sqlwhere4 = " ForecastID='4' and Col4='" + Tcommon.ProjectID + "' and ParentID='" + rows4[0]["ID"] + "'"; IList phlist4 = Services.BaseService.GetList("SelectPs_HistoryBYconnstr", sqlwhere4); DataTable dt2 = DataConverter.ToDataTable(phlist4, typeof(Ps_History)); rows7 = dt2.Select("Title like '�����˿�%'"); rows8 = dt2.Select("Title like '����˿�%'"); } DataRow[] rows5 = dt.Select("Title like '�������%'"); DataRow[] rows6 = dt.Select("Title like '���������%'"); //����������ֵ����Ԫ��=һ��+����+���� TC.Sheet_WriteFormula_RowSum(obj_sheet, startrow + i * itemlength + 1, 2, 3, 1, startrow + i * itemlength, 2, TableYearsAry.Length); //�˾�GDP����Ԫ��=����������ֵ����Ԫ��/�˿ڣ� TC.Sheet_WriteFormula_OneRow_AnoterRow_nopercent(obj_sheet, startrow + i * itemlength + 4, 2, startrow + i * itemlength, startrow + i * itemlength + 5, TableYearsAry.Length); for (int j = 0; j < TableYearsAry.Length; j++) { int m = 0; //һ�� string yearstr="y" + TableYearsAry[j].ToString(); m++; if (rows1.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows1[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "��һ������", "��ѯ ��������ʵ�������Ƿ��и���һ������", ""); } //���� m++; if (rows2.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows2[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "��������", "��ѯ ��������ʵ�������Ƿ��и�����������", ""); } //���� m++; if (rows3.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows3[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "����������", "��ѯ ��������ʵ�������Ƿ��и�����������", ""); } //�˿� m++; if (rows4.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows4[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "���˿�����", "��ѯ ��������ʵ�������Ƿ��и����˿�����", ""); } m++; //���������ƽ��ǧ�ף� m++; if (rows5.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows5[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "�������������", "��ѯ ��������ʵ�������Ƿ��и��������������", ""); } //�����������ƽ��ǧ�ף� m++; if (rows6.Length != 0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, rows6[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "�������������", "��ѯ ��������ʵ�������Ƿ��и����������������", ""); } //�����ʣ�%�� m++; if (rows7 != null &&rows4.Length!=0) { obj_sheet.SetValue(startrow + i * itemlength + m, 2 + j, Convert.ToDouble(rows7[0][yearstr] )/ Convert.ToDouble(rows4[0][yearstr])); FarPoint.Win.Spread.CellType.PercentCellType newcelltype =new FarPoint.Win.Spread.CellType.PercentCellType(); newcelltype.DecimalPlaces = 2; obj_sheet.Cells[startrow + i * itemlength + m, 2 + j].CellType = newcelltype; RowAllrk[yearstr] = Convert.ToDouble(RowAllrk[yearstr]) + Convert.ToDouble(rows4[0][yearstr]); RowCZrk[yearstr] = Convert.ToDouble(RowCZrk[yearstr]) + Convert.ToDouble(rows7[0][yearstr]); } else { TC.WriteQuestion(title, ptalist[i].Title + "�����˿ڻ����˿�����", "��ѯ ��������ʵ�������Ƿ��и��������˿ڻ����˿�����", ""); } } } } AddItems(obj_sheet, "ȫ��", startrow + ptalist.Count * itemlength); TC.Sheet_WriteFormula_RowSum2(obj_sheet, startrow, 2, ptalist.Count, itemlength, startrow + ptalist.Count * itemlength, 2, 1, 3, TableYearsAry.Length); TC.Sheet_WriteFormula_RowSum2(obj_sheet, startrow, 2, ptalist.Count, itemlength, startrow + ptalist.Count * itemlength, 2, 6, 2, TableYearsAry.Length); //����������ֵ����Ԫ��=һ��+����+���� TC.Sheet_WriteFormula_RowSum(obj_sheet, startrow + ptalist.Count * itemlength+1, 2, 3, 1, startrow + ptalist.Count * itemlength , 2, TableYearsAry.Length); //�˾�GDP����Ԫ��=����������ֵ����Ԫ��/�˿ڣ� TC.Sheet_WriteFormula_OneRow_AnoterRow_nopercent(obj_sheet, startrow + ptalist.Count * itemlength + 4, 2, startrow + ptalist.Count * itemlength, startrow + ptalist.Count * itemlength + 5,TableYearsAry.Length); //�������� for (int k = 0; k < TableYearsAry.Length; k++) { string yearstr = "y" + TableYearsAry[k].ToString(); obj_sheet.SetValue(startrow + ptalist.Count * itemlength + 8, 2 + k, Convert.ToDouble(RowCZrk[yearstr]) / Convert.ToDouble(RowAllrk[yearstr])); FarPoint.Win.Spread.CellType.PercentCellType newcelltype = new FarPoint.Win.Spread.CellType.PercentCellType(); newcelltype.DecimalPlaces = 2; obj_sheet.Cells[startrow + ptalist.Count * itemlength + 8, 2 + k].CellType = newcelltype; } //������ƽ�������� for (int l = 0; l < (ptalist.Count+1)*itemlength; l++) { obj_sheet.Cells[startrow + l, 2 + TableYearsAry.Length].Formula = " Power(R" + (startrow + l + 1) + "C" + (2 + TableYearsAry.Length) + "/R" + (startrow + l + 1) + "C" + 3 + "," + (1.000 / TableYearsAry.Length) + ")-1"; FarPoint.Win.Spread.CellType.PercentCellType newcelltype = new FarPoint.Win.Spread.CellType.PercentCellType(); newcelltype.DecimalPlaces = 2; obj_sheet.Cells[startrow + l, 2 + TableYearsAry.Length].CellType = newcelltype; } }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); FarPoint.Win.Spread.NamedStyle namedStyle1 = new FarPoint.Win.Spread.NamedStyle("Excel-0-15", "DataAreaDefault"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType1 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle2 = new FarPoint.Win.Spread.NamedStyle("Excel-0-16"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType2 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle3 = new FarPoint.Win.Spread.NamedStyle("Excel-0-17"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType3 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle4 = new FarPoint.Win.Spread.NamedStyle("Excel-0-18"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType4 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle5 = new FarPoint.Win.Spread.NamedStyle("Excel-0-19"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType5 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle6 = new FarPoint.Win.Spread.NamedStyle("Excel-0-20"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType6 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle7 = new FarPoint.Win.Spread.NamedStyle("Excel-0-21"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType7 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle8 = new FarPoint.Win.Spread.NamedStyle("Excel-0-22"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType8 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle9 = new FarPoint.Win.Spread.NamedStyle("Excel-0-23"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType9 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle10 = new FarPoint.Win.Spread.NamedStyle("Excel-0-24"); FarPoint.Win.ComplexBorder complexBorder1 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType10 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle11 = new FarPoint.Win.Spread.NamedStyle("Excel-0-25"); FarPoint.Win.ComplexBorder complexBorder2 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType11 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle12 = new FarPoint.Win.Spread.NamedStyle("Excel-0-26"); FarPoint.Win.ComplexBorder complexBorder3 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType12 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle13 = new FarPoint.Win.Spread.NamedStyle("Excel-0-27"); FarPoint.Win.ComplexBorder complexBorder4 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType13 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle14 = new FarPoint.Win.Spread.NamedStyle("Excel-0-28"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType14 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle15 = new FarPoint.Win.Spread.NamedStyle("Excel-0-29"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType15 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle16 = new FarPoint.Win.Spread.NamedStyle("Excel-0-30"); FarPoint.Win.ComplexBorder complexBorder5 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType16 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle17 = new FarPoint.Win.Spread.NamedStyle("Excel-0-31"); FarPoint.Win.ComplexBorder complexBorder6 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType17 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle18 = new FarPoint.Win.Spread.NamedStyle("Excel-0-32"); FarPoint.Win.ComplexBorder complexBorder7 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType18 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle19 = new FarPoint.Win.Spread.NamedStyle("Excel-0-33"); FarPoint.Win.ComplexBorder complexBorder8 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType19 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle20 = new FarPoint.Win.Spread.NamedStyle("Excel-0-34"); FarPoint.Win.ComplexBorder complexBorder9 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType20 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle21 = new FarPoint.Win.Spread.NamedStyle("Excel-0-35"); FarPoint.Win.ComplexBorder complexBorder10 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType21 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle22 = new FarPoint.Win.Spread.NamedStyle("Excel-0-36"); FarPoint.Win.ComplexBorder complexBorder11 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType22 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle23 = new FarPoint.Win.Spread.NamedStyle("Excel-0-37"); FarPoint.Win.ComplexBorder complexBorder12 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType23 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle24 = new FarPoint.Win.Spread.NamedStyle("Excel-0-38"); FarPoint.Win.ComplexBorder complexBorder13 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType24 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle25 = new FarPoint.Win.Spread.NamedStyle("Excel-0-39"); FarPoint.Win.ComplexBorder complexBorder14 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType25 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle26 = new FarPoint.Win.Spread.NamedStyle("Excel-0-40"); FarPoint.Win.ComplexBorder complexBorder15 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType26 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle27 = new FarPoint.Win.Spread.NamedStyle("Excel-0-41"); FarPoint.Win.ComplexBorder complexBorder16 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType27 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle28 = new FarPoint.Win.Spread.NamedStyle("Excel-0-42"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType28 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle29 = new FarPoint.Win.Spread.NamedStyle("Excel-0-15-基本数据"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType29 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle30 = new FarPoint.Win.Spread.NamedStyle("Excel-0-15-筹措表"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType30 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle31 = new FarPoint.Win.Spread.NamedStyle("Excel-0-15-还本付息表"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType31 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle32 = new FarPoint.Win.Spread.NamedStyle("Excel-0-15-成本费用表"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType32 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle33 = new FarPoint.Win.Spread.NamedStyle("Excel-0-15-全投资"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType33 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle34 = new FarPoint.Win.Spread.NamedStyle("Excel-0-15-资本金"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType34 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle35 = new FarPoint.Win.Spread.NamedStyle("Excel-0-15-损益表"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType35 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle36 = new FarPoint.Win.Spread.NamedStyle("Excel-0-15-一览表"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType36 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle37 = new FarPoint.Win.Spread.NamedStyle("Excel-0-15-参数"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType37 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.NamedStyle namedStyle38 = new FarPoint.Win.Spread.NamedStyle("Excel-0-15-投资资金"); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType38 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType39 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder17 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.NumberCellType numberCellType1 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder18 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType1 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder19 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType2 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder20 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType3 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder21 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType4 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder22 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType5 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder23 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType6 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder24 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType7 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder25 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType8 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder26 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType40 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder27 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType41 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder28 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType42 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder29 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType43 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType44 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder30 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType45 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder31 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType46 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder32 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType47 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder33 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType48 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder34 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType49 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder35 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType50 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder36 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType51 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder37 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType52 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder38 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType53 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder39 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType54 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder40 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType55 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder41 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType56 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder42 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType57 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder43 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType58 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder44 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType59 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder45 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType60 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder46 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType61 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder47 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType62 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder48 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType63 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder49 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType64 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder50 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType65 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder51 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType66 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType67 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType2 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType3 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType4 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType5 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType6 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType7 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType8 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType9 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType10 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType11 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.PercentCellType percentCellType9 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType12 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.Spread.CellType.PercentCellType percentCellType10 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.Spread.CellType.NumberCellType numberCellType13 = new FarPoint.Win.Spread.CellType.NumberCellType(); System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("zh-CN", false); FarPoint.Win.ComplexBorder complexBorder52 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.NumberCellType numberCellType14 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder53 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.NumberCellType numberCellType15 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder54 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.NumberCellType numberCellType16 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder55 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType11 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder56 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.NumberCellType numberCellType17 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder57 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.NumberCellType numberCellType18 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder58 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType12 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder59 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.NumberCellType numberCellType19 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder60 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType13 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder61 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType14 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder62 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.PercentCellType percentCellType15 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder63 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.NumberCellType numberCellType20 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder64 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))))), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine, System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))))); FarPoint.Win.Spread.CellType.NumberCellType numberCellType21 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder65 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType68 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder66 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder67 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder68 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder69 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder70 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder71 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType69 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder72 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder73 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder74 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder75 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder76 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder77 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder78 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.NumberCellType numberCellType22 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder79 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder80 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType16 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder81 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder82 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType17 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder83 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder84 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType18 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder85 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder86 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType19 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder87 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder88 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType20 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder89 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder90 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType21 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder91 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder92 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType22 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder93 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder94 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType23 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder95 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType70 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder96 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType24 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder97 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder98 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType25 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder99 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType71 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder100 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType26 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder101 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder102 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType27 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder103 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.GeneralCellType generalCellType72 = new FarPoint.Win.Spread.CellType.GeneralCellType(); FarPoint.Win.ComplexBorder complexBorder104 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType28 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder105 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder106 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType29 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder107 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder108 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.NumberCellType numberCellType23 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder109 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder110 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType30 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder111 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder112 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.NumberCellType numberCellType24 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder113 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder114 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType31 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder115 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder116 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.ComplexBorder complexBorder117 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder118 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType32 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder119 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder120 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType33 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder121 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder122 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType34 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder123 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder124 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.NumberCellType numberCellType25 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder125 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder126 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.NumberCellType numberCellType26 = new FarPoint.Win.Spread.CellType.NumberCellType(); FarPoint.Win.ComplexBorder complexBorder127 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder128 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.Spread.CellType.PercentCellType percentCellType35 = new FarPoint.Win.Spread.CellType.PercentCellType(); FarPoint.Win.ComplexBorder complexBorder129 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder130 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.None), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine), new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder131 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder132 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder133 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder134 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder135 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder136 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder137 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder138 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder139 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder140 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder141 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder142 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder143 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder144 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder145 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder146 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder147 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder148 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder149 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder150 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder151 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); FarPoint.Win.ComplexBorder complexBorder152 = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.ThinLine)); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FrmEconomyAnalysis)); this.splitContainerControl1 = new DevExpress.XtraEditors.SplitContainerControl(); this.treeList1 = new DevExpress.XtraTreeList.TreeList(); this.treeListColumn1 = new DevExpress.XtraTreeList.Columns.TreeListColumn(); this.ChapterNameTextEdit = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit(); this.treeListColumn2 = new DevExpress.XtraTreeList.Columns.TreeListColumn(); this.RemarkMemoExEdit = new DevExpress.XtraEditors.Repository.RepositoryItemMemoExEdit(); this.treeListColumn3 = new DevExpress.XtraTreeList.Columns.TreeListColumn(); this.treeListColumn4 = new DevExpress.XtraTreeList.Columns.TreeListColumn(); this.treeListColumn5 = new DevExpress.XtraTreeList.Columns.TreeListColumn(); this.textBox1 = new System.Windows.Forms.TextBox(); this.fpSpread1 = new FarPoint.Win.Spread.FpSpread(); this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.fpSpread1_Sheet2 = new FarPoint.Win.Spread.SheetView(); this.fpSpread1_Sheet3 = new FarPoint.Win.Spread.SheetView(); this.fpSpread1_Sheet4 = new FarPoint.Win.Spread.SheetView(); this.fpSpread1_Sheet5 = new FarPoint.Win.Spread.SheetView(); this.fpSpread1_Sheet6 = new FarPoint.Win.Spread.SheetView(); this.fpSpread1_Sheet7 = new FarPoint.Win.Spread.SheetView(); this.fpSpread1_Sheet8 = new FarPoint.Win.Spread.SheetView(); this.fpSpread1_Sheet9 = new FarPoint.Win.Spread.SheetView(); this.barManager1 = new DevExpress.XtraBars.BarManager(); this.bar1 = new DevExpress.XtraBars.Bar(); this.barList = new DevExpress.XtraBars.BarSubItem(); this.barAdditem = new DevExpress.XtraBars.BarButtonItem(); this.barAdd1item = new DevExpress.XtraBars.BarButtonItem(); this.barEdititem = new DevExpress.XtraBars.BarButtonItem(); this.barDelitem = new DevExpress.XtraBars.BarButtonItem(); this.barButtonItem4 = new DevExpress.XtraBars.BarButtonItem(); this.barCS = new DevExpress.XtraBars.BarButtonItem(); this.barSave = new DevExpress.XtraBars.BarButtonItem(); this.barButtonItem3 = new DevExpress.XtraBars.BarButtonItem(); this.barButtonItem5 = new DevExpress.XtraBars.BarButtonItem(); this.barPrint = new DevExpress.XtraBars.BarButtonItem(); this.barClose = new DevExpress.XtraBars.BarButtonItem(); this.barDockControlTop = new DevExpress.XtraBars.BarDockControl(); this.barDockControlBottom = new DevExpress.XtraBars.BarDockControl(); this.barDockControlLeft = new DevExpress.XtraBars.BarDockControl(); this.barDockControlRight = new DevExpress.XtraBars.BarDockControl(); this.imageList1 = new System.Windows.Forms.ImageList(this.components); this.barButtonItem1 = new DevExpress.XtraBars.BarButtonItem(); this.barButtonItem2 = new DevExpress.XtraBars.BarButtonItem(); this.repositoryItemComboBox1 = new DevExpress.XtraEditors.Repository.RepositoryItemComboBox(); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).BeginInit(); this.splitContainerControl1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.treeList1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.ChapterNameTextEdit)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.RemarkMemoExEdit)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet6)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet7)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet8)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet9)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.barManager1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemComboBox1)).BeginInit(); this.SuspendLayout(); // // splitContainerControl1 // this.splitContainerControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.splitContainerControl1.Location = new System.Drawing.Point(0, 34); this.splitContainerControl1.Name = "splitContainerControl1"; this.splitContainerControl1.Panel1.Controls.Add(this.treeList1); this.splitContainerControl1.Panel1.Text = "splitContainerControl1_Panel1"; this.splitContainerControl1.Panel2.Controls.Add(this.textBox1); this.splitContainerControl1.Panel2.Controls.Add(this.fpSpread1); this.splitContainerControl1.Panel2.Text = "splitContainerControl1_Panel2"; this.splitContainerControl1.Size = new System.Drawing.Size(822, 453); this.splitContainerControl1.SplitterPosition = 199; this.splitContainerControl1.TabIndex = 0; this.splitContainerControl1.Text = "splitContainerControl1"; // // treeList1 // this.treeList1.Appearance.HeaderPanel.Options.UseTextOptions = true; this.treeList1.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; this.treeList1.Columns.AddRange(new DevExpress.XtraTreeList.Columns.TreeListColumn[] { this.treeListColumn1, this.treeListColumn2, this.treeListColumn3, this.treeListColumn4, this.treeListColumn5}); this.treeList1.Dock = System.Windows.Forms.DockStyle.Fill; this.treeList1.KeyFieldName = "UID"; this.treeList1.Location = new System.Drawing.Point(0, 0); this.treeList1.Name = "treeList1"; this.treeList1.OptionsBehavior.AutoFocusNewNode = true; this.treeList1.OptionsSelection.InvertSelection = true; this.treeList1.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { this.ChapterNameTextEdit, this.RemarkMemoExEdit}); this.treeList1.Size = new System.Drawing.Size(193, 447); this.treeList1.TabIndex = 0; this.treeList1.FocusedNodeChanged += new DevExpress.XtraTreeList.FocusedNodeChangedEventHandler(this.treeList1_FocusedNodeChanged); this.treeList1.DoubleClick += new System.EventHandler(this.treeList1_DoubleClick); // // treeListColumn1 // this.treeListColumn1.Caption = "目录"; this.treeListColumn1.ColumnEdit = this.ChapterNameTextEdit; this.treeListColumn1.FieldName = "Title"; this.treeListColumn1.Name = "treeListColumn1"; this.treeListColumn1.OptionsColumn.AllowEdit = false; this.treeListColumn1.VisibleIndex = 0; // // ChapterNameTextEdit // this.ChapterNameTextEdit.AutoHeight = false; this.ChapterNameTextEdit.MaxLength = 100; this.ChapterNameTextEdit.Name = "ChapterNameTextEdit"; // // treeListColumn2 // this.treeListColumn2.Caption = "备注"; this.treeListColumn2.ColumnEdit = this.RemarkMemoExEdit; this.treeListColumn2.FieldName = "Remark"; this.treeListColumn2.Name = "treeListColumn2"; // // RemarkMemoExEdit // this.RemarkMemoExEdit.AutoHeight = false; this.RemarkMemoExEdit.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.RemarkMemoExEdit.MaxLength = 300; this.RemarkMemoExEdit.Name = "RemarkMemoExEdit"; this.RemarkMemoExEdit.ReadOnly = true; // // treeListColumn3 // this.treeListColumn3.Caption = "UID"; this.treeListColumn3.FieldName = "UID"; this.treeListColumn3.Name = "treeListColumn3"; this.treeListColumn3.OptionsColumn.ShowInCustomizationForm = false; // // treeListColumn4 // this.treeListColumn4.Caption = "ParentId"; this.treeListColumn4.FieldName = "ParentID"; this.treeListColumn4.Name = "treeListColumn4"; this.treeListColumn4.OptionsColumn.ShowInCustomizationForm = false; // // treeListColumn5 // this.treeListColumn5.Caption = "创建日期"; this.treeListColumn5.FieldName = "CreateDate"; this.treeListColumn5.Name = "treeListColumn5"; this.treeListColumn5.OptionsColumn.ShowInCustomizationForm = false; this.treeListColumn5.SortOrder = System.Windows.Forms.SortOrder.Ascending; // // textBox1 // this.textBox1.Location = new System.Drawing.Point(118, -385); this.textBox1.Name = "textBox1"; this.textBox1.Size = new System.Drawing.Size(100, 21); this.textBox1.TabIndex = 1; // // fpSpread1 // this.fpSpread1.AccessibleDescription = "fpSpread1, 还本付息表, Row 0, Column 0, 附表3 借款还本付息计算表"; this.fpSpread1.AllowCellOverflow = true; this.fpSpread1.AllowUserFormulas = true; this.fpSpread1.BackColor = System.Drawing.SystemColors.Control; this.fpSpread1.BorderCollapse = FarPoint.Win.Spread.BorderCollapse.Collapse; this.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.fpSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpSpread1.Location = new System.Drawing.Point(0, 0); this.fpSpread1.Name = "fpSpread1"; namedStyle1.CellType = generalCellType1; namedStyle1.Font = new System.Drawing.Font("宋体", 9F); namedStyle1.Locked = false; namedStyle1.Parent = "DataAreaDefault"; namedStyle1.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle2.CellType = generalCellType2; namedStyle2.Locked = false; namedStyle2.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom; namedStyle3.CellType = generalCellType3; namedStyle3.Locked = false; namedStyle3.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom; namedStyle4.CellType = generalCellType4; namedStyle4.Locked = false; namedStyle4.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom; namedStyle5.CellType = generalCellType5; namedStyle5.Locked = false; namedStyle5.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom; namedStyle6.CellType = generalCellType6; namedStyle6.Locked = false; namedStyle6.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom; namedStyle7.CellType = generalCellType7; namedStyle7.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle7.Locked = false; namedStyle7.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle8.CellType = generalCellType8; namedStyle8.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle8.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; namedStyle8.Locked = false; namedStyle8.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle9.CellType = generalCellType9; namedStyle9.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle9.Locked = false; namedStyle9.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle10.Border = complexBorder1; namedStyle10.CellType = generalCellType10; namedStyle10.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle10.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; namedStyle10.Locked = false; namedStyle10.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle11.Border = complexBorder2; namedStyle11.CellType = generalCellType11; namedStyle11.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle11.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; namedStyle11.Locked = false; namedStyle11.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle12.Border = complexBorder3; namedStyle12.CellType = generalCellType12; namedStyle12.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle12.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; namedStyle12.Locked = false; namedStyle12.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle13.Border = complexBorder4; namedStyle13.CellType = generalCellType13; namedStyle13.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle13.Locked = false; namedStyle13.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle14.CellType = generalCellType14; namedStyle14.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle14.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; namedStyle14.Locked = false; namedStyle14.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle15.CellType = generalCellType15; namedStyle15.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle15.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; namedStyle15.Locked = false; namedStyle15.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle16.Border = complexBorder5; namedStyle16.CellType = generalCellType16; namedStyle16.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle16.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; namedStyle16.Locked = false; namedStyle16.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle17.Border = complexBorder6; namedStyle17.CellType = generalCellType17; namedStyle17.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle17.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; namedStyle17.Locked = false; namedStyle17.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle18.Border = complexBorder7; namedStyle18.CellType = generalCellType18; namedStyle18.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle18.Locked = false; namedStyle18.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle19.Border = complexBorder8; namedStyle19.CellType = generalCellType19; namedStyle19.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle19.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; namedStyle19.Locked = false; namedStyle19.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle20.Border = complexBorder9; namedStyle20.CellType = generalCellType20; namedStyle20.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle20.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; namedStyle20.Locked = false; namedStyle20.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle21.Border = complexBorder10; namedStyle21.CellType = generalCellType21; namedStyle21.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle21.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; namedStyle21.Locked = false; namedStyle21.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle22.Border = complexBorder11; namedStyle22.CellType = generalCellType22; namedStyle22.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle22.Locked = false; namedStyle22.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle23.Border = complexBorder12; namedStyle23.CellType = generalCellType23; namedStyle23.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle23.Locked = false; namedStyle23.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle24.Border = complexBorder13; namedStyle24.CellType = generalCellType24; namedStyle24.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle24.Locked = false; namedStyle24.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle25.Border = complexBorder14; namedStyle25.CellType = generalCellType25; namedStyle25.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle25.Locked = false; namedStyle25.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle26.Border = complexBorder15; namedStyle26.CellType = generalCellType26; namedStyle26.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle26.Locked = false; namedStyle26.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle27.Border = complexBorder16; namedStyle27.CellType = generalCellType27; namedStyle27.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle27.Locked = false; namedStyle27.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle28.CellType = generalCellType28; namedStyle28.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); namedStyle28.Locked = false; namedStyle28.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle29.CellType = generalCellType29; namedStyle29.Font = new System.Drawing.Font("宋体", 9F); namedStyle29.Locked = false; namedStyle29.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle30.CellType = generalCellType30; namedStyle30.Font = new System.Drawing.Font("宋体", 9F); namedStyle30.Locked = false; namedStyle30.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle31.CellType = generalCellType31; namedStyle31.Font = new System.Drawing.Font("宋体", 9F); namedStyle31.Locked = false; namedStyle31.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle32.CellType = generalCellType32; namedStyle32.Font = new System.Drawing.Font("宋体", 9F); namedStyle32.Locked = false; namedStyle32.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle33.CellType = generalCellType33; namedStyle33.Font = new System.Drawing.Font("宋体", 9F); namedStyle33.Locked = false; namedStyle33.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle34.CellType = generalCellType34; namedStyle34.Font = new System.Drawing.Font("宋体", 9F); namedStyle34.Locked = false; namedStyle34.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle35.CellType = generalCellType35; namedStyle35.Font = new System.Drawing.Font("宋体", 9F); namedStyle35.Locked = false; namedStyle35.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle36.CellType = generalCellType36; namedStyle36.Font = new System.Drawing.Font("宋体", 9F); namedStyle36.Locked = false; namedStyle36.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle37.CellType = generalCellType37; namedStyle37.Font = new System.Drawing.Font("宋体", 9F); namedStyle37.Locked = false; namedStyle37.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; namedStyle38.CellType = generalCellType38; namedStyle38.Font = new System.Drawing.Font("宋体", 9F); namedStyle38.Locked = false; namedStyle38.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1.NamedStyles.AddRange(new FarPoint.Win.Spread.NamedStyle[] { namedStyle1, namedStyle2, namedStyle3, namedStyle4, namedStyle5, namedStyle6, namedStyle7, namedStyle8, namedStyle9, namedStyle10, namedStyle11, namedStyle12, namedStyle13, namedStyle14, namedStyle15, namedStyle16, namedStyle17, namedStyle18, namedStyle19, namedStyle20, namedStyle21, namedStyle22, namedStyle23, namedStyle24, namedStyle25, namedStyle26, namedStyle27, namedStyle28, namedStyle29, namedStyle30, namedStyle31, namedStyle32, namedStyle33, namedStyle34, namedStyle35, namedStyle36, namedStyle37, namedStyle38}); this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpSpread1_Sheet1, this.fpSpread1_Sheet2, this.fpSpread1_Sheet3, this.fpSpread1_Sheet4, this.fpSpread1_Sheet5, this.fpSpread1_Sheet6, this.fpSpread1_Sheet7, this.fpSpread1_Sheet8, this.fpSpread1_Sheet9}); this.fpSpread1.Size = new System.Drawing.Size(613, 447); this.fpSpread1.TabIndex = 0; this.fpSpread1.TabStrip.ActiveSheetTab.Font = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold); this.fpSpread1.TabStrip.ActiveSheetTab.Size = -1; this.fpSpread1.TabStrip.DefaultSheetTab.Font = new System.Drawing.Font("Tahoma", 8F); this.fpSpread1.TabStrip.DefaultSheetTab.Size = -1; this.fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always; this.fpSpread1.TabStripRatio = 0.664188351920694; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.fpSpread1.TextTipAppearance = tipAppearance1; this.fpSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpSpread1.CellClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpSpread1_CellClick); this.fpSpread1.Change += new FarPoint.Win.Spread.ChangeEventHandler(this.fpSpread1_Change); this.fpSpread1.ActiveSheetIndex = 2; // // fpSpread1_Sheet1 // this.fpSpread1_Sheet1.Reset(); this.fpSpread1_Sheet1.SheetName = "基本数据"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet1.ColumnCount = 2; this.fpSpread1_Sheet1.RowCount = 14; this.fpSpread1_Sheet1.AutoUpdateNotes = true; this.fpSpread1_Sheet1.Cells.Get(0, 0).CellType = generalCellType39; this.fpSpread1_Sheet1.Cells.Get(0, 0).ColumnSpan = 2; this.fpSpread1_Sheet1.Cells.Get(0, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet1.Cells.Get(0, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet1.Cells.Get(0, 0).Value = "附表1 电网规划经济评价基本数据"; this.fpSpread1_Sheet1.Cells.Get(0, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet1.Cells.Get(1, 0).StyleName = "Excel-0-23"; this.fpSpread1_Sheet1.Cells.Get(1, 0).Value = " "; this.fpSpread1_Sheet1.Cells.Get(1, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet1.Cells.Get(2, 0).StyleName = "Excel-0-24"; this.fpSpread1_Sheet1.Cells.Get(2, 0).Value = "经营成本"; this.fpSpread1_Sheet1.Cells.Get(2, 1).StyleName = "Excel-0-25"; this.fpSpread1_Sheet1.Cells.Get(2, 1).Value = "新增固定资产原值的5%"; this.fpSpread1_Sheet1.Cells.Get(3, 0).StyleName = "Excel-0-26"; this.fpSpread1_Sheet1.Cells.Get(3, 0).Value = "还贷期"; this.fpSpread1_Sheet1.Cells.Get(3, 1).Border = complexBorder17; numberCellType1.DecimalPlaces = 0; numberCellType1.MaximumValue = 10000000; numberCellType1.MinimumValue = -10000000; this.fpSpread1_Sheet1.Cells.Get(3, 1).CellType = numberCellType1; this.fpSpread1_Sheet1.Cells.Get(3, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet1.Cells.Get(3, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet1.Cells.Get(4, 0).StyleName = "Excel-0-26"; this.fpSpread1_Sheet1.Cells.Get(4, 0).Value = "实际贷款年利率"; this.fpSpread1_Sheet1.Cells.Get(4, 1).Border = complexBorder18; percentCellType1.FixedPoint = true; percentCellType1.PercentSign = "%"; this.fpSpread1_Sheet1.Cells.Get(4, 1).CellType = percentCellType1; this.fpSpread1_Sheet1.Cells.Get(4, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet1.Cells.Get(4, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet1.Cells.Get(5, 0).StyleName = "Excel-0-26"; this.fpSpread1_Sheet1.Cells.Get(5, 0).Value = "折旧率"; this.fpSpread1_Sheet1.Cells.Get(5, 1).Border = complexBorder19; percentCellType2.FixedPoint = true; percentCellType2.PercentSign = "%"; this.fpSpread1_Sheet1.Cells.Get(5, 1).CellType = percentCellType2; this.fpSpread1_Sheet1.Cells.Get(5, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet1.Cells.Get(5, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet1.Cells.Get(6, 0).StyleName = "Excel-0-26"; this.fpSpread1_Sheet1.Cells.Get(6, 0).Value = "固定资产残值"; this.fpSpread1_Sheet1.Cells.Get(6, 1).Border = complexBorder20; percentCellType3.FixedPoint = true; percentCellType3.PercentSign = "%"; this.fpSpread1_Sheet1.Cells.Get(6, 1).CellType = percentCellType3; this.fpSpread1_Sheet1.Cells.Get(6, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet1.Cells.Get(6, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet1.Cells.Get(7, 0).StyleName = "Excel-0-26"; this.fpSpread1_Sheet1.Cells.Get(7, 0).Value = "城建及教育附加税"; this.fpSpread1_Sheet1.Cells.Get(7, 1).Border = complexBorder21; percentCellType4.FixedPoint = true; percentCellType4.PercentSign = "%"; this.fpSpread1_Sheet1.Cells.Get(7, 1).CellType = percentCellType4; this.fpSpread1_Sheet1.Cells.Get(7, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet1.Cells.Get(7, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet1.Cells.Get(8, 0).StyleName = "Excel-0-26"; this.fpSpread1_Sheet1.Cells.Get(8, 0).Value = "公积金、公益金率"; this.fpSpread1_Sheet1.Cells.Get(8, 1).Border = complexBorder22; percentCellType5.FixedPoint = true; percentCellType5.PercentSign = "%"; this.fpSpread1_Sheet1.Cells.Get(8, 1).CellType = percentCellType5; this.fpSpread1_Sheet1.Cells.Get(8, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet1.Cells.Get(8, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet1.Cells.Get(9, 0).StyleName = "Excel-0-26"; this.fpSpread1_Sheet1.Cells.Get(9, 0).Value = "所得税率"; this.fpSpread1_Sheet1.Cells.Get(9, 1).Border = complexBorder23; percentCellType6.FixedPoint = true; percentCellType6.PercentSign = "%"; this.fpSpread1_Sheet1.Cells.Get(9, 1).CellType = percentCellType6; this.fpSpread1_Sheet1.Cells.Get(9, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet1.Cells.Get(9, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet1.Cells.Get(10, 0).StyleName = "Excel-0-26"; this.fpSpread1_Sheet1.Cells.Get(10, 0).Value = "折旧还贷率"; this.fpSpread1_Sheet1.Cells.Get(10, 1).Border = complexBorder24; percentCellType7.FixedPoint = true; percentCellType7.PercentSign = "%"; this.fpSpread1_Sheet1.Cells.Get(10, 1).CellType = percentCellType7; this.fpSpread1_Sheet1.Cells.Get(10, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet1.Cells.Get(10, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet1.Cells.Get(11, 0).StyleName = "Excel-0-26"; this.fpSpread1_Sheet1.Cells.Get(11, 0).Value = "股本金分利"; this.fpSpread1_Sheet1.Cells.Get(11, 1).Border = complexBorder25; percentCellType8.FixedPoint = true; percentCellType8.PercentSign = "%"; this.fpSpread1_Sheet1.Cells.Get(11, 1).CellType = percentCellType8; this.fpSpread1_Sheet1.Cells.Get(11, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet1.Cells.Get(11, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet1.Cells.Get(12, 0).StyleName = "Excel-0-23"; this.fpSpread1_Sheet1.Cells.Get(13, 0).StyleName = "Excel-0-28"; this.fpSpread1_Sheet1.Cells.Get(13, 0).Value = "注:城市维护建设税税率:"; this.fpSpread1_Sheet1.Cells.Get(13, 1).StyleName = "Excel-0-23"; this.fpSpread1_Sheet1.Cells.Get(13, 1).Value = "市区7%,县镇5%,其它地区1%;教育费附加3%"; this.fpSpread1_Sheet1.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers; this.fpSpread1_Sheet1.Columns.Default.Width = 64F; this.fpSpread1_Sheet1.Columns.Get(0).Width = 160F; this.fpSpread1_Sheet1.Columns.Get(1).Width = 284F; this.fpSpread1_Sheet1.DefaultStyleName = "Excel-0-15"; this.fpSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpSpread1_Sheet1.Rows.Get(0).Height = 30F; // // fpSpread1_Sheet2 // this.fpSpread1_Sheet2.Reset(); this.fpSpread1_Sheet2.SheetName = "筹措表"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet2.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet2.ColumnCount = 50; this.fpSpread1_Sheet2.RowCount = 15; this.fpSpread1_Sheet2.AutoUpdateNotes = true; this.fpSpread1_Sheet2.Cells.Get(0, 0).StyleName = "Excel-0-29"; this.fpSpread1_Sheet2.Cells.Get(0, 0).Value = "附表2 投资总额和资金筹措表"; this.fpSpread1_Sheet2.Cells.Get(0, 1).StyleName = "Excel-0-23"; this.fpSpread1_Sheet2.Cells.Get(0, 2).StyleName = "Excel-0-23"; this.fpSpread1_Sheet2.Cells.Get(0, 3).StyleName = "Excel-0-23"; this.fpSpread1_Sheet2.Cells.Get(1, 0).StyleName = "Excel-0-23"; this.fpSpread1_Sheet2.Cells.Get(1, 1).StyleName = "Excel-0-23"; this.fpSpread1_Sheet2.Cells.Get(1, 2).StyleName = "Excel-0-23"; this.fpSpread1_Sheet2.Cells.Get(1, 3).StyleName = "Excel-0-23"; this.fpSpread1_Sheet2.Cells.Get(2, 0).Border = complexBorder26; this.fpSpread1_Sheet2.Cells.Get(2, 0).CellType = generalCellType40; this.fpSpread1_Sheet2.Cells.Get(2, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(2, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(2, 0).Value = "序 号"; this.fpSpread1_Sheet2.Cells.Get(2, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(2, 1).Border = complexBorder27; this.fpSpread1_Sheet2.Cells.Get(2, 1).CellType = generalCellType41; this.fpSpread1_Sheet2.Cells.Get(2, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(2, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(2, 1).Value = "项 目"; this.fpSpread1_Sheet2.Cells.Get(2, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(2, 2).StyleName = "Excel-0-29"; this.fpSpread1_Sheet2.Cells.Get(2, 3).StyleName = "Excel-0-23"; this.fpSpread1_Sheet2.Cells.Get(3, 0).Border = complexBorder28; this.fpSpread1_Sheet2.Cells.Get(3, 0).CellType = generalCellType42; this.fpSpread1_Sheet2.Cells.Get(3, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(3, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(3, 0).Value = 1; this.fpSpread1_Sheet2.Cells.Get(3, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(3, 1).Border = complexBorder29; this.fpSpread1_Sheet2.Cells.Get(3, 1).CellType = generalCellType43; this.fpSpread1_Sheet2.Cells.Get(3, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(3, 1).Value = "投资总额"; this.fpSpread1_Sheet2.Cells.Get(3, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(3, 2).CellType = generalCellType44; this.fpSpread1_Sheet2.Cells.Get(3, 2).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(3, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet2.Cells.Get(3, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(4, 0).Border = complexBorder30; this.fpSpread1_Sheet2.Cells.Get(4, 0).CellType = generalCellType45; this.fpSpread1_Sheet2.Cells.Get(4, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(4, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(4, 0).Value = 1.1; this.fpSpread1_Sheet2.Cells.Get(4, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(4, 1).Border = complexBorder31; this.fpSpread1_Sheet2.Cells.Get(4, 1).CellType = generalCellType46; this.fpSpread1_Sheet2.Cells.Get(4, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(4, 1).Value = "建设静态投资"; this.fpSpread1_Sheet2.Cells.Get(4, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(4, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet2.Cells.Get(5, 0).Border = complexBorder32; this.fpSpread1_Sheet2.Cells.Get(5, 0).CellType = generalCellType47; this.fpSpread1_Sheet2.Cells.Get(5, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(5, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(5, 0).Value = 1.2; this.fpSpread1_Sheet2.Cells.Get(5, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(5, 1).Border = complexBorder33; this.fpSpread1_Sheet2.Cells.Get(5, 1).CellType = generalCellType48; this.fpSpread1_Sheet2.Cells.Get(5, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(5, 1).Value = "建设期利息"; this.fpSpread1_Sheet2.Cells.Get(5, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(6, 0).Border = complexBorder34; this.fpSpread1_Sheet2.Cells.Get(6, 0).CellType = generalCellType49; this.fpSpread1_Sheet2.Cells.Get(6, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(6, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(6, 0).Value = 1.3; this.fpSpread1_Sheet2.Cells.Get(6, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(6, 1).Border = complexBorder35; this.fpSpread1_Sheet2.Cells.Get(6, 1).CellType = generalCellType50; this.fpSpread1_Sheet2.Cells.Get(6, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(6, 1).Value = "建设动态投资"; this.fpSpread1_Sheet2.Cells.Get(6, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(7, 0).Border = complexBorder36; this.fpSpread1_Sheet2.Cells.Get(7, 0).CellType = generalCellType51; this.fpSpread1_Sheet2.Cells.Get(7, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(7, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(7, 0).Value = 2; this.fpSpread1_Sheet2.Cells.Get(7, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(7, 1).Border = complexBorder37; this.fpSpread1_Sheet2.Cells.Get(7, 1).CellType = generalCellType52; this.fpSpread1_Sheet2.Cells.Get(7, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(7, 1).Value = "固定资产原值"; this.fpSpread1_Sheet2.Cells.Get(7, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(8, 0).Border = complexBorder38; this.fpSpread1_Sheet2.Cells.Get(8, 0).CellType = generalCellType53; this.fpSpread1_Sheet2.Cells.Get(8, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(8, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(8, 0).Value = 3; this.fpSpread1_Sheet2.Cells.Get(8, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(8, 1).Border = complexBorder39; this.fpSpread1_Sheet2.Cells.Get(8, 1).CellType = generalCellType54; this.fpSpread1_Sheet2.Cells.Get(8, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(8, 1).Value = "流动资金"; this.fpSpread1_Sheet2.Cells.Get(8, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(9, 0).Border = complexBorder40; this.fpSpread1_Sheet2.Cells.Get(9, 0).CellType = generalCellType55; this.fpSpread1_Sheet2.Cells.Get(9, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(9, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(9, 0).Value = 4; this.fpSpread1_Sheet2.Cells.Get(9, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(9, 1).Border = complexBorder41; this.fpSpread1_Sheet2.Cells.Get(9, 1).CellType = generalCellType56; this.fpSpread1_Sheet2.Cells.Get(9, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(9, 1).Value = "建设资金筹措"; this.fpSpread1_Sheet2.Cells.Get(9, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(10, 0).Border = complexBorder42; this.fpSpread1_Sheet2.Cells.Get(10, 0).CellType = generalCellType57; this.fpSpread1_Sheet2.Cells.Get(10, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(10, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(10, 0).Value = 4.1; this.fpSpread1_Sheet2.Cells.Get(10, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(10, 1).Border = complexBorder43; this.fpSpread1_Sheet2.Cells.Get(10, 1).CellType = generalCellType58; this.fpSpread1_Sheet2.Cells.Get(10, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(10, 1).Value = "资本金"; this.fpSpread1_Sheet2.Cells.Get(10, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(11, 0).Border = complexBorder44; this.fpSpread1_Sheet2.Cells.Get(11, 0).CellType = generalCellType59; this.fpSpread1_Sheet2.Cells.Get(11, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(11, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(11, 0).Value = 4.2; this.fpSpread1_Sheet2.Cells.Get(11, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(11, 1).Border = complexBorder45; this.fpSpread1_Sheet2.Cells.Get(11, 1).CellType = generalCellType60; this.fpSpread1_Sheet2.Cells.Get(11, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(11, 1).Value = "融资"; this.fpSpread1_Sheet2.Cells.Get(11, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(12, 0).Border = complexBorder46; this.fpSpread1_Sheet2.Cells.Get(12, 0).CellType = generalCellType61; this.fpSpread1_Sheet2.Cells.Get(12, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(12, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(12, 0).Value = 5; this.fpSpread1_Sheet2.Cells.Get(12, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(12, 1).Border = complexBorder47; this.fpSpread1_Sheet2.Cells.Get(12, 1).CellType = generalCellType62; this.fpSpread1_Sheet2.Cells.Get(12, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(12, 1).Value = "流动资金筹措"; this.fpSpread1_Sheet2.Cells.Get(12, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(13, 0).Border = complexBorder48; this.fpSpread1_Sheet2.Cells.Get(13, 0).CellType = generalCellType63; this.fpSpread1_Sheet2.Cells.Get(13, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(13, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(13, 0).Value = 5.1; this.fpSpread1_Sheet2.Cells.Get(13, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(13, 1).Border = complexBorder49; this.fpSpread1_Sheet2.Cells.Get(13, 1).CellType = generalCellType64; this.fpSpread1_Sheet2.Cells.Get(13, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(13, 1).Value = "自有"; this.fpSpread1_Sheet2.Cells.Get(13, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(14, 0).Border = complexBorder50; this.fpSpread1_Sheet2.Cells.Get(14, 0).CellType = generalCellType65; this.fpSpread1_Sheet2.Cells.Get(14, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(14, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet2.Cells.Get(14, 0).Value = 5.2; this.fpSpread1_Sheet2.Cells.Get(14, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.Cells.Get(14, 1).Border = complexBorder51; this.fpSpread1_Sheet2.Cells.Get(14, 1).CellType = generalCellType66; this.fpSpread1_Sheet2.Cells.Get(14, 1).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet2.Cells.Get(14, 1).Value = "借款"; this.fpSpread1_Sheet2.Cells.Get(14, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet2.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers; this.fpSpread1_Sheet2.Columns.Default.Width = 64F; this.fpSpread1_Sheet2.Columns.Get(0).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(0).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(1).Width = 143F; this.fpSpread1_Sheet2.Columns.Get(2).Width = 59F; this.fpSpread1_Sheet2.Columns.Get(3).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(3).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(4).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(4).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(5).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(5).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(6).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(6).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(7).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(7).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(8).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(8).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(9).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(9).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(10).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(10).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(11).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(11).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(12).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(12).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(13).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(13).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(14).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(14).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(15).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(15).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(16).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(16).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(17).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(17).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(18).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(18).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(19).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(19).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(20).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(20).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(21).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(21).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(22).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(22).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(23).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(23).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(24).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(24).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(25).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(25).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(26).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(26).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(27).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(27).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(28).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(28).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(29).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(29).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(30).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(30).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(31).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(31).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(32).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(32).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(33).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(33).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(34).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(34).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(35).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(35).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(36).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(36).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(37).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(37).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(38).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(38).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(39).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(39).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(40).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(40).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(41).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(41).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(42).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(42).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(43).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(43).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(44).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(44).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(45).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(45).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(46).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(46).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(47).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(47).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(48).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(48).Width = 61F; this.fpSpread1_Sheet2.Columns.Get(49).StyleName = "Excel-0-21"; this.fpSpread1_Sheet2.Columns.Get(49).Width = 61F; this.fpSpread1_Sheet2.DefaultStyleName = "Excel-0-15"; this.fpSpread1_Sheet2.RowHeader.Columns.Default.Resizable = false; // // fpSpread1_Sheet3 // this.fpSpread1_Sheet3.Reset(); this.fpSpread1_Sheet3.SheetName = "还本付息表"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet3.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet3.ColumnCount = 255; this.fpSpread1_Sheet3.RowCount = 65535; this.fpSpread1_Sheet3.AutoUpdateNotes = true; this.fpSpread1_Sheet3.Cells.Get(0, 0).CellType = generalCellType67; this.fpSpread1_Sheet3.Cells.Get(0, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet3.Cells.Get(0, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet3.Cells.Get(0, 0).Value = "附表3 借款还本付息计算表"; this.fpSpread1_Sheet3.Cells.Get(0, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet3.Cells.Get(2, 0).StyleName = "Excel-0-23"; this.fpSpread1_Sheet3.Cells.Get(3, 0).StyleName = "Excel-0-23"; this.fpSpread1_Sheet3.Cells.Get(3, 0).Value = "融资"; this.fpSpread1_Sheet3.Cells.Get(4, 0).StyleName = "Excel-0-23"; this.fpSpread1_Sheet3.Cells.Get(4, 0).Value = "还贷要求"; this.fpSpread1_Sheet3.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers; this.fpSpread1_Sheet3.Columns.Default.Width = 64F; this.fpSpread1_Sheet3.Columns.Get(0).Width = 112F; this.fpSpread1_Sheet3.DefaultStyleName = "Excel-0-15"; this.fpSpread1_Sheet3.RowHeader.Columns.Default.Resizable = false; this.fpSpread1_Sheet3.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.MultiRange; // // fpSpread1_Sheet4 // this.fpSpread1_Sheet4.Reset(); this.fpSpread1_Sheet4.SheetName = "成本费用表"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet4.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet4.ColumnCount = 100; this.fpSpread1_Sheet4.RowCount = 9; this.fpSpread1_Sheet4.AutoUpdateNotes = true; this.fpSpread1_Sheet4.Cells.Get(0, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet4.Cells.Get(0, 0).Value = "附表4 总成本费用估算表"; this.fpSpread1_Sheet4.Cells.Get(1, 1).Value = " "; this.fpSpread1_Sheet4.Cells.Get(2, 0).StyleName = "Excel-0-25"; this.fpSpread1_Sheet4.Cells.Get(2, 0).Value = "序 号"; this.fpSpread1_Sheet4.Cells.Get(2, 1).StyleName = "Excel-0-33"; this.fpSpread1_Sheet4.Cells.Get(2, 1).Value = "项 目"; this.fpSpread1_Sheet4.Cells.Get(3, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet4.Cells.Get(3, 0).Value = 1; this.fpSpread1_Sheet4.Cells.Get(3, 1).StyleName = "Excel-0-34"; this.fpSpread1_Sheet4.Cells.Get(3, 1).Value = "售电量"; numberCellType2.DecimalPlaces = 0; numberCellType2.MaximumValue = 10000000; numberCellType2.MinimumValue = -10000000; this.fpSpread1_Sheet4.Cells.Get(3, 2).CellType = numberCellType2; numberCellType3.DecimalPlaces = 0; numberCellType3.MaximumValue = 10000000; numberCellType3.MinimumValue = -10000000; this.fpSpread1_Sheet4.Cells.Get(3, 3).CellType = numberCellType3; numberCellType4.DecimalPlaces = 0; numberCellType4.MaximumValue = 10000000; numberCellType4.MinimumValue = -10000000; this.fpSpread1_Sheet4.Cells.Get(3, 4).CellType = numberCellType4; numberCellType5.DecimalPlaces = 0; numberCellType5.MaximumValue = 10000000; numberCellType5.MinimumValue = -10000000; this.fpSpread1_Sheet4.Cells.Get(3, 5).CellType = numberCellType5; numberCellType6.DecimalPlaces = 0; numberCellType6.MaximumValue = 10000000; numberCellType6.MinimumValue = -10000000; this.fpSpread1_Sheet4.Cells.Get(3, 6).CellType = numberCellType6; numberCellType7.DecimalPlaces = 0; numberCellType7.MaximumValue = 10000000; numberCellType7.MinimumValue = -10000000; this.fpSpread1_Sheet4.Cells.Get(3, 7).CellType = numberCellType7; numberCellType8.DecimalPlaces = 0; numberCellType8.MaximumValue = 10000000; numberCellType8.MinimumValue = -10000000; this.fpSpread1_Sheet4.Cells.Get(3, 8).CellType = numberCellType8; numberCellType9.DecimalPlaces = 0; numberCellType9.MaximumValue = 10000000; numberCellType9.MinimumValue = -10000000; this.fpSpread1_Sheet4.Cells.Get(3, 9).CellType = numberCellType9; numberCellType10.DecimalPlaces = 0; numberCellType10.MaximumValue = 10000000; numberCellType10.MinimumValue = -10000000; this.fpSpread1_Sheet4.Cells.Get(3, 10).CellType = numberCellType10; numberCellType11.DecimalPlaces = 0; numberCellType11.MaximumValue = 10000000; numberCellType11.MinimumValue = -10000000; this.fpSpread1_Sheet4.Cells.Get(3, 11).CellType = numberCellType11; this.fpSpread1_Sheet4.Cells.Get(4, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet4.Cells.Get(4, 0).Value = 2; this.fpSpread1_Sheet4.Cells.Get(4, 1).StyleName = "Excel-0-34"; this.fpSpread1_Sheet4.Cells.Get(4, 1).Value = "经营成本"; this.fpSpread1_Sheet4.Cells.Get(5, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet4.Cells.Get(5, 0).Value = 3; this.fpSpread1_Sheet4.Cells.Get(5, 1).StyleName = "Excel-0-34"; this.fpSpread1_Sheet4.Cells.Get(5, 1).Value = "折旧费"; this.fpSpread1_Sheet4.Cells.Get(6, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet4.Cells.Get(6, 0).Value = 4; this.fpSpread1_Sheet4.Cells.Get(6, 1).StyleName = "Excel-0-34"; this.fpSpread1_Sheet4.Cells.Get(6, 1).Value = "财务费用"; this.fpSpread1_Sheet4.Cells.Get(7, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet4.Cells.Get(7, 0).Value = 5; this.fpSpread1_Sheet4.Cells.Get(7, 1).StyleName = "Excel-0-34"; this.fpSpread1_Sheet4.Cells.Get(7, 1).Value = "生产成本(2+3)"; this.fpSpread1_Sheet4.Cells.Get(8, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet4.Cells.Get(8, 0).Value = 6; this.fpSpread1_Sheet4.Cells.Get(8, 1).StyleName = "Excel-0-34"; this.fpSpread1_Sheet4.Cells.Get(8, 1).Value = "输变电总成本(4+5)"; this.fpSpread1_Sheet4.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers; this.fpSpread1_Sheet4.Columns.Default.Width = 64F; this.fpSpread1_Sheet4.Columns.Get(0).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(0).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(1).Width = 113F; this.fpSpread1_Sheet4.Columns.Get(2).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(2).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(3).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(3).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(4).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(4).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(5).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(5).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(6).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(6).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(7).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(7).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(8).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(8).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(9).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(9).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(10).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(10).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(11).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(11).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(12).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(12).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(13).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(13).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(14).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(14).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(15).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(15).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(16).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(16).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(17).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(17).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(18).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(18).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(19).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(19).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(20).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(20).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(21).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(21).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(22).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(22).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(23).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(23).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(24).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(24).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(25).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(25).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(26).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(26).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(27).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(27).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(28).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(28).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(29).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(29).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(30).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(30).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(31).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(31).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(32).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(32).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(33).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(33).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(34).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(34).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(35).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(35).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(36).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(36).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(37).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(37).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(38).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(38).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(39).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(39).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(40).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(40).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(41).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(41).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(42).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(42).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(43).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(43).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(44).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(44).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(45).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(45).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(46).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(46).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(47).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(47).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(48).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(48).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(49).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(49).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(50).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(50).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(51).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(51).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(52).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(52).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(53).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(53).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(54).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(54).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(55).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(55).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(56).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(56).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(57).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(57).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(58).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(58).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(59).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(59).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(60).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(60).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(61).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(61).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(62).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(62).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(63).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(63).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(64).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(64).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(65).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(65).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(66).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(66).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(67).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(67).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(68).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(68).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(69).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(69).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(70).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(70).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(71).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(71).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(72).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(72).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(73).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(73).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(74).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(74).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(75).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(75).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(76).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(76).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(77).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(77).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(78).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(78).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(79).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(79).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(80).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(80).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(81).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(81).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(82).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(82).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(83).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(83).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(84).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(84).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(85).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(85).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(86).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(86).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(87).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(87).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(88).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(88).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(89).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(89).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(90).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(90).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(91).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(91).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(92).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(92).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(93).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(93).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(94).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(94).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(95).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(95).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(96).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(96).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(97).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(97).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(98).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(98).Width = 61F; this.fpSpread1_Sheet4.Columns.Get(99).StyleName = "Excel-0-21"; this.fpSpread1_Sheet4.Columns.Get(99).Width = 61F; this.fpSpread1_Sheet4.DefaultStyleName = "Excel-0-15"; this.fpSpread1_Sheet4.RowHeader.Columns.Default.Resizable = false; // // fpSpread1_Sheet5 // this.fpSpread1_Sheet5.Reset(); this.fpSpread1_Sheet5.SheetName = "全投资"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet5.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet5.ColumnCount = 100; this.fpSpread1_Sheet5.RowCount = 20; this.fpSpread1_Sheet5.ActiveColumnIndex = 4; this.fpSpread1_Sheet5.ActiveRowIndex = 19; this.fpSpread1_Sheet5.AutoUpdateNotes = true; this.fpSpread1_Sheet5.Cells.Get(0, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet5.Cells.Get(0, 0).Value = "附表5 现金流量表"; this.fpSpread1_Sheet5.Cells.Get(2, 0).StyleName = "Excel-0-35"; this.fpSpread1_Sheet5.Cells.Get(2, 0).Value = "序 号"; this.fpSpread1_Sheet5.Cells.Get(2, 1).StyleName = "Excel-0-36"; this.fpSpread1_Sheet5.Cells.Get(2, 1).Value = " 项 目"; this.fpSpread1_Sheet5.Cells.Get(3, 0).StyleName = "Excel-0-37"; this.fpSpread1_Sheet5.Cells.Get(3, 1).StyleName = "Excel-0-38"; this.fpSpread1_Sheet5.Cells.Get(4, 0).StyleName = "Excel-0-25"; this.fpSpread1_Sheet5.Cells.Get(4, 0).Value = 1; this.fpSpread1_Sheet5.Cells.Get(4, 1).StyleName = "Excel-0-39"; this.fpSpread1_Sheet5.Cells.Get(4, 1).Value = "现金流入"; this.fpSpread1_Sheet5.Cells.Get(5, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(5, 0).Value = 1.1; this.fpSpread1_Sheet5.Cells.Get(5, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(5, 1).Value = "销售加价收入"; this.fpSpread1_Sheet5.Cells.Get(6, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(6, 0).Value = 1.2; this.fpSpread1_Sheet5.Cells.Get(6, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(6, 1).Value = "回收流动资金"; this.fpSpread1_Sheet5.Cells.Get(7, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(7, 0).Value = 1.3; this.fpSpread1_Sheet5.Cells.Get(7, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(7, 1).Value = "回收固定资产余值"; this.fpSpread1_Sheet5.Cells.Get(8, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(8, 0).Value = 2; this.fpSpread1_Sheet5.Cells.Get(8, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(8, 1).Value = "现金流出"; this.fpSpread1_Sheet5.Cells.Get(9, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(9, 0).Value = 2.1; this.fpSpread1_Sheet5.Cells.Get(9, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(9, 1).Value = "建设投资"; this.fpSpread1_Sheet5.Cells.Get(10, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(10, 0).Value = 2.2; this.fpSpread1_Sheet5.Cells.Get(10, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(10, 1).Value = "流动资金"; this.fpSpread1_Sheet5.Cells.Get(11, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(11, 0).Value = 2.3; this.fpSpread1_Sheet5.Cells.Get(11, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(11, 1).Value = "经营成本"; this.fpSpread1_Sheet5.Cells.Get(12, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(12, 0).Value = 2.4; this.fpSpread1_Sheet5.Cells.Get(12, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(12, 1).Value = "销售税金"; this.fpSpread1_Sheet5.Cells.Get(13, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(13, 0).Value = 2.5; this.fpSpread1_Sheet5.Cells.Get(13, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(13, 1).Value = "所得税"; this.fpSpread1_Sheet5.Cells.Get(14, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(14, 0).Value = 3; this.fpSpread1_Sheet5.Cells.Get(14, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(14, 1).Value = "净现金流量"; this.fpSpread1_Sheet5.Cells.Get(15, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(15, 0).Value = 4; this.fpSpread1_Sheet5.Cells.Get(15, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(15, 1).Value = "累计净现金流量"; this.fpSpread1_Sheet5.Cells.Get(16, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(16, 0).Value = 5; this.fpSpread1_Sheet5.Cells.Get(16, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(16, 1).Value = "净现金流量现值"; this.fpSpread1_Sheet5.Cells.Get(17, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet5.Cells.Get(17, 0).Value = 6; this.fpSpread1_Sheet5.Cells.Get(17, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet5.Cells.Get(17, 1).Value = "净现金流量现值累计"; this.fpSpread1_Sheet5.Cells.Get(19, 0).StyleName = "Excel-0-23"; this.fpSpread1_Sheet5.Cells.Get(19, 0).Value = "内部收益率"; percentCellType9.FixedPoint = true; percentCellType9.PercentSign = "%"; this.fpSpread1_Sheet5.Cells.Get(19, 1).CellType = percentCellType9; this.fpSpread1_Sheet5.Cells.Get(19, 2).StyleName = "Excel-0-23"; this.fpSpread1_Sheet5.Cells.Get(19, 3).StyleName = "Excel-0-23"; this.fpSpread1_Sheet5.Cells.Get(19, 3).Value = "净现值"; numberCellType12.DecimalPlaces = 0; numberCellType12.MaximumValue = 10000000; numberCellType12.MinimumValue = -9999999; this.fpSpread1_Sheet5.Cells.Get(19, 4).CellType = numberCellType12; this.fpSpread1_Sheet5.Cells.Get(19, 5).StyleName = "Excel-0-23"; this.fpSpread1_Sheet5.Cells.Get(19, 5).Value = "万元"; this.fpSpread1_Sheet5.Cells.Get(19, 6).StyleName = "Excel-0-23"; this.fpSpread1_Sheet5.Cells.Get(19, 7).StyleName = "Excel-0-23"; this.fpSpread1_Sheet5.Cells.Get(19, 7).Value = "回收期"; this.fpSpread1_Sheet5.Cells.Get(19, 9).StyleName = "Excel-0-23"; this.fpSpread1_Sheet5.Cells.Get(19, 9).Value = "年"; this.fpSpread1_Sheet5.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers; this.fpSpread1_Sheet5.Columns.Default.Width = 64F; this.fpSpread1_Sheet5.Columns.Get(0).Width = 71F; this.fpSpread1_Sheet5.Columns.Get(1).Width = 154F; this.fpSpread1_Sheet5.Columns.Get(2).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(2).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(3).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(3).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(4).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(4).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(5).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(5).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(6).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(6).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(7).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(7).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(8).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(8).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(9).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(9).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(10).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(10).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(11).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(11).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(12).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(12).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(13).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(13).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(14).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(14).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(15).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(15).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(16).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(16).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(17).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(17).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(18).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(18).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(19).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(19).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(20).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(20).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(21).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(21).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(22).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(22).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(23).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(23).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(24).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(24).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(25).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(25).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(26).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(26).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(27).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(27).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(28).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(28).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(29).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(29).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(30).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(30).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(31).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(31).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(32).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(32).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(33).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(33).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(34).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(34).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(35).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(35).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(36).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(36).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(37).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(37).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(38).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(38).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(39).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(39).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(40).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(40).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(41).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(41).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(42).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(42).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(43).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(43).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(44).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(44).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(45).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(45).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(46).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(46).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(47).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(47).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(48).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(48).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(49).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(49).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(50).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(50).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(51).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(51).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(52).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(52).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(53).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(53).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(54).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(54).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(55).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(55).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(56).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(56).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(57).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(57).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(58).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(58).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(59).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(59).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(60).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(60).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(61).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(61).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(62).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(62).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(63).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(63).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(64).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(64).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(65).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(65).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(66).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(66).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(67).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(67).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(68).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(68).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(69).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(69).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(70).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(70).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(71).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(71).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(72).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(72).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(73).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(73).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(74).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(74).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(75).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(75).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(76).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(76).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(77).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(77).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(78).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(78).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(79).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(79).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(80).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(80).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(81).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(81).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(82).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(82).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(83).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(83).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(84).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(84).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(85).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(85).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(86).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(86).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(87).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(87).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(88).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(88).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(89).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(89).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(90).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(90).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(91).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(91).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(92).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(92).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(93).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(93).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(94).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(94).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(95).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(95).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(96).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(96).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(97).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(97).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(98).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(98).Width = 61F; this.fpSpread1_Sheet5.Columns.Get(99).StyleName = "Excel-0-21"; this.fpSpread1_Sheet5.Columns.Get(99).Width = 61F; this.fpSpread1_Sheet5.DefaultStyleName = "Excel-0-15"; this.fpSpread1_Sheet5.RowHeader.Columns.Default.Resizable = false; // // fpSpread1_Sheet6 // this.fpSpread1_Sheet6.Reset(); this.fpSpread1_Sheet6.SheetName = "资本金"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet6.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet6.ColumnCount = 255; this.fpSpread1_Sheet6.RowCount = 20; this.fpSpread1_Sheet6.ActiveColumnIndex = 4; this.fpSpread1_Sheet6.ActiveRowIndex = 19; this.fpSpread1_Sheet6.AutoUpdateNotes = true; this.fpSpread1_Sheet6.Cells.Get(0, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet6.Cells.Get(0, 0).Value = "附表6 资 本 金 现 金 流 量 表"; this.fpSpread1_Sheet6.Cells.Get(2, 0).StyleName = "Excel-0-25"; this.fpSpread1_Sheet6.Cells.Get(2, 0).Value = "序 号"; this.fpSpread1_Sheet6.Cells.Get(2, 1).StyleName = "Excel-0-39"; this.fpSpread1_Sheet6.Cells.Get(2, 1).Value = " 项 目"; this.fpSpread1_Sheet6.Cells.Get(3, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(3, 1).StyleName = "Excel-0-40"; this.fpSpread1_Sheet6.Cells.Get(4, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(4, 0).Value = 1; this.fpSpread1_Sheet6.Cells.Get(4, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(4, 1).Value = "现金流入"; this.fpSpread1_Sheet6.Cells.Get(5, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(5, 0).Value = 1.1; this.fpSpread1_Sheet6.Cells.Get(5, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(5, 1).Value = "资本金分利"; this.fpSpread1_Sheet6.Cells.Get(6, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(6, 0).Value = 1.2; this.fpSpread1_Sheet6.Cells.Get(6, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(6, 1).Value = "回收流动资金"; this.fpSpread1_Sheet6.Cells.Get(7, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(7, 0).Value = 1.3; this.fpSpread1_Sheet6.Cells.Get(7, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(7, 1).Value = "回收固定资产余值"; this.fpSpread1_Sheet6.Cells.Get(8, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(8, 0).Value = 1.4; this.fpSpread1_Sheet6.Cells.Get(8, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(8, 1).Value = "回收折旧费"; this.fpSpread1_Sheet6.Cells.Get(9, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(9, 0).Value = 1.5; this.fpSpread1_Sheet6.Cells.Get(9, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(9, 1).Value = "回收余留公积金"; this.fpSpread1_Sheet6.Cells.Get(10, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(10, 0).Value = 2; this.fpSpread1_Sheet6.Cells.Get(10, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(10, 1).Value = "现金流出"; this.fpSpread1_Sheet6.Cells.Get(11, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(11, 0).Value = 2.1; this.fpSpread1_Sheet6.Cells.Get(11, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(11, 1).Value = "建设投资"; this.fpSpread1_Sheet6.Cells.Get(12, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(12, 0).Value = 2.2; this.fpSpread1_Sheet6.Cells.Get(12, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(12, 1).Value = "流动资金"; this.fpSpread1_Sheet6.Cells.Get(13, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(13, 0).Value = 2.3; this.fpSpread1_Sheet6.Cells.Get(13, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(13, 1).Value = "其它"; this.fpSpread1_Sheet6.Cells.Get(14, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(14, 0).Value = 3; this.fpSpread1_Sheet6.Cells.Get(14, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(14, 1).Value = "净现金流量"; this.fpSpread1_Sheet6.Cells.Get(15, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(15, 0).Value = 4; this.fpSpread1_Sheet6.Cells.Get(15, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(15, 1).Value = "累计净现金流量"; this.fpSpread1_Sheet6.Cells.Get(16, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(16, 0).Value = 5; this.fpSpread1_Sheet6.Cells.Get(16, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(16, 1).Value = "净现金流量现值"; this.fpSpread1_Sheet6.Cells.Get(17, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet6.Cells.Get(17, 0).Value = 6; this.fpSpread1_Sheet6.Cells.Get(17, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet6.Cells.Get(17, 1).Value = "净现金流量现值累计"; this.fpSpread1_Sheet6.Cells.Get(19, 0).StyleName = "Excel-0-23"; this.fpSpread1_Sheet6.Cells.Get(19, 0).Value = "内部收益率"; percentCellType10.FixedPoint = true; percentCellType10.PercentSign = "%"; this.fpSpread1_Sheet6.Cells.Get(19, 1).CellType = percentCellType10; this.fpSpread1_Sheet6.Cells.Get(19, 2).StyleName = "Excel-0-23"; this.fpSpread1_Sheet6.Cells.Get(19, 3).StyleName = "Excel-0-23"; this.fpSpread1_Sheet6.Cells.Get(19, 3).Value = "净现值"; numberCellType13.DecimalPlaces = 0; numberCellType13.MaximumValue = 100000000; numberCellType13.MinimumValue = -100000000; this.fpSpread1_Sheet6.Cells.Get(19, 4).CellType = numberCellType13; this.fpSpread1_Sheet6.Cells.Get(19, 4).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet6.Cells.Get(19, 4).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet6.Cells.Get(19, 5).StyleName = "Excel-0-23"; this.fpSpread1_Sheet6.Cells.Get(19, 5).Value = "万元"; this.fpSpread1_Sheet6.Cells.Get(19, 6).StyleName = "Excel-0-23"; this.fpSpread1_Sheet6.Cells.Get(19, 7).StyleName = "Excel-0-23"; this.fpSpread1_Sheet6.Cells.Get(19, 7).Value = "回收期"; this.fpSpread1_Sheet6.Cells.Get(19, 8).StyleName = "Excel-0-23"; this.fpSpread1_Sheet6.Cells.Get(19, 9).StyleName = "Excel-0-23"; this.fpSpread1_Sheet6.Cells.Get(19, 9).Value = "年"; this.fpSpread1_Sheet6.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers; this.fpSpread1_Sheet6.Columns.Default.Width = 64F; this.fpSpread1_Sheet6.Columns.Get(0).Width = 76F; this.fpSpread1_Sheet6.Columns.Get(1).Width = 160F; this.fpSpread1_Sheet6.DefaultStyleName = "Excel-0-15"; this.fpSpread1_Sheet6.RowHeader.Columns.Default.Resizable = false; // // fpSpread1_Sheet7 // this.fpSpread1_Sheet7.Reset(); this.fpSpread1_Sheet7.SheetName = "损益表"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet7.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet7.ColumnCount = 255; this.fpSpread1_Sheet7.RowCount = 13; this.fpSpread1_Sheet7.ActiveColumnIndex = 1; this.fpSpread1_Sheet7.AutoUpdateNotes = true; this.fpSpread1_Sheet7.Cells.Get(0, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet7.Cells.Get(0, 0).Value = "附表7 损益表"; this.fpSpread1_Sheet7.Cells.Get(2, 0).StyleName = "Excel-0-25"; this.fpSpread1_Sheet7.Cells.Get(2, 0).Value = "序 号"; this.fpSpread1_Sheet7.Cells.Get(2, 1).StyleName = "Excel-0-41"; this.fpSpread1_Sheet7.Cells.Get(2, 1).Value = "项 目"; this.fpSpread1_Sheet7.Cells.Get(3, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet7.Cells.Get(3, 0).Value = 1; this.fpSpread1_Sheet7.Cells.Get(3, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet7.Cells.Get(3, 1).Value = "销售收入"; this.fpSpread1_Sheet7.Cells.Get(4, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet7.Cells.Get(4, 0).Value = 1.1; this.fpSpread1_Sheet7.Cells.Get(4, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet7.Cells.Get(4, 1).Value = "电量加价(不含税)"; this.fpSpread1_Sheet7.Cells.Get(5, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet7.Cells.Get(5, 0).Value = 1.2; this.fpSpread1_Sheet7.Cells.Get(5, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet7.Cells.Get(5, 1).Value = "售电量"; this.fpSpread1_Sheet7.Cells.Get(6, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet7.Cells.Get(6, 0).Value = 2; this.fpSpread1_Sheet7.Cells.Get(6, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet7.Cells.Get(6, 1).Value = "销售税金及附加"; this.fpSpread1_Sheet7.Cells.Get(7, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet7.Cells.Get(7, 0).Value = 3; this.fpSpread1_Sheet7.Cells.Get(7, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet7.Cells.Get(7, 1).Value = "总成本费用"; this.fpSpread1_Sheet7.Cells.Get(8, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet7.Cells.Get(8, 0).Value = 4; this.fpSpread1_Sheet7.Cells.Get(8, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet7.Cells.Get(8, 1).Value = "销售利润"; this.fpSpread1_Sheet7.Cells.Get(9, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet7.Cells.Get(9, 0).Value = 5; this.fpSpread1_Sheet7.Cells.Get(9, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet7.Cells.Get(9, 1).Value = "所得税"; this.fpSpread1_Sheet7.Cells.Get(10, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet7.Cells.Get(10, 0).Value = 6; this.fpSpread1_Sheet7.Cells.Get(10, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet7.Cells.Get(10, 1).Value = "公积金、公益金"; this.fpSpread1_Sheet7.Cells.Get(11, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet7.Cells.Get(11, 0).Value = 7; this.fpSpread1_Sheet7.Cells.Get(11, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet7.Cells.Get(11, 1).Value = "偿还建设投资借款"; this.fpSpread1_Sheet7.Cells.Get(12, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet7.Cells.Get(12, 0).Value = 8; this.fpSpread1_Sheet7.Cells.Get(12, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet7.Cells.Get(12, 1).Value = "资本金分利"; this.fpSpread1_Sheet7.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers; this.fpSpread1_Sheet7.Columns.Default.Width = 64F; this.fpSpread1_Sheet7.Columns.Get(1).Width = 142F; this.fpSpread1_Sheet7.Columns.Get(4).Width = 63F; this.fpSpread1_Sheet7.DefaultStyleName = "Excel-0-15"; this.fpSpread1_Sheet7.RowHeader.Columns.Default.Resizable = false; // // fpSpread1_Sheet8 // this.fpSpread1_Sheet8.Reset(); this.fpSpread1_Sheet8.SheetName = "一览表"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet8.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet8.ColumnCount = 4; this.fpSpread1_Sheet8.RowCount = 21; this.fpSpread1_Sheet8.ActiveColumnIndex = 1; this.fpSpread1_Sheet8.ActiveRowIndex = 17; this.fpSpread1_Sheet8.AutoUpdateNotes = true; this.fpSpread1_Sheet8.Cells.Get(0, 0).ColumnSpan = 4; this.fpSpread1_Sheet8.Cells.Get(0, 0).StyleName = "Excel-0-22"; this.fpSpread1_Sheet8.Cells.Get(0, 0).Value = "附表8 工 程 经 济 效 益 指 标 一 览 表"; this.fpSpread1_Sheet8.Cells.Get(0, 1).StyleName = "Excel-0-23"; this.fpSpread1_Sheet8.Cells.Get(0, 2).StyleName = "Excel-0-23"; this.fpSpread1_Sheet8.Cells.Get(1, 0).StyleName = "Excel-0-23"; this.fpSpread1_Sheet8.Cells.Get(1, 1).StyleName = "Excel-0-23"; this.fpSpread1_Sheet8.Cells.Get(1, 2).StyleName = "Excel-0-23"; this.fpSpread1_Sheet8.Cells.Get(2, 0).StyleName = "Excel-0-25"; this.fpSpread1_Sheet8.Cells.Get(2, 0).Value = " 序 号"; this.fpSpread1_Sheet8.Cells.Get(2, 1).StyleName = "Excel-0-39"; this.fpSpread1_Sheet8.Cells.Get(2, 1).Value = "项 目"; this.fpSpread1_Sheet8.Cells.Get(2, 2).StyleName = "Excel-0-39"; this.fpSpread1_Sheet8.Cells.Get(2, 2).Value = "单 位"; this.fpSpread1_Sheet8.Cells.Get(2, 3).StyleName = "Excel-0-39"; this.fpSpread1_Sheet8.Cells.Get(2, 3).Value = "指 标"; this.fpSpread1_Sheet8.Cells.Get(3, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(3, 0).Value = 1; this.fpSpread1_Sheet8.Cells.Get(3, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(3, 1).Value = "输变电静态投资"; this.fpSpread1_Sheet8.Cells.Get(3, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(3, 2).Value = "万元"; this.fpSpread1_Sheet8.Cells.Get(3, 3).Border = complexBorder52; numberCellType14.DecimalPlaces = 0; numberCellType14.MaximumValue = 10000000; numberCellType14.MinimumValue = -10000000; this.fpSpread1_Sheet8.Cells.Get(3, 3).CellType = numberCellType14; this.fpSpread1_Sheet8.Cells.Get(3, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(3, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(4, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(4, 0).Value = 2; this.fpSpread1_Sheet8.Cells.Get(4, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(4, 1).Value = "建设期利息"; this.fpSpread1_Sheet8.Cells.Get(4, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(4, 2).Value = "万元"; this.fpSpread1_Sheet8.Cells.Get(4, 3).Border = complexBorder53; numberCellType15.DecimalPlaces = 0; numberCellType15.MaximumValue = 10000000; numberCellType15.MinimumValue = -10000000; this.fpSpread1_Sheet8.Cells.Get(4, 3).CellType = numberCellType15; this.fpSpread1_Sheet8.Cells.Get(4, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(4, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(5, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(5, 0).Value = 3; this.fpSpread1_Sheet8.Cells.Get(5, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(5, 1).Value = "输变电动态投资"; this.fpSpread1_Sheet8.Cells.Get(5, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(5, 2).Value = "万元"; this.fpSpread1_Sheet8.Cells.Get(5, 3).Border = complexBorder54; numberCellType16.DecimalPlaces = 0; numberCellType16.MaximumValue = 10000000; numberCellType16.MinimumValue = -10000000; this.fpSpread1_Sheet8.Cells.Get(5, 3).CellType = numberCellType16; this.fpSpread1_Sheet8.Cells.Get(5, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(5, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(6, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(6, 0).Value = 4; this.fpSpread1_Sheet8.Cells.Get(6, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(6, 1).Value = "内部收益率(全部投资)"; this.fpSpread1_Sheet8.Cells.Get(6, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(6, 2).Value = "%"; this.fpSpread1_Sheet8.Cells.Get(6, 3).Border = complexBorder55; percentCellType11.FixedPoint = true; percentCellType11.PercentSign = "%"; this.fpSpread1_Sheet8.Cells.Get(6, 3).CellType = percentCellType11; this.fpSpread1_Sheet8.Cells.Get(6, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(6, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(7, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(7, 0).Value = 5; this.fpSpread1_Sheet8.Cells.Get(7, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(7, 1).Value = "净现值"; this.fpSpread1_Sheet8.Cells.Get(7, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(7, 2).Value = "万元"; this.fpSpread1_Sheet8.Cells.Get(7, 3).Border = complexBorder56; numberCellType17.DecimalPlaces = 0; numberCellType17.MaximumValue = 10000000; numberCellType17.MinimumValue = -10000000; this.fpSpread1_Sheet8.Cells.Get(7, 3).CellType = numberCellType17; this.fpSpread1_Sheet8.Cells.Get(7, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(7, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(8, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(8, 0).Value = 6; this.fpSpread1_Sheet8.Cells.Get(8, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(8, 1).Value = "投资回收期"; this.fpSpread1_Sheet8.Cells.Get(8, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(8, 2).Value = "年"; this.fpSpread1_Sheet8.Cells.Get(8, 3).Border = complexBorder57; numberCellType18.DecimalPlaces = 1; numberCellType18.FixedPoint = false; numberCellType18.MaximumValue = 10000000; numberCellType18.MinimumValue = -10000000; this.fpSpread1_Sheet8.Cells.Get(8, 3).CellType = numberCellType18; this.fpSpread1_Sheet8.Cells.Get(8, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(8, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(9, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(9, 0).Value = 7; this.fpSpread1_Sheet8.Cells.Get(9, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(9, 1).Value = "内部收益率(资本金)"; this.fpSpread1_Sheet8.Cells.Get(9, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(9, 2).Value = "%"; this.fpSpread1_Sheet8.Cells.Get(9, 3).Border = complexBorder58; percentCellType12.FixedPoint = true; percentCellType12.PercentSign = "%"; this.fpSpread1_Sheet8.Cells.Get(9, 3).CellType = percentCellType12; this.fpSpread1_Sheet8.Cells.Get(9, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(9, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(10, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(10, 0).Value = 8; this.fpSpread1_Sheet8.Cells.Get(10, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(10, 1).Value = "净现值"; this.fpSpread1_Sheet8.Cells.Get(10, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(10, 2).Value = "万元"; this.fpSpread1_Sheet8.Cells.Get(10, 3).Border = complexBorder59; numberCellType19.DecimalPlaces = 0; numberCellType19.MaximumValue = 10000000; numberCellType19.MinimumValue = -10000000; this.fpSpread1_Sheet8.Cells.Get(10, 3).CellType = numberCellType19; this.fpSpread1_Sheet8.Cells.Get(10, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(10, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(11, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(11, 0).Value = 9; this.fpSpread1_Sheet8.Cells.Get(11, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(11, 1).Value = "投资利润率"; this.fpSpread1_Sheet8.Cells.Get(11, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(11, 2).Value = "%"; this.fpSpread1_Sheet8.Cells.Get(11, 3).Border = complexBorder60; percentCellType13.FixedPoint = true; percentCellType13.PercentSign = "%"; this.fpSpread1_Sheet8.Cells.Get(11, 3).CellType = percentCellType13; this.fpSpread1_Sheet8.Cells.Get(11, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(11, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(12, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(12, 0).Value = 10; this.fpSpread1_Sheet8.Cells.Get(12, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(12, 1).Value = "投资利税率"; this.fpSpread1_Sheet8.Cells.Get(12, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(12, 2).Value = "%"; this.fpSpread1_Sheet8.Cells.Get(12, 3).Border = complexBorder61; percentCellType14.FixedPoint = true; percentCellType14.PercentSign = "%"; this.fpSpread1_Sheet8.Cells.Get(12, 3).CellType = percentCellType14; this.fpSpread1_Sheet8.Cells.Get(12, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(12, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(13, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(13, 0).Value = 11; this.fpSpread1_Sheet8.Cells.Get(13, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(13, 1).Value = "资本金净利润率"; this.fpSpread1_Sheet8.Cells.Get(13, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(13, 2).Value = "%"; this.fpSpread1_Sheet8.Cells.Get(13, 3).Border = complexBorder62; percentCellType15.FixedPoint = true; percentCellType15.PercentSign = "%"; this.fpSpread1_Sheet8.Cells.Get(13, 3).CellType = percentCellType15; this.fpSpread1_Sheet8.Cells.Get(13, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(13, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(14, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(14, 0).Value = 12; this.fpSpread1_Sheet8.Cells.Get(14, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(14, 1).Value = "电网电量不含税加价(还贷期间)"; this.fpSpread1_Sheet8.Cells.Get(14, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(14, 2).Value = "元/千瓦时"; this.fpSpread1_Sheet8.Cells.Get(14, 3).Border = complexBorder63; numberCellType20.DecimalPlaces = 4; this.fpSpread1_Sheet8.Cells.Get(14, 3).CellType = numberCellType20; this.fpSpread1_Sheet8.Cells.Get(14, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(14, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(15, 0).StyleName = "Excel-0-31"; this.fpSpread1_Sheet8.Cells.Get(15, 0).Value = 13; this.fpSpread1_Sheet8.Cells.Get(15, 1).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(15, 1).Value = "电网电量不含税加价(还贷后)"; this.fpSpread1_Sheet8.Cells.Get(15, 2).StyleName = "Excel-0-32"; this.fpSpread1_Sheet8.Cells.Get(15, 2).Value = "元/千瓦时"; this.fpSpread1_Sheet8.Cells.Get(15, 3).Border = complexBorder64; numberCellType21.DecimalPlaces = 4; this.fpSpread1_Sheet8.Cells.Get(15, 3).CellType = numberCellType21; this.fpSpread1_Sheet8.Cells.Get(15, 3).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(15, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(16, 0).Border = complexBorder65; this.fpSpread1_Sheet8.Cells.Get(16, 0).CellType = generalCellType68; this.fpSpread1_Sheet8.Cells.Get(16, 0).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(16, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet8.Cells.Get(16, 0).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet8.Cells.Get(16, 0).ParseFormatInfo)).NumberDecimalDigits = 0; ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet8.Cells.Get(16, 0).ParseFormatInfo)).NumberGroupSizes = new int[] { 0}; this.fpSpread1_Sheet8.Cells.Get(16, 0).ParseFormatString = "n"; this.fpSpread1_Sheet8.Cells.Get(16, 0).Value = 14; this.fpSpread1_Sheet8.Cells.Get(16, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(16, 1).Border = complexBorder66; this.fpSpread1_Sheet8.Cells.Get(16, 1).Value = "单位电量输配电成本(不含网费,不含税)"; this.fpSpread1_Sheet8.Cells.Get(16, 2).Border = complexBorder67; this.fpSpread1_Sheet8.Cells.Get(16, 2).Value = "元/兆瓦时"; this.fpSpread1_Sheet8.Cells.Get(16, 3).Border = complexBorder68; this.fpSpread1_Sheet8.Cells.Get(17, 0).Border = complexBorder69; this.fpSpread1_Sheet8.Cells.Get(17, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet8.Cells.Get(17, 0).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet8.Cells.Get(17, 0).ParseFormatInfo)).NumberDecimalDigits = 0; ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet8.Cells.Get(17, 0).ParseFormatInfo)).NumberGroupSizes = new int[] { 0}; this.fpSpread1_Sheet8.Cells.Get(17, 0).ParseFormatString = "n"; this.fpSpread1_Sheet8.Cells.Get(17, 0).Value = 15; this.fpSpread1_Sheet8.Cells.Get(17, 1).Border = complexBorder70; this.fpSpread1_Sheet8.Cells.Get(17, 1).Value = "单位电量输配电成本(不含网费,含税)"; this.fpSpread1_Sheet8.Cells.Get(17, 2).Border = complexBorder71; this.fpSpread1_Sheet8.Cells.Get(17, 2).CellType = generalCellType69; this.fpSpread1_Sheet8.Cells.Get(17, 2).Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.fpSpread1_Sheet8.Cells.Get(17, 2).Value = "元/兆瓦时"; this.fpSpread1_Sheet8.Cells.Get(17, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top; this.fpSpread1_Sheet8.Cells.Get(17, 3).Border = complexBorder72; this.fpSpread1_Sheet8.Cells.Get(18, 0).Border = complexBorder73; this.fpSpread1_Sheet8.Cells.Get(18, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet8.Cells.Get(18, 0).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet8.Cells.Get(18, 0).ParseFormatInfo)).NumberDecimalDigits = 0; ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet8.Cells.Get(18, 0).ParseFormatInfo)).NumberGroupSizes = new int[] { 0}; this.fpSpread1_Sheet8.Cells.Get(18, 0).ParseFormatString = "n"; this.fpSpread1_Sheet8.Cells.Get(18, 0).Value = 16; this.fpSpread1_Sheet8.Cells.Get(18, 1).Border = complexBorder74; this.fpSpread1_Sheet8.Cells.Get(18, 1).Value = "单位电量输配电成本(含网费,含税)"; this.fpSpread1_Sheet8.Cells.Get(18, 2).Border = complexBorder75; this.fpSpread1_Sheet8.Cells.Get(18, 2).Value = "元/兆瓦时"; this.fpSpread1_Sheet8.Cells.Get(18, 3).Border = complexBorder76; this.fpSpread1_Sheet8.Cells.Get(20, 0).StyleName = "Excel-0-23"; this.fpSpread1_Sheet8.Cells.Get(20, 0).Value = "备注:"; this.fpSpread1_Sheet8.Cells.Get(20, 1).StyleName = "Excel-0-23"; this.fpSpread1_Sheet8.Cells.Get(20, 1).Value = "含税价=不含税价×1.17"; this.fpSpread1_Sheet8.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers; this.fpSpread1_Sheet8.Columns.Default.Width = 64F; this.fpSpread1_Sheet8.Columns.Get(0).Width = 106F; this.fpSpread1_Sheet8.Columns.Get(1).Width = 199F; this.fpSpread1_Sheet8.Columns.Get(2).Width = 79F; this.fpSpread1_Sheet8.DefaultStyleName = "Excel-0-15"; this.fpSpread1_Sheet8.RowHeader.Columns.Default.Resizable = false; this.fpSpread1_Sheet8.Rows.Get(0).Height = 21F; // // fpSpread1_Sheet9 // this.fpSpread1_Sheet9.Reset(); this.fpSpread1_Sheet9.SheetName = "参数"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet9.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet9.ColumnCount = 4; this.fpSpread1_Sheet9.RowCount = 27; this.fpSpread1_Sheet9.AutoUpdateNotes = true; this.fpSpread1_Sheet9.Cells.Get(0, 0).ColumnSpan = 4; this.fpSpread1_Sheet9.Cells.Get(0, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(0, 0).Value = "参数设置"; this.fpSpread1_Sheet9.Cells.Get(0, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(1, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(1, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(1, 1).Value = " "; this.fpSpread1_Sheet9.Cells.Get(1, 2).Value = " "; this.fpSpread1_Sheet9.Cells.Get(2, 0).Border = complexBorder77; this.fpSpread1_Sheet9.Cells.Get(2, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(2, 0).Value = "还贷期"; this.fpSpread1_Sheet9.Cells.Get(2, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(2, 1).Border = complexBorder78; numberCellType22.DecimalPlaces = 0; numberCellType22.FixedPoint = false; numberCellType22.MaximumValue = 9999999; numberCellType22.MinimumValue = -9999999; this.fpSpread1_Sheet9.Cells.Get(2, 1).CellType = numberCellType22; this.fpSpread1_Sheet9.Cells.Get(2, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(2, 1).Value = 0; this.fpSpread1_Sheet9.Cells.Get(2, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(2, 2).Border = complexBorder79; this.fpSpread1_Sheet9.Cells.Get(2, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(2, 2).Value = "教育费附加"; this.fpSpread1_Sheet9.Cells.Get(2, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(2, 3).Border = complexBorder80; percentCellType16.FixedPoint = true; percentCellType16.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(2, 3).CellType = percentCellType16; this.fpSpread1_Sheet9.Cells.Get(2, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(2, 3).Value = 0.03; this.fpSpread1_Sheet9.Cells.Get(2, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(3, 0).Border = complexBorder81; this.fpSpread1_Sheet9.Cells.Get(3, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(3, 0).Value = "实际贷款年利率"; this.fpSpread1_Sheet9.Cells.Get(3, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(3, 1).Border = complexBorder82; percentCellType17.FixedPoint = true; percentCellType17.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(3, 1).CellType = percentCellType17; this.fpSpread1_Sheet9.Cells.Get(3, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(3, 1).Value = 0.06; this.fpSpread1_Sheet9.Cells.Get(3, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(3, 2).Border = complexBorder83; this.fpSpread1_Sheet9.Cells.Get(3, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(3, 2).Value = "动态投资分额"; this.fpSpread1_Sheet9.Cells.Get(3, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(3, 3).Border = complexBorder84; percentCellType18.FixedPoint = true; percentCellType18.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(3, 3).CellType = percentCellType18; this.fpSpread1_Sheet9.Cells.Get(3, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(3, 3).Value = 0.8; this.fpSpread1_Sheet9.Cells.Get(3, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(4, 0).Border = complexBorder85; this.fpSpread1_Sheet9.Cells.Get(4, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(4, 0).Value = "折旧率"; this.fpSpread1_Sheet9.Cells.Get(4, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(4, 1).Border = complexBorder86; percentCellType19.FixedPoint = true; percentCellType19.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(4, 1).CellType = percentCellType19; this.fpSpread1_Sheet9.Cells.Get(4, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(4, 1).Value = 0.0475; this.fpSpread1_Sheet9.Cells.Get(4, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(4, 2).Border = complexBorder87; this.fpSpread1_Sheet9.Cells.Get(4, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(4, 2).Value = "流动资金比率"; this.fpSpread1_Sheet9.Cells.Get(4, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(4, 3).Border = complexBorder88; percentCellType20.FixedPoint = true; percentCellType20.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(4, 3).CellType = percentCellType20; this.fpSpread1_Sheet9.Cells.Get(4, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(4, 3).Value = 0.01; this.fpSpread1_Sheet9.Cells.Get(4, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(5, 0).Border = complexBorder89; this.fpSpread1_Sheet9.Cells.Get(5, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(5, 0).Value = "固定资产残值"; this.fpSpread1_Sheet9.Cells.Get(5, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(5, 1).Border = complexBorder90; percentCellType21.FixedPoint = true; percentCellType21.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(5, 1).CellType = percentCellType21; this.fpSpread1_Sheet9.Cells.Get(5, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(5, 1).Value = 0.05; this.fpSpread1_Sheet9.Cells.Get(5, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(5, 2).Border = complexBorder91; this.fpSpread1_Sheet9.Cells.Get(5, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(5, 2).Value = "资本金比率"; this.fpSpread1_Sheet9.Cells.Get(5, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(5, 3).Border = complexBorder92; percentCellType22.FixedPoint = true; percentCellType22.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(5, 3).CellType = percentCellType22; this.fpSpread1_Sheet9.Cells.Get(5, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(5, 3).Value = 0.2; this.fpSpread1_Sheet9.Cells.Get(5, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(6, 0).Border = complexBorder93; this.fpSpread1_Sheet9.Cells.Get(6, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(6, 0).Value = "城建及教育附加税"; this.fpSpread1_Sheet9.Cells.Get(6, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(6, 1).Border = complexBorder94; percentCellType23.FixedPoint = true; percentCellType23.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(6, 1).CellType = percentCellType23; this.fpSpread1_Sheet9.Cells.Get(6, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(6, 1).Value = 0.1; this.fpSpread1_Sheet9.Cells.Get(6, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(6, 2).Border = complexBorder95; this.fpSpread1_Sheet9.Cells.Get(6, 2).CellType = generalCellType70; this.fpSpread1_Sheet9.Cells.Get(6, 2).Font = new System.Drawing.Font("宋体", 9F); this.fpSpread1_Sheet9.Cells.Get(6, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(6, 2).Value = "自有资金比率"; this.fpSpread1_Sheet9.Cells.Get(6, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(6, 3).Border = complexBorder96; percentCellType24.FixedPoint = true; percentCellType24.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(6, 3).CellType = percentCellType24; this.fpSpread1_Sheet9.Cells.Get(6, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(6, 3).Value = 0.3; this.fpSpread1_Sheet9.Cells.Get(6, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(7, 0).Border = complexBorder97; this.fpSpread1_Sheet9.Cells.Get(7, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(7, 0).Value = "公积金,公益金率"; this.fpSpread1_Sheet9.Cells.Get(7, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(7, 1).Border = complexBorder98; percentCellType25.FixedPoint = true; percentCellType25.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(7, 1).CellType = percentCellType25; this.fpSpread1_Sheet9.Cells.Get(7, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(7, 1).Value = 0.15; this.fpSpread1_Sheet9.Cells.Get(7, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(7, 2).Border = complexBorder99; this.fpSpread1_Sheet9.Cells.Get(7, 2).CellType = generalCellType71; this.fpSpread1_Sheet9.Cells.Get(7, 2).Font = new System.Drawing.Font("宋体", 9F); this.fpSpread1_Sheet9.Cells.Get(7, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(7, 2).Value = "存贷利率比"; this.fpSpread1_Sheet9.Cells.Get(7, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(7, 3).Border = complexBorder100; percentCellType26.FixedPoint = true; percentCellType26.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(7, 3).CellType = percentCellType26; this.fpSpread1_Sheet9.Cells.Get(7, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(7, 3).Value = 0.5; this.fpSpread1_Sheet9.Cells.Get(7, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(8, 0).Border = complexBorder101; this.fpSpread1_Sheet9.Cells.Get(8, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(8, 0).Value = "所得税率"; this.fpSpread1_Sheet9.Cells.Get(8, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(8, 1).Border = complexBorder102; percentCellType27.FixedPoint = true; percentCellType27.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(8, 1).CellType = percentCellType27; this.fpSpread1_Sheet9.Cells.Get(8, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(8, 1).Value = 0.33; this.fpSpread1_Sheet9.Cells.Get(8, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(8, 2).Border = complexBorder103; this.fpSpread1_Sheet9.Cells.Get(8, 2).CellType = generalCellType72; this.fpSpread1_Sheet9.Cells.Get(8, 2).Font = new System.Drawing.Font("宋体", 9F); this.fpSpread1_Sheet9.Cells.Get(8, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(8, 2).Value = "经营成本"; this.fpSpread1_Sheet9.Cells.Get(8, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(8, 3).Border = complexBorder104; percentCellType28.FixedPoint = true; percentCellType28.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(8, 3).CellType = percentCellType28; this.fpSpread1_Sheet9.Cells.Get(8, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(8, 3).Value = 0.05; this.fpSpread1_Sheet9.Cells.Get(8, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(9, 0).Border = complexBorder105; this.fpSpread1_Sheet9.Cells.Get(9, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(9, 0).Value = "折旧还贷率"; this.fpSpread1_Sheet9.Cells.Get(9, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(9, 1).Border = complexBorder106; percentCellType29.FixedPoint = true; percentCellType29.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(9, 1).CellType = percentCellType29; this.fpSpread1_Sheet9.Cells.Get(9, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(9, 1).Value = 1; this.fpSpread1_Sheet9.Cells.Get(9, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(9, 2).Border = complexBorder107; this.fpSpread1_Sheet9.Cells.Get(9, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(9, 2).Value = "开始建设年度"; this.fpSpread1_Sheet9.Cells.Get(9, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(9, 3).Border = complexBorder108; numberCellType23.DecimalPlaces = 0; numberCellType23.MaximumValue = 999999999; numberCellType23.MinimumValue = -999999900; this.fpSpread1_Sheet9.Cells.Get(9, 3).CellType = numberCellType23; this.fpSpread1_Sheet9.Cells.Get(9, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(9, 3).Value = 0; this.fpSpread1_Sheet9.Cells.Get(9, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(10, 0).Border = complexBorder109; this.fpSpread1_Sheet9.Cells.Get(10, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(10, 0).Value = "股本金分利"; this.fpSpread1_Sheet9.Cells.Get(10, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(10, 1).Border = complexBorder110; percentCellType30.FixedPoint = true; percentCellType30.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(10, 1).CellType = percentCellType30; this.fpSpread1_Sheet9.Cells.Get(10, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(10, 1).Value = 0.057; this.fpSpread1_Sheet9.Cells.Get(10, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(10, 2).Border = complexBorder111; this.fpSpread1_Sheet9.Cells.Get(10, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(10, 2).Value = "建设年限"; this.fpSpread1_Sheet9.Cells.Get(10, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(10, 3).Border = complexBorder112; numberCellType24.DecimalPlaces = 0; numberCellType24.MaximumValue = 9999999; numberCellType24.MinimumValue = -999999900; this.fpSpread1_Sheet9.Cells.Get(10, 3).CellType = numberCellType24; this.fpSpread1_Sheet9.Cells.Get(10, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(10, 3).Value = 0; this.fpSpread1_Sheet9.Cells.Get(10, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(11, 0).Border = complexBorder113; this.fpSpread1_Sheet9.Cells.Get(11, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(11, 0).Value = "城市维护及建设税税率"; this.fpSpread1_Sheet9.Cells.Get(11, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(11, 1).Border = complexBorder114; percentCellType31.FixedPoint = true; percentCellType31.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(11, 1).CellType = percentCellType31; this.fpSpread1_Sheet9.Cells.Get(11, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(11, 1).Value = 0.07; this.fpSpread1_Sheet9.Cells.Get(11, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(11, 2).Border = complexBorder115; this.fpSpread1_Sheet9.Cells.Get(11, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(11, 2).Value = "售电量"; this.fpSpread1_Sheet9.Cells.Get(11, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(11, 3).Border = complexBorder116; textCellType1.CharacterSet = FarPoint.Win.Spread.CellType.CharacterSet.Numeric; textCellType1.MaxLength = 12; this.fpSpread1_Sheet9.Cells.Get(11, 3).CellType = textCellType1; this.fpSpread1_Sheet9.Cells.Get(11, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(11, 3).Value = "0"; this.fpSpread1_Sheet9.Cells.Get(11, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(12, 0).Border = complexBorder117; this.fpSpread1_Sheet9.Cells.Get(12, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(12, 0).Value = "县镇维护及建设税税率"; this.fpSpread1_Sheet9.Cells.Get(12, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(12, 1).Border = complexBorder118; percentCellType32.FixedPoint = true; percentCellType32.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(12, 1).CellType = percentCellType32; this.fpSpread1_Sheet9.Cells.Get(12, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(12, 1).Value = 0.05; this.fpSpread1_Sheet9.Cells.Get(12, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(12, 2).Border = complexBorder119; this.fpSpread1_Sheet9.Cells.Get(12, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(12, 2).Value = "售电率"; this.fpSpread1_Sheet9.Cells.Get(12, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(12, 3).Border = complexBorder120; percentCellType33.FixedPoint = true; percentCellType33.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(12, 3).CellType = percentCellType33; this.fpSpread1_Sheet9.Cells.Get(12, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(12, 3).Value = 0; this.fpSpread1_Sheet9.Cells.Get(13, 0).Border = complexBorder121; this.fpSpread1_Sheet9.Cells.Get(13, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(13, 0).Value = "其它地区维护及建设税税率"; this.fpSpread1_Sheet9.Cells.Get(13, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(13, 1).Border = complexBorder122; percentCellType34.FixedPoint = true; percentCellType34.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(13, 1).CellType = percentCellType34; this.fpSpread1_Sheet9.Cells.Get(13, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(13, 1).Value = 0.01; this.fpSpread1_Sheet9.Cells.Get(13, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(13, 2).Border = complexBorder123; this.fpSpread1_Sheet9.Cells.Get(13, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(13, 2).Value = "项目计算期"; this.fpSpread1_Sheet9.Cells.Get(13, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(13, 3).Border = complexBorder124; numberCellType25.DecimalPlaces = 0; numberCellType25.MaximumValue = 9999999; numberCellType25.MinimumValue = -999999900; this.fpSpread1_Sheet9.Cells.Get(13, 3).CellType = numberCellType25; this.fpSpread1_Sheet9.Cells.Get(13, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(13, 3).Value = 0; this.fpSpread1_Sheet9.Cells.Get(13, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(14, 0).Border = complexBorder125; this.fpSpread1_Sheet9.Cells.Get(14, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(14, 0).Value = "还贷系数"; this.fpSpread1_Sheet9.Cells.Get(14, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(14, 1).Border = complexBorder126; numberCellType26.DecimalPlaces = 0; numberCellType26.MaximumValue = 10000000; numberCellType26.MinimumValue = -10000000; this.fpSpread1_Sheet9.Cells.Get(14, 1).CellType = numberCellType26; this.fpSpread1_Sheet9.Cells.Get(14, 1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(14, 1).Value = 0; this.fpSpread1_Sheet9.Cells.Get(14, 1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(14, 2).Border = complexBorder127; this.fpSpread1_Sheet9.Cells.Get(14, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(14, 2).Value = "银行利率"; this.fpSpread1_Sheet9.Cells.Get(14, 2).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(14, 3).Border = complexBorder128; percentCellType35.FixedPoint = true; percentCellType35.PercentSign = "%"; this.fpSpread1_Sheet9.Cells.Get(14, 3).CellType = percentCellType35; this.fpSpread1_Sheet9.Cells.Get(14, 3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet9.Cells.Get(14, 3).Value = 0.08; this.fpSpread1_Sheet9.Cells.Get(14, 3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; this.fpSpread1_Sheet9.Cells.Get(15, 0).Border = complexBorder129; this.fpSpread1_Sheet9.Cells.Get(15, 0).Value = "投资年度"; this.fpSpread1_Sheet9.Cells.Get(16, 0).Border = complexBorder130; this.fpSpread1_Sheet9.Cells.Get(16, 0).Value = "投资金额"; this.fpSpread1_Sheet9.Cells.Get(17, 0).Border = complexBorder131; this.fpSpread1_Sheet9.Cells.Get(17, 0).Value = "逐年投资比例"; this.fpSpread1_Sheet9.Cells.Get(18, 0).Border = complexBorder132; this.fpSpread1_Sheet9.Cells.Get(18, 0).Value = "增售电量"; this.fpSpread1_Sheet9.Cells.Get(19, 0).Border = complexBorder133; this.fpSpread1_Sheet9.Cells.Get(19, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(19, 0).Value = "线损率"; this.fpSpread1_Sheet9.Cells.Get(19, 1).Border = complexBorder134; this.fpSpread1_Sheet9.Cells.Get(19, 1).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(19, 1).ParseFormatInfo)).PercentDecimalDigits = 1; ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(19, 1).ParseFormatInfo)).PercentGroupSizes = new int[] { 0}; this.fpSpread1_Sheet9.Cells.Get(19, 1).ParseFormatString = "P"; this.fpSpread1_Sheet9.Cells.Get(19, 1).Value = 0.045; this.fpSpread1_Sheet9.Cells.Get(19, 2).Border = complexBorder135; this.fpSpread1_Sheet9.Cells.Get(19, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(19, 2).Value = "维护修理费"; this.fpSpread1_Sheet9.Cells.Get(19, 3).Border = complexBorder136; this.fpSpread1_Sheet9.Cells.Get(19, 3).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(19, 3).ParseFormatInfo)).PercentDecimalDigits = 1; ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(19, 3).ParseFormatInfo)).PercentGroupSizes = new int[] { 0}; this.fpSpread1_Sheet9.Cells.Get(19, 3).ParseFormatString = "P"; this.fpSpread1_Sheet9.Cells.Get(19, 3).Value = 0.025; this.fpSpread1_Sheet9.Cells.Get(20, 0).Border = complexBorder137; this.fpSpread1_Sheet9.Cells.Get(20, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(20, 0).Value = "年人均工资"; this.fpSpread1_Sheet9.Cells.Get(20, 1).Border = complexBorder138; this.fpSpread1_Sheet9.Cells.Get(20, 1).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(20, 1).ParseFormatInfo)).NumberDecimalDigits = 0; ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(20, 1).ParseFormatInfo)).NumberGroupSizes = new int[] { 0}; this.fpSpread1_Sheet9.Cells.Get(20, 1).ParseFormatString = "n"; this.fpSpread1_Sheet9.Cells.Get(20, 1).Value = 50000; this.fpSpread1_Sheet9.Cells.Get(20, 2).Border = complexBorder139; this.fpSpread1_Sheet9.Cells.Get(20, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(20, 2).Value = "保险费率"; this.fpSpread1_Sheet9.Cells.Get(20, 3).Border = complexBorder140; this.fpSpread1_Sheet9.Cells.Get(20, 3).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(20, 3).ParseFormatInfo)).PercentGroupSizes = new int[] { 0}; this.fpSpread1_Sheet9.Cells.Get(20, 3).ParseFormatString = "P"; this.fpSpread1_Sheet9.Cells.Get(20, 3).Value = 0.0025; this.fpSpread1_Sheet9.Cells.Get(21, 0).Border = complexBorder141; this.fpSpread1_Sheet9.Cells.Get(21, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(21, 0).Value = "福利保险系数"; this.fpSpread1_Sheet9.Cells.Get(21, 1).Border = complexBorder142; this.fpSpread1_Sheet9.Cells.Get(21, 1).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(21, 1).ParseFormatInfo)).PercentDecimalDigits = 0; ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(21, 1).ParseFormatInfo)).PercentGroupSizes = new int[] { 0}; this.fpSpread1_Sheet9.Cells.Get(21, 1).ParseFormatString = "P"; this.fpSpread1_Sheet9.Cells.Get(21, 1).Value = 0.53; this.fpSpread1_Sheet9.Cells.Get(21, 2).Border = complexBorder143; this.fpSpread1_Sheet9.Cells.Get(21, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(21, 2).Value = "其他费用"; this.fpSpread1_Sheet9.Cells.Get(21, 3).Border = complexBorder144; this.fpSpread1_Sheet9.Cells.Get(21, 3).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(21, 3).ParseFormatInfo)).PercentDecimalDigits = 0; ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(21, 3).ParseFormatInfo)).PercentGroupSizes = new int[] { 0}; this.fpSpread1_Sheet9.Cells.Get(21, 3).ParseFormatString = "P"; this.fpSpread1_Sheet9.Cells.Get(21, 3).Value = 0.02; this.fpSpread1_Sheet9.Cells.Get(22, 0).Border = complexBorder145; this.fpSpread1_Sheet9.Cells.Get(22, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(22, 0).Value = "材料费"; this.fpSpread1_Sheet9.Cells.Get(22, 1).Border = complexBorder146; this.fpSpread1_Sheet9.Cells.Get(22, 1).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(22, 1).ParseFormatInfo)).PercentDecimalDigits = 0; ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(22, 1).ParseFormatInfo)).PercentGroupSizes = new int[] { 0}; this.fpSpread1_Sheet9.Cells.Get(22, 1).ParseFormatString = "P"; this.fpSpread1_Sheet9.Cells.Get(22, 1).Value = 0.02; this.fpSpread1_Sheet9.Cells.Get(22, 2).Border = complexBorder147; this.fpSpread1_Sheet9.Cells.Get(22, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(22, 2).Value = "内部收益率"; this.fpSpread1_Sheet9.Cells.Get(22, 3).Border = complexBorder148; this.fpSpread1_Sheet9.Cells.Get(22, 3).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(22, 3).ParseFormatInfo)).PercentDecimalDigits = 0; ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(22, 3).ParseFormatInfo)).PercentGroupSizes = new int[] { 0}; this.fpSpread1_Sheet9.Cells.Get(22, 3).ParseFormatString = "P"; this.fpSpread1_Sheet9.Cells.Get(22, 3).Value = 0.07; this.fpSpread1_Sheet9.Cells.Get(23, 0).Border = complexBorder149; this.fpSpread1_Sheet9.Cells.Get(23, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(23, 0).Value = "定员"; this.fpSpread1_Sheet9.Cells.Get(23, 1).Border = complexBorder150; this.fpSpread1_Sheet9.Cells.Get(23, 1).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(23, 1).ParseFormatInfo)).NumberDecimalDigits = 0; ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(23, 1).ParseFormatInfo)).NumberGroupSizes = new int[] { 0}; this.fpSpread1_Sheet9.Cells.Get(23, 1).ParseFormatString = "n"; this.fpSpread1_Sheet9.Cells.Get(23, 1).Value = 485; this.fpSpread1_Sheet9.Cells.Get(23, 2).Border = complexBorder151; this.fpSpread1_Sheet9.Cells.Get(23, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; this.fpSpread1_Sheet9.Cells.Get(23, 2).Value = "购电价"; this.fpSpread1_Sheet9.Cells.Get(23, 3).Border = complexBorder152; this.fpSpread1_Sheet9.Cells.Get(23, 3).ParseFormatInfo = ((System.Globalization.NumberFormatInfo)(cultureInfo.NumberFormat.Clone())); ((System.Globalization.NumberFormatInfo)(this.fpSpread1_Sheet9.Cells.Get(23, 3).ParseFormatInfo)).NumberGroupSizes = new int[] { 0}; this.fpSpread1_Sheet9.Cells.Get(23, 3).ParseFormatString = "N"; this.fpSpread1_Sheet9.Cells.Get(23, 3).Value = 338.12; this.fpSpread1_Sheet9.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Numbers; this.fpSpread1_Sheet9.Columns.Default.Width = 64F; this.fpSpread1_Sheet9.Columns.Get(0).Width = 202F; this.fpSpread1_Sheet9.Columns.Get(1).Width = 128F; this.fpSpread1_Sheet9.Columns.Get(2).Width = 129F; this.fpSpread1_Sheet9.Columns.Get(3).Width = 109F; this.fpSpread1_Sheet9.DefaultStyleName = "Excel-0-15"; this.fpSpread1_Sheet9.RowHeader.Columns.Default.Resizable = false; this.fpSpread1_Sheet9.CellChanged += new FarPoint.Win.Spread.SheetViewEventHandler(this.fpSpread1_Sheet9_CellChanged); // // barManager1 // this.barManager1.AllowCustomization = false; this.barManager1.AllowMoveBarOnToolbar = false; this.barManager1.AllowQuickCustomization = false; this.barManager1.AllowShowToolbarsPopup = false; this.barManager1.Bars.AddRange(new DevExpress.XtraBars.Bar[] { this.bar1}); this.barManager1.DockControls.Add(this.barDockControlTop); this.barManager1.DockControls.Add(this.barDockControlBottom); this.barManager1.DockControls.Add(this.barDockControlLeft); this.barManager1.DockControls.Add(this.barDockControlRight); this.barManager1.Form = this; this.barManager1.Images = this.imageList1; this.barManager1.Items.AddRange(new DevExpress.XtraBars.BarItem[] { this.barButtonItem1, this.barClose, this.barList, this.barAdditem, this.barAdd1item, this.barEdititem, this.barDelitem, this.barButtonItem2, this.barPrint, this.barCS, this.barSave, this.barButtonItem3, this.barButtonItem5, this.barButtonItem4}); this.barManager1.MaxItemId = 27; this.barManager1.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { this.repositoryItemComboBox1}); // // bar1 // this.bar1.BarName = "Custom 1"; this.bar1.DockCol = 0; this.bar1.DockRow = 0; this.bar1.DockStyle = DevExpress.XtraBars.BarDockStyle.Top; this.bar1.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] { new DevExpress.XtraBars.LinkPersistInfo(DevExpress.XtraBars.BarLinkUserDefines.PaintStyle, this.barList, DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph), new DevExpress.XtraBars.LinkPersistInfo(this.barButtonItem4), new DevExpress.XtraBars.LinkPersistInfo(this.barCS), new DevExpress.XtraBars.LinkPersistInfo(this.barSave), new DevExpress.XtraBars.LinkPersistInfo(this.barButtonItem3), new DevExpress.XtraBars.LinkPersistInfo(this.barButtonItem5), new DevExpress.XtraBars.LinkPersistInfo(this.barPrint), new DevExpress.XtraBars.LinkPersistInfo(this.barClose)}); this.bar1.OptionsBar.AllowQuickCustomization = false; this.bar1.OptionsBar.DrawDragBorder = false; this.bar1.OptionsBar.RotateWhenVertical = false; this.bar1.Text = "Custom 1"; // // barList // this.barList.Caption = "目录维护"; this.barList.Id = 12; this.barList.ImageIndex = 27; this.barList.LinksPersistInfo.AddRange(new DevExpress.XtraBars.LinkPersistInfo[] { new DevExpress.XtraBars.LinkPersistInfo(this.barAdditem), new DevExpress.XtraBars.LinkPersistInfo(this.barAdd1item), new DevExpress.XtraBars.LinkPersistInfo(this.barEdititem), new DevExpress.XtraBars.LinkPersistInfo(this.barDelitem)}); this.barList.Name = "barList"; // // barAdditem // this.barAdditem.Caption = "添加目录"; this.barAdditem.Id = 13; this.barAdditem.ImageIndex = 2; this.barAdditem.Name = "barAdditem"; this.barAdditem.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barAdditem_ItemClick); // // barAdd1item // this.barAdd1item.Caption = "添加子目录"; this.barAdd1item.Id = 14; this.barAdd1item.ImageIndex = 1; this.barAdd1item.Name = "barAdd1item"; this.barAdd1item.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; this.barAdd1item.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barAdd1item_ItemClick); // // barEdititem // this.barEdititem.Caption = "修改目录"; this.barEdititem.Id = 15; this.barEdititem.ImageIndex = 26; this.barEdititem.Name = "barEdititem"; this.barEdititem.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barEdititem_ItemClick); // // barDelitem // this.barDelitem.Caption = "删除目录"; this.barDelitem.Id = 16; this.barDelitem.ImageIndex = 3; this.barDelitem.Name = "barDelitem"; this.barDelitem.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barDelitem_ItemClick); // // barButtonItem4 // this.barButtonItem4.Caption = "打开"; this.barButtonItem4.Id = 26; this.barButtonItem4.ImageIndex = 24; this.barButtonItem4.Name = "barButtonItem4"; this.barButtonItem4.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph; this.barButtonItem4.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; this.barButtonItem4.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItem4_ItemClick); // // barCS // this.barCS.Caption = "参数设置"; this.barCS.Id = 21; this.barCS.ImageIndex = 8; this.barCS.Name = "barCS"; this.barCS.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph; this.barCS.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barCS_ItemClick); // // barSave // this.barSave.Caption = "保存"; this.barSave.Id = 22; this.barSave.ImageIndex = 9; this.barSave.Name = "barSave"; this.barSave.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph; this.barSave.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barSave_ItemClick); // // barButtonItem3 // this.barButtonItem3.Caption = "保存模板"; this.barButtonItem3.Id = 23; this.barButtonItem3.Name = "barButtonItem3"; this.barButtonItem3.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItem3_ItemClick); // // barButtonItem5 // this.barButtonItem5.Caption = "导出Excel"; this.barButtonItem5.Id = 25; this.barButtonItem5.ImageIndex = 17; this.barButtonItem5.Name = "barButtonItem5"; this.barButtonItem5.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph; this.barButtonItem5.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barButtonItem5_ItemClick); // // barPrint // this.barPrint.Caption = "选择"; this.barPrint.Id = 19; this.barPrint.ImageIndex = 28; this.barPrint.Name = "barPrint"; this.barPrint.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph; this.barPrint.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barPrint_ItemClick); // // barClose // this.barClose.Caption = "关闭"; this.barClose.Id = 5; this.barClose.ImageIndex = 30; this.barClose.Name = "barClose"; this.barClose.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph; this.barClose.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barClose_ItemClick); // // imageList1 // this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream"))); this.imageList1.TransparentColor = System.Drawing.Color.Transparent; this.imageList1.Images.SetKeyName(0, "新建.ico"); this.imageList1.Images.SetKeyName(1, "添加下级.ico"); this.imageList1.Images.SetKeyName(2, "添加同级.ico"); this.imageList1.Images.SetKeyName(3, "删除.ico"); this.imageList1.Images.SetKeyName(4, "关闭.ico"); this.imageList1.Images.SetKeyName(5, "修改.ico"); this.imageList1.Images.SetKeyName(6, "打印.ico"); this.imageList1.Images.SetKeyName(7, "新建.ico"); this.imageList1.Images.SetKeyName(8, "发送.ico"); this.imageList1.Images.SetKeyName(9, "保存.ico"); this.imageList1.Images.SetKeyName(10, "审批.ico"); this.imageList1.Images.SetKeyName(11, "新建.ico"); this.imageList1.Images.SetKeyName(12, "修改.ico"); this.imageList1.Images.SetKeyName(13, "关闭.ico"); this.imageList1.Images.SetKeyName(14, "打印.ico"); this.imageList1.Images.SetKeyName(15, "三等功发1.ico"); this.imageList1.Images.SetKeyName(16, "审核.ico"); this.imageList1.Images.SetKeyName(17, "35.ico"); this.imageList1.Images.SetKeyName(18, "布局.ico"); this.imageList1.Images.SetKeyName(19, "审批.ico"); this.imageList1.Images.SetKeyName(20, "关闭.ico"); this.imageList1.Images.SetKeyName(21, "修改.ico"); this.imageList1.Images.SetKeyName(22, "新建.ico"); this.imageList1.Images.SetKeyName(23, "查询.ico"); this.imageList1.Images.SetKeyName(24, "审核.ico"); this.imageList1.Images.SetKeyName(25, "作废.ico"); this.imageList1.Images.SetKeyName(26, "修改.ico"); this.imageList1.Images.SetKeyName(27, "新建.ico"); this.imageList1.Images.SetKeyName(28, "审批.ico"); this.imageList1.Images.SetKeyName(29, "三等功发1.ico"); this.imageList1.Images.SetKeyName(30, "关闭.ico"); this.imageList1.Images.SetKeyName(31, "打回重新编.ico"); this.imageList1.Images.SetKeyName(32, "books.ico"); // // barButtonItem1 // this.barButtonItem1.Caption = "barButtonItem1"; this.barButtonItem1.Id = 0; this.barButtonItem1.Name = "barButtonItem1"; // // barButtonItem2 // this.barButtonItem2.Caption = "添加文字资料"; this.barButtonItem2.Id = 17; this.barButtonItem2.Name = "barButtonItem2"; // // repositoryItemComboBox1 // this.repositoryItemComboBox1.AutoHeight = false; this.repositoryItemComboBox1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)}); this.repositoryItemComboBox1.Name = "repositoryItemComboBox1"; // // FrmEconomyAnalysis // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(822, 487); this.Controls.Add(this.splitContainerControl1); this.Controls.Add(this.barDockControlLeft); this.Controls.Add(this.barDockControlRight); this.Controls.Add(this.barDockControlBottom); this.Controls.Add(this.barDockControlTop); this.Name = "FrmEconomyAnalysis"; this.Text = "经济分析"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.FrmLayoutContents_Load); this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.FrmEconomyAnalysis_FormClosing); ((System.ComponentModel.ISupportInitialize)(this.splitContainerControl1)).EndInit(); this.splitContainerControl1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.treeList1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.ChapterNameTextEdit)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.RemarkMemoExEdit)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet6)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet7)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet8)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet9)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.barManager1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.repositoryItemComboBox1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// ��������������֮��İٷֱȣ������������״3-8�еİٷֱ� /// </summary> /// <param name="obj_sheet"></param> /// <param name="startrow">��ٷֱȵ��к�</param> /// <param name="startcol">��ٷֱȵ��к�</param> /// <param name="items">��Ŀ��</param> /// <param name="length">ÿ����Ŀ����</param> /// <param name="writerow">д�빫ʽ�к�</param> /// <param name="writecol">д�빫ʽ�к�</param> public void Sheet_WriteFormula_TwoCol_Percent(FarPoint.Win.Spread.SheetView obj_sheet, int startrow, int startcol, int items, int length, int writerow, int writecol) { FarPoint.Win.Spread.CellType.PercentCellType pct = new FarPoint.Win.Spread.CellType.PercentCellType(); for (int i = 0; i < items; i++) { string SumFormula = ""; //������� for (int j = 0; j < length; j++) { SumFormula += "," + "R" + (startrow + i * length + j + 1) + "C" + (startcol + 1); } SumFormula = "SUM(" + SumFormula.Substring(1, SumFormula.Length - 1) + ")"; //��д���� for (int k = 0; k < length; k++) { obj_sheet.Cells[writerow + i * length + k, writecol].Formula = "R" + (startrow + i * length + k + 1) + "C" + (startcol + 1) + "/" + SumFormula; obj_sheet.Cells[writerow + i * length + k, writecol].CellType = pct; } } }
/// <summary> /// ��������Ҫ����д������ʽ������������ռ�����ٷֱ����,���������״3-6�� /// </summary> /// <param name="obj_sheet"></param> /// <param name="yrow">�����к�</param> /// <param name="ycol">�����к�</param> /// <param name="span">�������(0��ʾ���)</param> /// <param name="wrow">д�빫ʽ��</param> /// <param name="wcol">д�빫ʽ��</param> /// <param name="itemcout">����Ŀ��</param> /// <param name="colcount">���ж�����Ҫд</param> /// <param name="perentrow">�����кţ��̶�����һ�У�</param> public void Sheet_WriteFormula_Percent_Row(FarPoint.Win.Spread.SheetView obj_sheet, int yrow, int ycol, int span, int wrow, int wcol, int itemcout, int colcount, int perentrow) { FarPoint.Win.Spread.CellType.PercentCellType pct = new FarPoint.Win.Spread.CellType.PercentCellType(); for (int i = 0; i < itemcout; i++) { for (int j = 0; j < colcount; j++) { obj_sheet.Cells[wrow + i * (span + 1), wcol + j].Formula = "R" + (yrow + i * (span + 1) + 1) + "C" + (ycol + j + 1) + "/" + "R" + (perentrow + 1) + "C" + (ycol + j + 1); obj_sheet.Cells[wrow + i * (span + 1), wcol + j].CellType = pct; } } }
/// <summary> /// ���������������������one/(two-three) /// </summary> /// <param name="obj_sheet"></param> /// <param name="onerow"></param> /// <param name="onecol"></param> /// <param name="twocol"></param> /// <param name="threecol"></param> /// <param name="writecol"></param> /// <param name="rowcount"></param> public void Sheet_WriteFormula_OneCol_Twocol_Threecol_percent(FarPoint.Win.Spread.SheetView obj_sheet, int onerow, int onecol, int twocol, int threecol, int writecol, int rowcount) { FarPoint.Win.Spread.CellType.PercentCellType pct = new FarPoint.Win.Spread.CellType.PercentCellType(); for (int row = 0; row < rowcount; row++) { obj_sheet.Cells[onerow + row, writecol].Formula = "R" + (onerow + row + 1) + "C" + (onecol + 1) + "/(R" + (onerow + row + 1) + "C" + (twocol + 1) + "-R" + (onerow + row + 1) + "C" + (threecol + 1) + ")"; obj_sheet.Cells[onerow + row, writecol].CellType = pct; } }
/// <summary> /// ����������д�뼸��ƽ�������� (lastColnum/baseColnum)^1/num-1 /// </summary> /// <param name="obj_sheet"></param> /// <param name="baseColnum">������</param> /// <param name="lastColnum">������</param> /// <param name="num">ƽ�������������У�</param> /// <param name="writerow">д����</param> /// <param name="writecol">д����</param> /// <param name="RowCount">ͳ����</param> /// <param name="DecimalPlaces">С��λ��</param> /// <param name="Present">�Ƿ���ʾ�ٷֱ�����</param> public void Sheet_WriteFormula_RowAveInsering(FarPoint.Win.Spread.SheetView obj_sheet, int baseColnum, int lastColnum, int num, int writerow, int writecol, int RowCount, int DecimalPlaces, bool Present) { FarPoint.Win.Spread.CellType.PercentCellType percelltype = new FarPoint.Win.Spread.CellType.PercentCellType(); percelltype.DecimalPlaces = DecimalPlaces; FarPoint.Win.Spread.CellType.NumberCellType numcelltype = new FarPoint.Win.Spread.CellType.NumberCellType(); numcelltype.DecimalPlaces = DecimalPlaces; for (int i = 0; i < RowCount; i++) { obj_sheet.Cells[writerow + i, writecol].Formula = " Power(R" + (writerow + i + 1) + "C" + (1 + lastColnum) + "/R" + (writerow + i + 1) + "C" + (baseColnum + 1) + "," + (1.000 / num) + ")-1"; if (Present) { obj_sheet.Cells[writerow + i, writecol].CellType = percelltype; } else { obj_sheet.Cells[writerow + i, writecol].CellType = numcelltype; } } }
/// <summary> /// �����������趨��Ԫ���ʽ /// </summary> /// <param name="obj_sheet"></param> /// <param name="row">��</param> /// <param name="col">��</param> /// <param name="Type">����1Ϊnumber��2ΪPrsent</param> /// <param name="DecimalPlaces"></param> public void SetSheetCellType(FarPoint.Win.Spread.SheetView obj_sheet, int row, int col, int Type, int DecimalPlaces) { FarPoint.Win.Spread.CellType.PercentCellType percelltype = new FarPoint.Win.Spread.CellType.PercentCellType(); percelltype.DecimalPlaces = DecimalPlaces; FarPoint.Win.Spread.CellType.NumberCellType numcelltype = new FarPoint.Win.Spread.CellType.NumberCellType(); numcelltype.DecimalPlaces = DecimalPlaces; if (Type == 1) { obj_sheet.Cells[row, col].CellType = numcelltype; } else if (Type == 2) { obj_sheet.Cells[row, col].CellType = percelltype; } }