internal static void SetCellFormula(Shape shape, string cellName, string value) { string rowName = cellName; string sectionName = ""; if (cellName.Contains(".")) { string[] tmp = cellName.Split('.'); System.Diagnostics.Debug.Assert(tmp.Length == 2); sectionName = tmp[0]; rowName = tmp[1]; } if (shape.get_CellExists(cellName, (short)VisExistsFlags.visExistsAnywhere) == 0) { // we should only be adding rows to the Prop or User sections System.Diagnostics.Debug.Assert(sectionName.ToUpper().Equals("PROP") || sectionName.ToUpper().Equals("USER")); if (sectionName.ToUpper().Equals("USER")) { if (shape.get_SectionExists((short)VisSectionIndices.visSectionUser, (short)VisExistsFlags.visExistsAnywhere) == 0) { shape.AddSection((short)VisSectionIndices.visSectionUser); } shape.AddNamedRow((short)VisSectionIndices.visSectionUser, rowName, (short)VisRowTags.visTagDefault); } else { if (shape.get_SectionExists((short)VisSectionIndices.visSectionProp, (short)VisExistsFlags.visExistsAnywhere) == 0) { shape.AddSection((short)VisSectionIndices.visSectionProp); } shape.AddNamedRow((short)VisSectionIndices.visSectionProp, rowName, (short)VisRowTags.visTagDefault); } } shape.get_Cells(cellName).Formula = value; }
internal static void SetCellFormula(Shape shape, string cellName, string value) { string rowName = cellName; string sectionName = ""; if (cellName.Contains(".")) { string[] tmp = cellName.Split('.'); System.Diagnostics.Debug.Assert(tmp.Length == 2); sectionName = tmp[0]; rowName = tmp[1]; } if (shape.get_CellExists(cellName, (short)VisExistsFlags.visExistsAnywhere) == 0) { // we should only be adding rows to the Prop or User sections System.Diagnostics.Debug.Assert(sectionName.ToUpper().Equals("PROP") || sectionName.ToUpper().Equals("USER")); if (sectionName.ToUpper().Equals("USER")) { if (shape.get_SectionExists((short)VisSectionIndices.visSectionUser, (short)VisExistsFlags.visExistsAnywhere) == 0) shape.AddSection((short)VisSectionIndices.visSectionUser); shape.AddNamedRow((short)VisSectionIndices.visSectionUser, rowName, (short)VisRowTags.visTagDefault); } else { if (shape.get_SectionExists((short)VisSectionIndices.visSectionProp, (short)VisExistsFlags.visExistsAnywhere) == 0) shape.AddSection((short)VisSectionIndices.visSectionProp); shape.AddNamedRow((short)VisSectionIndices.visSectionProp, rowName, (short)VisRowTags.visTagDefault); } } shape.get_Cells(cellName).Formula = value; }