public void SetGrid(CairoSpreadsheet grid)
{
var sheet = this.grid.CurrentWorksheet;
var cell = (grid == null) ? null : (sheet.GetCell(sheet.SelectionRange.StartPos));
this.ProcessAllPages(p =>
{
p.Grid = grid;
p.LoadPage();
});
}
public CellFormatForm(CairoSpreadsheet grid)
{
this.grid = grid;
InitializeComponent();
SetupUILanguage();
numberPage.Done += new EventHandler(IPropertyPage_Done);
tabControl1.SelectedIndex = lastTabPageIndex;
}
/// <summary>
/// Load border info from spreadsheet
/// </summary>
/// <param name="sheet">current worksheet instance</param>
public void ReadFromGrid(CairoSpreadsheet grid)
{
var sheet = grid.CurrentWorksheet;
if (sheet.SelectionRange.IsEmpty)
{
this.Enabled = false;
}
else
{
RangeBorderInfoSet info = sheet.GetRangeBorders(sheet.SelectionRange, BorderPositions.All, false);
if (!info.Left.IsEmpty)
{
borders[BorderPositions.Left] = info.Left;
}
if (!info.Right.IsEmpty)
{
borders[BorderPositions.Right] = info.Right;
}
if (!info.Top.IsEmpty)
{
borders[BorderPositions.Top] = info.Top;
}
if (!info.Bottom.IsEmpty)
{
borders[BorderPositions.Bottom] = info.Bottom;
}
if (!info.InsideHorizontal.IsEmpty)
{
borders[BorderPositions.InsideHorizontal] = info.InsideHorizontal;
}
if (!info.InsideVertical.IsEmpty)
{
borders[BorderPositions.InsideVertical] = info.InsideVertical;
}
rows = sheet.SelectionRange.Rows > 2 ? 2 : sheet.SelectionRange.Rows;
cols = sheet.SelectionRange.Cols > 2 ? 2 : sheet.SelectionRange.Cols;
mixBorders |= info.NonUniformPos;
}
}
