TryCollapseOrExpandSelectedGroups
(
Microsoft.Office.Interop.Excel.Workbook oWorkbook,
Boolean bCollapse
)
{
Debug.Assert(oWorkbook != null);
ListObject oGroupTable;
Range oSelectedTableRange;
if (ExcelTableUtil.TryGetSelectedTableRange(oWorkbook,
WorksheetNames.Groups, TableNames.Groups, out oGroupTable,
out oSelectedTableRange))
{
// Store the new collapsed state in the group table.
ExcelTableUtil.SetVisibleSelectedTableColumnData(oGroupTable,
oSelectedTableRange, GroupTableColumnNames.Collapsed,
(new BooleanConverter()).GraphToWorkbook(bCollapse));
return(true);
}
return(false);
}
SetVisualAttribute
(
RunSetVisualAttributeCommandEventArgs e,
Range selectedRange,
String colorColumnName,
String alphaColumnName
)
{
Debug.Assert(e != null);
Debug.Assert(selectedRange != null);
Debug.Assert(ExcelUtil.WorksheetIsActive(m_oWorksheet.InnerObject));
AssertValid();
if (e.VisualAttribute == VisualAttributes.Color &&
colorColumnName != null)
{
String sColor;
// Get a color from the user.
if (NodeXLWorkbookUtil.TryGetColor(out sColor))
{
ExcelTableUtil.SetVisibleSelectedTableColumnData(
m_oTable.InnerObject, selectedRange, colorColumnName,
sColor);
e.VisualAttributeSet = true;
}
}
}
SetVisualAttribute
(
RunSetVisualAttributeCommandEventArgs e
)
{
Debug.Assert(e != null);
AssertValid();
Microsoft.Office.Interop.Excel.Range oSelectedRange;
if (e.VisualAttributeSet ||
!m_oSheets1And2Helper.TryGetSelectedRange(out oSelectedRange))
{
return;
}
// See if the specified attribute is set by the helper class.
m_oSheets1And2Helper.SetVisualAttribute(e, oSelectedRange,
EdgeTableColumnNames.Color, CommonTableColumnNames.Alpha);
if (e.VisualAttributeSet)
{
return;
}
if (e.VisualAttribute == VisualAttributes.EdgeWidth)
{
EdgeWidthDialog oEdgeWidthDialog = new EdgeWidthDialog();
if (oEdgeWidthDialog.ShowDialog() == DialogResult.OK)
{
ExcelTableUtil.SetVisibleSelectedTableColumnData(
this.Edges.InnerObject, oSelectedRange,
EdgeTableColumnNames.Width, oEdgeWidthDialog.EdgeWidth);
e.VisualAttributeSet = true;
}
}
else if (e.VisualAttribute == VisualAttributes.EdgeVisibility)
{
Debug.Assert(e.AttributeValue is EdgeWorksheetReader.Visibility);
ExcelTableUtil.SetVisibleSelectedTableColumnData(
this.Edges.InnerObject, oSelectedRange,
CommonTableColumnNames.Visibility,
(new EdgeVisibilityConverter()).GraphToWorkbook(
(EdgeWorksheetReader.Visibility)e.AttributeValue)
);
e.VisualAttributeSet = true;
}
}
SetVisualAttribute
(
RunSetVisualAttributeCommandEventArgs e
)
{
Debug.Assert(e != null);
AssertValid();
Microsoft.Office.Interop.Excel.Range oSelectedRange;
if (e.VisualAttributeSet ||
!m_oSheetHelper.TryGetSelectedRange(out oSelectedRange))
{
return;
}
// See if the specified attribute is set by the helper class.
m_oSheetHelper.SetVisualAttribute(e, oSelectedRange,
GroupTableColumnNames.VertexColor, null);
if (e.VisualAttributeSet)
{
return;
}
if (e.VisualAttribute == VisualAttributes.VertexShape)
{
Debug.Assert(e.AttributeValue is VertexShape);
ExcelTableUtil.SetVisibleSelectedTableColumnData(
this.Groups.InnerObject, oSelectedRange,
GroupTableColumnNames.VertexShape,
(new VertexShapeConverter()).GraphToWorkbook(
(VertexShape)e.AttributeValue)
);
e.VisualAttributeSet = true;
}
}
SetVisualAttribute
(
RunSetVisualAttributeCommandEventArgs e,
Range selectedRange,
String colorColumnName,
String alphaColumnName
)
{
Debug.Assert(e != null);
Debug.Assert(selectedRange != null);
Debug.Assert(ExcelUtil.WorksheetIsActive(m_oWorksheet.InnerObject));
AssertValid();
base.SetVisualAttribute(e, selectedRange, colorColumnName,
alphaColumnName);
if (e.VisualAttributeSet)
{
return;
}
if (e.VisualAttribute == VisualAttributes.Alpha &&
alphaColumnName != null)
{
AlphaDialog oAlphaDialog = new AlphaDialog();
if (oAlphaDialog.ShowDialog() == DialogResult.OK)
{
ExcelTableUtil.SetVisibleSelectedTableColumnData(
m_oTable.InnerObject, selectedRange, alphaColumnName,
oAlphaDialog.Alpha);
e.VisualAttributeSet = true;
}
}
}