public void DeleteFormatComments_M3(int sldnum) { int numComments = ActivePPT.Slides[sldnum].Comments.Count; PowerPoint.Comment myComment = null; try { if (numComments > 0) { for (int i = numComments; i >= 1; i--) { myComment = ActivePPT.Slides[sldnum].Comments[i]; if (myComment.AuthorInitials == "TFR") { myComment.Delete(); } } // --- } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "DeleteFormatComments_M3"); } }
public string SelectedShapeNumber(int sldNum, PowerPoint.Shape selShape) { string selshpname = null; try { string selShpName = selShape.Name; float selShpWd = selShape.Width; float selShpHt = selShape.Height; float selShpLf = selShape.Left; float selShpTp = selShape.Top; for (int sn = 1; sn <= ActivePPT.Slides[sldNum].Shapes.Count; sn++) { string tempShpName = ActivePPT.Slides[sldNum].Shapes[sn].Name; float tempShpWd = ActivePPT.Slides[sldNum].Shapes[sn].Width; float tempShpHt = ActivePPT.Slides[sldNum].Shapes[sn].Height; float tempShpLf = ActivePPT.Slides[sldNum].Shapes[sn].Left; float tempShpTp = ActivePPT.Slides[sldNum].Shapes[sn].Top; if (tempShpName == selShpName && tempShpWd == selShpWd && tempShpHt == selShpHt && tempShpLf == selShpLf && tempShpTp == selShpTp) { selshpname = ActivePPT.Slides[sldNum].Shapes[sn].Name; break; } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "SelectedShapeNumber"); } return(selshpname); }
public MsoTriState getMsoTriState(int dbVal) { //int dbVal = Convert.ToInt32(dt.Rows[0]["FillVisible"]); try { if (dbVal == 1) { objValue = MsoTriState.msoCTrue; } else if (dbVal == 0) { objValue = MsoTriState.msoFalse; } else if (dbVal == -2) { objValue = MsoTriState.msoTriStateMixed; } else if (dbVal == -3) { objValue = MsoTriState.msoTriStateToggle; } else if (dbVal == -1) { objValue = MsoTriState.msoTrue; } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "getMsoTriState"); } return(objValue); }
public void Format_XGrids(PowerPoint.Chart myChart, bool hasXGrids, string chType) { try { if (chType == "Pie" || chType == "Doughnut") { if (hasXGrids == true) { if (myChart.Axes(XlAxisType.xlCategory).HasMajorGridlines == true) { myChart.Axes(XlAxisType.xlCategory).MajorGridlines.Border.Color = System.Drawing.Color.FromArgb(127, 127, 127).ToArgb(); myChart.Axes(XlAxisType.xlCategory).MajorGridlines.Border.LineStyle = PowerPoint.XlLineStyle.xlDot; } } else if (hasXGrids == false) { myChart.HasAxis[XlAxisType.xlCategory] = false; } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "Format_XGrids"); } }
public void CreateBullet(int sldNum, string shpname) { try { PowerPoint.TextRange txtRng = ActivePPT.Slides[sldNum].Shapes[shpname].TextFrame.TextRange; float indentVal = (float)0.64; var paragraphs = txtRng.Paragraphs(-1, -1); for (int index = 1; index <= txtRng.Paragraphs().Count; index++) { //string paraText = txtRng.Paragraphs(index).Text; txtRng.Paragraphs(index).IndentLevel = index; txtRng.Paragraphs(index).ParagraphFormat.Alignment = PowerPoint.PpParagraphAlignment.ppAlignLeft; txtRng.Paragraphs(index).ParagraphFormat.HangingPunctuation = MsoTriState.msoTrue; txtRng.Paragraphs(index).ParagraphFormat.SpaceBefore = 6; txtRng.Paragraphs(index).ParagraphFormat.SpaceAfter = 0; txtRng.Paragraphs(index).ParagraphFormat.SpaceWithin = (float)0.85; txtRng.Paragraphs(index).Parent.Ruler.Levels[index].FirstMargin = indentVal;//18 * (index - 1); txtRng.Paragraphs(index).Parent.Ruler.Levels[index].LeftMargin = 18 * (index); indentVal = indentVal + (float)0.47; } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "CreateBullet"); } }
// -- Main method to correct Each shapes format public void CorrectFormat_Selected(int sldNum, string shpName) { try { PowerPoint.Presentation ActivePPT = ppApp.ActivePresentation; CorrectFormat_ShapeInSlide(sldNum, shpName); if (ActivePPT.Slides[sldNum].CustomLayout.Name == "Title Slide") { CorrectFormat_TitleSlide(sldNum, shpName); } else if (ActivePPT.Slides[sldNum].CustomLayout.Name == "Content Slide") { CorrectFormat_ContentSlide(sldNum, shpName); } else if (ActivePPT.Slides[sldNum].CustomLayout.Name == "Divider Slide") { CorrectFormat_DividerSlide(sldNum, shpName); } else { CorrectFormat_MainSlide(sldNum, shpName); } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "CorrectFormat_Selected"); } }
public void SetNamesUnique(int sldNum) { int shpCount = ActivePPT.Slides[sldNum].Shapes.Count; try { for (int i = 1; i <= shpCount; i++) { PowerPoint.Shape osh = ActivePPT.Slides[sldNum].Shapes[i]; if (osh.Type == MsoShapeType.msoGroup) { for (int x = 1; x <= osh.GroupItems.Count; x++) { string shpName = osh.GroupItems[x].Name; ChangeNames(sldNum, shpName, x); } } else { string shpName = osh.Name; ChangeNames(sldNum, shpName, i); } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "SetNamesUnique"); } }
//'This function formats the y-grids line style, tick marks, title and ticklables font name, style, size, color, sub-super script, underline public void Format_YGrids(PowerPoint.Chart myChart, bool hasYAxis, string chType, bool ch3D) { try { bool hasYGrids = false; if (chType == "Pie" || chType == "Doughnut") { return; } if (chType == "Radar" || (hasYAxis && ch3D == true)) { hasYGrids = true; } if (hasYGrids == true) { myChart.Axes(XlAxisType.xlValue).HasMajorGridlines = true; myChart.Axes(XlAxisType.xlValue).MajorGridlines.Border.Color = System.Drawing.Color.FromArgb(127, 127, 127).ToArgb(); myChart.Axes(XlAxisType.xlValue).MajorGridlines.Border.LineStyle = PowerPoint.XlLineStyle.xlContinuous; } else if (hasYGrids == false) { myChart.Axes(XlAxisType.xlValue).HasMajorGridlines = false; } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "Format_YGrids"); } }
public PowerPoint.PpChangeCase txtChangeCase(int dbVal) { try { if (dbVal == 2) { objValue4 = PowerPoint.PpChangeCase.ppCaseLower; } else if (dbVal == 1) { objValue4 = PowerPoint.PpChangeCase.ppCaseSentence; } else if (dbVal == 4) { objValue4 = PowerPoint.PpChangeCase.ppCaseTitle; } else if (dbVal == 5) { objValue4 = PowerPoint.PpChangeCase.ppCaseToggle; } else if (dbVal == 3) { objValue4 = PowerPoint.PpChangeCase.ppCaseUpper; } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "txtChangeCase"); } return(objValue4); }
private void cmb_stDate_SelectedIndexChanged(object sender, EventArgs e) { try { int l = cmb_stDate.SelectedIndex; cmb_endDate.Items.Clear(); for (int i = l; i < num_points; i++) { string xx = Regex.Match(chtData[i, 0], @"\d+").Value; cmb_endDate.Items.Add(xx); } cmb_endDate.SelectedIndex = cmb_endDate.Items.Count - 1; //Calculate_CAGR(); string cmbText = cmb_calcType.Text; if (cmbText == "AAGR") { Calculate_AAGR(); } else { Calculate_CAGR(); } } catch (Exception err) { this.Close(); string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "cmb_stDate_SelectedIndexChanged"); MessageBox.Show("Check chart type and chart value", PPTAttribute.msgTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void DeleteFormatComments_M1(int sldNum) { int numComments = ActivePPT.Slides[sldNum].Comments.Count; try { if (numComments > 0) { for (int xx = numComments; xx >= 1; xx--) { PowerPoint.Comment myComment = ActivePPT.Slides[sldNum].Comments[xx]; if (myComment.AuthorInitials == "TFR") //if (myComment.Author == shpName + " Error" && myComment.AuthorInitials == "TFR") { myComment.Delete(); // break; } } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "DeleteFormatComments_M1"); } }
public void ChangeNames(int sldNum, string shpName, int index) { try { for (int j = 1; j <= ActivePPT.Slides[sldNum].Shapes.Count; j++) { PowerPoint.Shape osh1 = ActivePPT.Slides[sldNum].Shapes[j]; if (osh1.Type == MsoShapeType.msoGroup) { for (int y = 1; y <= osh1.GroupItems.Count; y++) { string tName = osh1.GroupItems[y].Name; if (tName == shpName && y != index) { osh1.GroupItems[y].Name = osh1.GroupItems[y].Name + "_C"; } } } else { string tName = osh1.Name; if (tName == shpName && j != index) { osh1.Name = osh1.Name + "_C"; } } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "ChangeNames"); } }
public PowerPoint.PpBulletType getPpBulletType(int dbVal) { try { if (dbVal == 1) { objValue5 = PowerPoint.PpBulletType.ppBulletUnnumbered; } else if (dbVal == -2) { objValue5 = PowerPoint.PpBulletType.ppBulletMixed; } else if (dbVal == 0) { objValue5 = PowerPoint.PpBulletType.ppBulletNone; } else if (dbVal == 2) { objValue5 = PowerPoint.PpBulletType.ppBulletNumbered; } else if (dbVal == 3) { objValue5 = PowerPoint.PpBulletType.ppBulletPicture; } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "getPpBulletType"); } return(objValue5); }
public static void saveSpacification(StringBuilder str, string shpName) { try { string newPath = logfile + @"TheSmartCube\Log\"; string path = newPath + "Spacification_" + shpName + ".txt"; if (!File.Exists(path)) { using (StreamWriter sw = File.CreateText(path)) { sw.WriteLine(str); sw.Close(); } } else if (File.Exists(path)) { using (StreamWriter sw = File.AppendText(path)) { sw.WriteLine(str); sw.Close(); } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "saveSpacification"); } }
public void Format_Series(PowerPoint.Chart myChart, bool hasYAxis, string chType) { try { //bool secAxis = false; PowerPoint.SeriesCollection sc = myChart.SeriesCollection(); if (chType == "Pie" || chType == "Doughnut" || chType == "Surface") { return; } if (chType == "Column") { for (int i = 1; i <= sc.Count; i++) { PowerPoint.Series chartSeries = myChart.SeriesCollection(i); myChart.SeriesCollection(i).Format.Line.Visible = MsoTriState.msoTrue; myChart.SeriesCollection(i).Format.Line.ForeColor.RGB = System.Drawing.Color.FromArgb(255, 255, 255).ToArgb(); chartSeries.Format.Line.Weight = (float)0.75; } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "Format_PlotArea"); } }
public void CorrectFormat_DividerSlide(int sldNum, string shpName) { try { PowerPoint.Shape shp = ActivePPT.Slides[sldNum].Shapes[shpName]; if (shp.Type == MsoShapeType.msoAutoShape || shp.Type == MsoShapeType.msoPlaceholder || shp.Type == MsoShapeType.msoTextBox) { if (shp.HasTextFrame == MsoTriState.msoTrue) { DataTable dt1 = actionObj.get_specification("Section Title"); string STitle = chkObj.CheckIfBoxAlreadyExist1(sldNum, dt1); DataTable dt2 = actionObj.get_specification("Section Content"); string SContent = chkObj.CheckIfBoxAlreadyExist1(sldNum, dt2); if (shpName == STitle && dt1.Rows.Count != 0) { FormatShape(sldNum, shpName, dt1, false); } else if (shpName == SContent && dt2.Rows.Count != 0) { FormatShape(sldNum, shpName, dt2, false); } } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "CorrectFormat_DividerSlide"); } }
public static void ErrorLog(string ErrDis, string rib) { String strUserName; String strWholeText; try { PowerPoint.Presentation ActivePPT = Globals.ThisAddIn.Application.ActivePresentation; string newPath; if (!Directory.Exists(logfile + @"TheSmartCube\Log\")) { newPath = logfile + @"TheSmartCube\Log\"; } else { newPath = logfile + @"TheSmartCube\Log\"; } System.IO.Directory.CreateDirectory(newPath); string path = newPath + "ErrorLog_" + DateTime.Now.ToString("ddMMyyyy") + ".txt"; strUserName = Environment.UserName; if (rib.Length <= 12) { return; } if (getButtonDiscription(rib) != null) { strWholeText = strUserName + "|" + getButtonDiscription(rib) + "|" + ErrDis + "|" + DateTime.Now.ToString() + "|" + ActivePPT.Name; } else { strWholeText = strUserName + "|" + rib + "|" + ErrDis + "|" + DateTime.Now.ToString() + "|" + ActivePPT.Name; } if (!File.Exists(path)) { //File.Create(path); using (StreamWriter sw = File.CreateText(path)) { sw.WriteLine(strWholeText); sw.Close(); } } else if (File.Exists(path)) { using (StreamWriter sw = File.AppendText(path)) { sw.WriteLine(strWholeText); sw.Close(); } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "ErrorLog"); } }
public bool chart3D(PowerPoint.Chart myChart) { bool chart3dVal = false; try { if (myChart.ChartType == XlChartType.xl3DBarClustered || myChart.ChartType == XlChartType.xl3DBarStacked || myChart.ChartType == XlChartType.xl3DBarStacked100 || myChart.ChartType == XlChartType.xlCylinderBarClustered || myChart.ChartType == XlChartType.xlCylinderBarStacked || myChart.ChartType == XlChartType.xlCylinderBarStacked100 || myChart.ChartType == XlChartType.xlConeBarClustered || myChart.ChartType == XlChartType.xlConeBarStacked || myChart.ChartType == XlChartType.xlConeBarStacked100 || myChart.ChartType == XlChartType.xlPyramidBarClustered || myChart.ChartType == XlChartType.xlPyramidBarStacked || myChart.ChartType == XlChartType.xlPyramidBarStacked100) { chart3dVal = true; } else if (myChart.ChartType == XlChartType.xl3DColumnClustered || myChart.ChartType == XlChartType.xl3DColumnStacked || myChart.ChartType == XlChartType.xl3DColumnStacked100 || myChart.ChartType == XlChartType.xlCylinderColClustered || myChart.ChartType == XlChartType.xlCylinderColStacked || myChart.ChartType == XlChartType.xlCylinderColStacked100 || myChart.ChartType == XlChartType.xlConeColClustered || myChart.ChartType == XlChartType.xlConeColStacked || myChart.ChartType == XlChartType.xlConeColStacked100 || myChart.ChartType == XlChartType.xlPyramidColClustered || myChart.ChartType == XlChartType.xlPyramidColStacked || myChart.ChartType == XlChartType.xlPyramidColStacked100 || myChart.ChartType == XlChartType.xl3DColumn || myChart.ChartType == XlChartType.xlConeCol || myChart.ChartType == XlChartType.xlCylinderCol || myChart.ChartType == XlChartType.xlPyramidCol) { chart3dVal = true; } else if (myChart.ChartType == XlChartType.xl3DLine) { chart3dVal = true; } else if (myChart.ChartType == XlChartType.xl3DPie || myChart.ChartType == XlChartType.xl3DPieExploded) { chart3dVal = true; } else if (myChart.ChartType == XlChartType.xl3DArea || myChart.ChartType == XlChartType.xl3DAreaStacked || myChart.ChartType == XlChartType.xl3DAreaStacked100) { chart3dVal = true; } else if (myChart.ChartType == XlChartType.xlBubble3DEffect) { chart3dVal = true; } else if (myChart.ChartType == XlChartType.xlSurface || myChart.ChartType == XlChartType.xlSurfaceWireframe) { chart3dVal = true; } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "chart3D"); } return(chart3dVal); }
// Function chekc if shape allready exist the return shape name public string CheckIfBoxAlreadyExist1(int sldIndex, DataTable dt) { int boxNum = 0; String returnValue = null; try { string shpName = Convert.ToString(dt.Rows[0]["Name"]); float shpLeft = (float)Convert.ToDecimal((dt.Rows[0]["ShapeLeft"])); float shpTop = (float)Convert.ToDecimal((dt.Rows[0]["ShapeTop"])); float shpWidth = (float)Convert.ToDecimal((dt.Rows[0]["ShapeWidth"])); float shpHeight = (float)Convert.ToDecimal((dt.Rows[0]["ShapeHeight"])); int shpCount = ActivePPT.Slides[sldIndex].Shapes.Count; int cnt = 0; foreach (PowerPoint.Shape shp in ActivePPT.Slides[sldIndex].Shapes) { if (shp.Name == shpName) { cnt++; } } if (cnt == 0) { boxNum = FindWhenNoBox(sldIndex, shpName, shpWidth, shpHeight, shpLeft, shpTop); } else if (cnt == 1) { boxNum = FindWhenOneBox(sldIndex, shpName, shpWidth, shpHeight, shpLeft, shpTop); } else if (cnt > 1) { boxNum = FindWhenMultipleBox(sldIndex, shpName, shpWidth, shpHeight, shpLeft, shpTop); } if (boxNum > 0) { returnValue = ActivePPT.Slides[sldIndex].Shapes[boxNum].Name; } else { returnValue = null; } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "CheckIfBoxAlreadyExist1"); } return(returnValue); }
public float fCalculateHypotenuse(float sngBase, float sngHeight) { float fCalculate = 0; try { //fCalculate = Math.Sqrt(sngBase ^ 2 + sngHeight ^ 2); fCalculate = (float)Math.Sqrt(Math.Pow(sngBase, 2) + Math.Pow(sngHeight, 2)); } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "fCalculateHypotenuse"); } return(fCalculate); }
static public void UserTracker(Office.IRibbonControl rib) { String strUserName; String strWholeText; try { PowerPoint.Presentation ActivePPT = Globals.ThisAddIn.Application.ActivePresentation; string newPath; if (!Directory.Exists(logfile + @"TheSmartCube\Log\")) { newPath = logfile + @"TheSmartCube\Log\"; } else { newPath = logfile + @"TheSmartCube\Log\"; } string path = newPath + "UserLog_" + DateTime.Now.ToString("ddMMyyyy") + ".txt"; strUserName = Environment.UserName; strWholeText = strUserName + "|" + getButtonDiscription(rib.Id) + "|" + DateTime.Now.ToString() + "|" + ActivePPT.Name; if (!File.Exists(path)) { //File.Create(path); using (StreamWriter sw = File.CreateText(path)) { sw.WriteLine(strWholeText); sw.Close(); } } else if (File.Exists(path)) { using (StreamWriter sw = File.AppendText(path)) { sw.WriteLine(strWholeText); sw.Close(); } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "UserTracker"); //MessageBox.Show("Error in errorlog After Apply Theme"); } }
public string CheckFormat_MainSlide(int sldNum, string shpName) { string shperr = null; string dbShape; try { DataTable dt1 = new DataTable(); // Get the specification of Title PowerPoint.Shape shp = ActivePPT.Slides[sldNum].Shapes[shpName]; if (shp.Type == MsoShapeType.msoAutoShape || shp.Type == MsoShapeType.msoPlaceholder || shp.Type == MsoShapeType.msoTextBox) { if (shp.HasTextFrame == MsoTriState.msoTrue) { // ----------------------------------------------------------- int hasspliter = shpName.IndexOf("_"); if (hasspliter != -1) { dbShape = shpName.Substring(0, hasspliter); } else { dbShape = shpName; } if (dbShape == "Text Box") { return(shperr); } // -Avoid a Text box review dt1 = actionObj.get_specification(dbShape); if (dt1.Rows.Count != 0) { shperr = shperr + CheckFormat_SBox(sldNum, shpName, dt1); } ; } } else if (shp.Type == MsoShapeType.msoChart) { } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "CheckFormat_MainSlide"); } return(shperr); }
public string CheckFormat_TitleSlide(int sldNum, string shpName) { string shperr = null, sErr = null; //bool Tchkfind = false, Dchkfind=false,client=false; try { PowerPoint.Shape shp = ActivePPT.Slides[sldNum].Shapes[shpName]; if (shp.Type == MsoShapeType.msoAutoShape || shp.Type == MsoShapeType.msoPlaceholder || shp.Type == MsoShapeType.msoTextBox) { if (shp.HasTextFrame == MsoTriState.msoTrue) { DataTable dt1 = actionObj.get_specification("Project Title"); string Tchkfind = chkObj.CheckIfBoxAlreadyExist1(sldNum, dt1); DataTable dt2 = actionObj.get_specification("Project Date"); string Dchkfind = chkObj.CheckIfBoxAlreadyExist1(sldNum, dt2); DataTable dt3 = actionObj.get_specification("Client Name"); string client = chkObj.CheckIfBoxAlreadyExist1(sldNum, dt3); if (Tchkfind == shpName && dt1.Rows.Count != 0) { sErr = sErr + CheckFormat_SBox(sldNum, shpName, dt1); } else if (Dchkfind == shpName && dt2.Rows.Count != 0) { sErr = sErr + CheckFormat_SBox(sldNum, shpName, dt2); } else if (client == shpName && dt3.Rows.Count != 0) { sErr = sErr + CheckFormat_SBox(sldNum, shpName, dt3); } } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "CheckFormat_TitleSlide"); } return(sErr); }
public PowerPoint.PpParagraphAlignment ParagraphFormatAlignment(int dbVal) { try { if (dbVal == 2) { objValue3 = PowerPoint.PpParagraphAlignment.ppAlignCenter; } else if (dbVal == 5) { objValue3 = PowerPoint.PpParagraphAlignment.ppAlignDistribute; } else if (dbVal == 4) { objValue3 = PowerPoint.PpParagraphAlignment.ppAlignJustify; } else if (dbVal == 7) { objValue3 = PowerPoint.PpParagraphAlignment.ppAlignJustifyLow; } else if (dbVal == 1) { objValue3 = PowerPoint.PpParagraphAlignment.ppAlignLeft; } else if (dbVal == -2) { objValue3 = PowerPoint.PpParagraphAlignment.ppAlignmentMixed; } else if (dbVal == 3) { objValue3 = PowerPoint.PpParagraphAlignment.ppAlignRight; } else if (dbVal == 6) { objValue3 = PowerPoint.PpParagraphAlignment.ppAlignThaiDistribute; } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "getMsoTriState"); } return(objValue3); }
public void Format_Legend(PowerPoint.Chart myChart, bool hasLegend) { int Num; try { if (hasLegend == true) { if (myChart.HasLegend == true) { PowerPoint.LegendEntries ln = myChart.Legend.LegendEntries(); Num = ln.Count; } else { PowerPoint.SeriesCollection sc = myChart.SeriesCollection(); Num = sc.Count; } if (Num > 1) { if (myChart.HasLegend == false) { myChart.HasLegend = true; } myChart.Legend.Font.Name = "Calibri"; myChart.Legend.Font.Size = 11; myChart.Legend.Font.Bold = MsoTriState.msoFalse; myChart.Legend.Position = PowerPoint.XlLegendPosition.xlLegendPositionBottom; } else if (hasLegend == false) { if (myChart.HasLegend == true) { myChart.Legend.Delete(); } } } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "Format_Legend"); } }
public MsoTextOrientation getOrientation(int dVal) { try { if (dVal == 3) { objValue6 = MsoTextOrientation.msoTextOrientationDownward; } else if (dVal == 3) { objValue6 = MsoTextOrientation.msoTextOrientationDownward; } else if (dVal == 1) { objValue6 = MsoTextOrientation.msoTextOrientationHorizontal; } else if (dVal == 6) { objValue6 = MsoTextOrientation.msoTextOrientationHorizontalRotatedFarEast; } else if (dVal == -2) { objValue6 = MsoTextOrientation.msoTextOrientationMixed; } else if (dVal == 2) { objValue6 = MsoTextOrientation.msoTextOrientationUpward; } else if (dVal == 5) { objValue6 = MsoTextOrientation.msoTextOrientationVertical; } else if (dVal == 4) { objValue6 = MsoTextOrientation.msoTextOrientationVerticalFarEast; } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "getOrientation"); } return(objValue6); }
public string CheckFormat_ContentSlide(int sldNum, string shpName) { string shperr = null; try { PowerPoint.Shape shp = ActivePPT.Slides[sldNum].Shapes[shpName]; if (shp.Type == MsoShapeType.msoAutoShape || shp.Type == MsoShapeType.msoPlaceholder || shp.Type == MsoShapeType.msoTextBox) { if (shp.HasTextFrame == MsoTriState.msoTrue) { DataTable dt = actionObj.get_specification("Content Title"); string CTitle = chkObj.CheckIfBoxAlreadyExist1(sldNum, dt); DataTable dt1 = actionObj.get_specification("Content Section"); string CSection = chkObj.CheckIfBoxAlreadyExist1(sldNum, dt1); DataTable dt2 = actionObj.get_specification("Content Number"); string CNumber = chkObj.CheckIfBoxAlreadyExist1(sldNum, dt2); if (shpName == CTitle && dt.Rows.Count != 0) { shperr = shperr + CheckFormat_SBox(sldNum, shpName, dt); } else if (shpName == CSection && dt1.Rows.Count != 0) { shperr = shperr + CheckFormat_SBox(sldNum, shpName, dt1); } else if (shpName == CNumber && dt2.Rows.Count != 0) { shperr = shperr + CheckFormat_SBox(sldNum, shpName, dt2); } } } else { shpErr = shpErr + "Non Standard object in the slide." + '\n'; } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "CheckFormat_ContentSlide"); } return(shperr); }
public void Calculate_AAGR() { List <float> diffVal = new List <float>(); lbl_Value.Text = ""; float sum = 0; int stYear, lYear; try { int type = cmb_Series.SelectedIndex + 1; stYear = Convert.ToInt32(cmb_stDate.Text); lYear = Convert.ToInt32(cmb_endDate.Text); for (int x = 1; x < num_points; x++) { string output = Regex.Match(chtData[x, 0], @"\d+").Value; int year = (int)Convert.ToDouble(output); if (year >= stYear && year <= lYear) { float diff = (float)Convert.ToDouble(chtData[x, type]) / (float)Convert.ToDouble(chtData[x - 1, type]); diff = diff - 1; diffVal.Add(diff); } } foreach (float x in diffVal) { sum = sum + x; } float AAGR = sum / diffVal.Count; lbl_type.Text = "AAGR"; lbl_Value.Text = AAGR.ToString("P"); } catch (Exception err) { //this.Close(); string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "Calculate_AAGR"); MessageBox.Show("Check chart type and chart value", PPTAttribute.msgTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public List <int> get_RGBValue(string rgbValue) { List <string> rgbIndex = new List <string>(); List <int> finalrgbIndex = new List <int>(); try { rgbIndex = rgbValue.Split(splitChar).ToList(); foreach (string item in rgbIndex) { finalrgbIndex.Add(Convert.ToInt32(item)); } } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "get_RGBValue"); } return(finalrgbIndex); }
public void Format_Title(PowerPoint.Chart myChart) { try { myChart.HasTitle = true; myChart.ChartTitle.Font.Name = "Calibri"; myChart.ChartTitle.Font.Bold = MsoTriState.msoTrue; myChart.ChartTitle.Font.Size = 11; myChart.ChartTitle.Font.Color = System.Drawing.Color.FromArgb(0, 0, 0).ToArgb(); myChart.ChartTitle.Font.Strikethrough = MsoTriState.msoFalse; myChart.ChartTitle.Font.Superscript = MsoTriState.msoFalse; myChart.ChartTitle.Font.Subscript = MsoTriState.msoFalse; myChart.ChartTitle.Font.Shadow = MsoTriState.msoFalse; myChart.ChartTitle.Font.Underline = XlUnderlineStyle.xlUnderlineStyleNone; } catch (Exception err) { string errtext = err.Message; PPTAttribute.ErrorLog(errtext, "Format_Title"); } }