public UnitVector(string Name, int Order) { this.Name = Name; this.Order = Order; this.IsRowOrColumn = RowColumn.Column; Init(); }
private IEnumerable <OpenXmlAttribute> EnumCellProxyAttributes(uint row, uint col, CellProxy cellProxy) { OpenXmlAttribute iteratorVariable0 = new OpenXmlAttribute { LocalName = "r", Value = RowColumn.ToAddress(row, col) }; yield return(iteratorVariable0); if (cellProxy.DataType.HasValue) { OpenXmlAttribute iteratorVariable1 = new OpenXmlAttribute { LocalName = "t", Value = this.STCellType(cellProxy.DataType.Value) }; yield return(iteratorVariable1); } if (cellProxy.StyleIndex.HasValue) { OpenXmlAttribute iteratorVariable2 = new OpenXmlAttribute { LocalName = "s", Value = cellProxy.StyleIndex.Value.ToString() }; yield return(iteratorVariable2); } }
private void CreateColumnCopies(uint colFromIdx, int numOfColumns, Func <CellProxy, CellProxy> fnCreate) { Action <uint, uint> action = delegate(uint rowIdx, uint colIdx) { RowColumn column = new RowColumn { Row = rowIdx, Column = colIdx }; if (column.Column == colFromIdx) { foreach (int num in Enumerable.Range(((int)colFromIdx) + 1, numOfColumns)) { RowColumn column2 = new RowColumn { Row = column.Row, Column = (uint)num }; CellProxy cell = this.GetCell(column.Row, column.Column); if (cell != null) { CellProxy c = fnCreate(cell); if (c != null) { this.AddCellToCache(c, column2.Row, column2.Column); } } } } }; this.LoopCells(action); }
public UnitVector(int value) { this.Name = "e"; this.Order = 1; this.IsRowOrColumn = RowColumn.Column; this.Add(value); }
public UnitVector(string Name, int Order, RowColumn rc) { this.Name = Name; this.Order = Order; this.IsRowOrColumn = rc; Init(); }
private void CreateColumnCopies(uint colFromIdx, int numOfColumns, Func <CellProxy, CellProxy> fnCreate) { Action <uint, uint> actionCopyColumn = (rowIdx, colIdx) => { RowColumn rcOld = new RowColumn() { Row = rowIdx, Column = colIdx }; if (rcOld.Column == colFromIdx) { foreach (var newColIdx in Enumerable.Range((int)colFromIdx + 1, numOfColumns)) { RowColumn rcNew = new RowColumn() { Row = rcOld.Row, Column = (uint)newColIdx }; CellProxy cOld = GetCell(rcOld.Row, rcOld.Column); if (cOld != null) { CellProxy cNew = fnCreate(cOld); if (cNew != null) { AddCellToCache(cNew, rcNew.Row, rcNew.Column); } } } } }; LoopCells(actionCopyColumn); }
// Calculates Gamma values private static void calculatePolyPi(double[] dj, double[,] prov, double[,] prov1, double[,] prov2, double[,] prov3, double[] v, int i) { double[] Gammaj = new double[dj.Length]; double[] dGammaj = new double[dj.Length]; double[] d2Gammaj = new double[dj.Length]; double[] d3Gammaj = new double[dj.Length]; for (int c = 0; c < dj.Length; c++) { Gammaj[c] = Math.Exp(dj[c]); dGammaj[c] = Gammaj[c] * v[c]; d2Gammaj[c] = Gammaj[c] * Math.Pow(v[c], 2); d3Gammaj[c] = Gammaj[c] * Math.Pow(v[c], 3); } double Sg = RowColumn.Sum(Gammaj); double Sdg = RowColumn.Sum(dGammaj); double Sd2g = RowColumn.Sum(d2Gammaj); double Sd3g = RowColumn.Sum(d3Gammaj); for (int index = 0; index < Gammaj.Length; index++) { prov[i, index] = Gammaj[index] / Sg; prov1[i, index] = dGammaj[index] / Sg - Gammaj[index] * Sdg / Math.Pow(Sg, 2); prov2[i, index] = d2Gammaj[index] / Sg - 2 * dGammaj[index] * Sdg / Math.Pow(Sg, 2) - Gammaj[index] * Sd2g / Math.Pow(Sg, 2) + 2 * Gammaj[index] * Math.Pow(Sdg, 2) / Math.Pow(Sg, 3); prov3[i, index] = d3Gammaj[index] / Sg - (Gammaj[index] * Sd3g + 3 * dGammaj[index] * Sd2g + 3 * d2Gammaj[index] * Sdg) / Math.Pow(Sg, 2) + (6 * Gammaj[index] * Sdg * Sd2g + 6 * dGammaj[index] * Math.Pow(Sdg, 2)) / Math.Pow(Sg, 3) - 6 * Gammaj[index] * Math.Pow(Sdg, 3) / Math.Pow(Sg, 4); } }
public void Hash() { var rowColumn1 = new RowColumn(10, 20); var rowColumn2 = new RowColumn(40, 10); var dictionary = new Dictionary <RowColumn, int>(); dictionary.Add(rowColumn1, dictionary.Count); try { dictionary.Add(rowColumn2, dictionary.Count); } catch { Assert.True(false, $"{typeof(RowColumn)} must not throw exception."); } try { dictionary.Add(rowColumn2, dictionary.Count); Assert.True(false, $"{typeof(RowColumn)} must throw exception because key is duplicate."); } catch (ArgumentException) { } }
public ExcelCell this[string address] { get { RowColumn column = ExcelAddress.ToRowColumn(address); return(this[column.Row, column.Column]); } }
public OleDbCell this[string address] { get { RowColumn rc = ExcelAddress.ToRowColumn(address); return(this[rc.Row, rc.Column]); } }
public static RowColumn CacheIndexToRowCol(ulong cacheIdx) { RowColumn rc = new RowColumn(); // Note: 0-indexed --> 1-indexed rc.Row = (uint)(cacheIdx / (ulong)ExcelConstraints.MaxColumns) + 1; rc.Column = (uint)(cacheIdx % (ulong)ExcelConstraints.MaxColumns) + 1; return(rc); }
public Model(string Name, CompassDirection Direction, string Icon, RowColumn RowColumn) : base(Name) { this.Direction = Direction; this.Icon = string.Concat(@"pack://application:,,,/Imagin.Controls.Common;component/Images/", Icon, ".png"); this.Row = RowColumn.Row.ToInt32(); this.Column = RowColumn.Column.ToInt32(); this.DefaultRow = RowColumn.Row.ToInt32(); this.DefaultColumn = RowColumn.Column.ToInt32(); }
/// <summary> /// Generates a new row in every column /// </summary> private void CreateNewRow() { RowColumn.AddRow(); foreach (KeyValuePair <string, Column> c in SpreadSheet) { c.Value.AddRow(); } RowCount++; }
public void NotEqual() { var rowColumn1 = new RowColumn(10, 20); var rowColumn2 = new RowColumn(40, 10); Assert.NotEqual(rowColumn1, rowColumn2); Assert.True(rowColumn1 != rowColumn2); Assert.True(!rowColumn1.Equals(rowColumn2)); Assert.False(rowColumn1 == rowColumn2); }
private bool ValidateColumn(Value value, RowColumn column) { foreach (var row in rowColumnManager.rowColumns) { if (GetMatValue(testMat, row, column) == value) { return(false); } } return(true); }
public static void GetExcelRowColumn(int i, out RowColumn sRowColumn) { sRowColumn = new RowColumn(); //料號 sRowColumn.PartNoRow = 52; sRowColumn.PartNoColumn = 10; //品名 sRowColumn.PartDescRow = 51; sRowColumn.PartDescColumn = 10; //設計 sRowColumn.DesignedRow = 52; sRowColumn.DesignedColumn = 5; //審核 sRowColumn.ReviewedRow = 52; sRowColumn.ReviewedColumn = 6; //批准 sRowColumn.ApprovedRow = 52; sRowColumn.ApprovedColumn = 7; int currentNo = (i % 40); int RowNo = 7; RowNo = RowNo + currentNo; sRowColumn.ToolNumberRow = RowNo; sRowColumn.ToolNumberColumn = 1; sRowColumn.ERPNumberRow = RowNo; sRowColumn.ERPNumberColumn = 2; sRowColumn.CutterQtyRow = RowNo; sRowColumn.CutterQtyColumn = 3; sRowColumn.CutterLifeRow = RowNo; sRowColumn.CutterLifeColumn = 4; sRowColumn.FluteQtyRow = RowNo; sRowColumn.FluteQtyColumn = 5; sRowColumn.TitleRow = RowNo; sRowColumn.TitleColumn = 6; sRowColumn.SpecificationRow = RowNo; sRowColumn.SpecificationColumn = 8; sRowColumn.NoteRow = RowNo; sRowColumn.NoteColumn = 10; sRowColumn.HolderRow = RowNo; sRowColumn.HolderColumn = 12; }
protected override void LayoutChildren(IGUIContext ctx, RectangleF bounds) { base.LayoutChildren(ctx, bounds); float totalHeight = Editor.RowManager.Height + Editor.Padding.Height; if (totalHeight != lastTotalHeight) { lastTotalHeight = totalHeight; RowColumn.Update(); //Editor.Update (); } }
public Area GetRowColumnArea(RowColumn rowColumn) { switch (((int)rowColumn / 3) + 1) { case 1: return(Area.One); case 2: return(Area.Two); case 3: return(Area.Three); default: return(Area.Zero); } }
/// <summary> /// Instantiates new instance /// </summary> /// <param name="start">Start of the selection</param> /// <param name="end">End of the selection</param> public Selection(RowColumn start, RowColumn end) { if (start.Row > end.Row || (start.Row == end.Row && start.Column > end.Column)) { Start = end; End = start; } else { Start = start; End = end; } }
/// <summary> /// タイムライン生成 /// </summary> private int AddTimeline(string name, string status, bool append) { if (timelineChildren.Count > MAX_TIMELINE) { var count = timelineChildren.Count - MAX_TIMELINE; foreach (var item in timelineChildren.GetRange(MAX_TIMELINE, count)) { item.Destroy(); } timelineChildren.RemoveRange(MAX_TIMELINE, count); } var rc = new RowColumn(); if (!append) { rc.RowColumnConstraint.PositionIndex = 0; } var label = new Text(); label.Editable = false; label.EditMode = EditMode.Multi; label.Rows = 2; label.BorderWidth = 0; label.ShadowThickness = 0; label.WordWrap = true; label.ResizeHeight = true; label.LeftAttachment = AttachmentType.Form; label.RightAttachment = AttachmentType.Form; label.Value = $"[{name}]\n{status}"; rc.Children.Add(label); rc.Children.Add(new SeparatorGadget()); this.timelineView.Children.Add(rc); if (append) { timelineChildren.Add(rc); } else { timelineChildren.Insert(0, rc); } return(0); }
public void UpdateDesignBlock(RowColumn curRC) { if (_currentBlock == null) { _currentBlock = new GridBlockModel(false); //fe.Children.Add(_currentBlock); AddCustomBlock(_currentBlock); OnCustomBlockAdded(new BlockCreateEventArgs(_currentBlock)); } int rSpan = Math.Abs(curRC.Row - _starRC.Row) + 1; int cSpan = Math.Abs(curRC.Column - _starRC.Column) + 1; _currentBlock.Row = Math.Min(curRC.Row, _starRC.Row); _currentBlock.Column = Math.Min(curRC.Column, _starRC.Column); _currentBlock.RowSpan = rSpan; _currentBlock.ColumnSpan = cSpan; }
private bool ValidateArea(Value value, RowColumn row, RowColumn column) { var rowArea = areaManager.GetRowColumnArea(row); var columnArea = areaManager.GetRowColumnArea(column); foreach (var indexRow in rowColumnManager.rowColumns) { foreach (var indexColumn in rowColumnManager.rowColumns) { if (areaManager.GetRowColumnArea(indexRow) == rowArea && areaManager.GetRowColumnArea(indexColumn) == columnArea && GetMatValue(testMat, indexRow, indexColumn) == value) { return(false); } } } return(true); }
/// <summary> /// Checks whether or not row and column is within the selection /// </summary> /// <param name="rowColumn">The row and column</param> /// <returns>True if inside the selection</returns> public bool Inside(RowColumn rowColumn) { if (rowColumn.Row == Start.Row && rowColumn.Row == End.Row) // same row { return(rowColumn.Column >= Start.Column && rowColumn.Column <= End.Column); // between columns } if (rowColumn.Row > Start.Row && rowColumn.Row < End.Row) // between rows { return(true); } if (rowColumn.Row == Start.Row) // start row { return(rowColumn.Column <= Start.Column); // before column } if (rowColumn.Row == End.Row) // end row { return(rowColumn.Column >= End.Column); // after column } return(false); }
void ShiftPositions(Model Model) { if (Model.Direction == CompassDirection.Origin) { this.Direction = CompassDirection.Origin; } ShiftType Shift = this.Shifts[(int)Model.Direction]; if (Shift == ShiftType.None) { return; } foreach (Model d in this.Items) { if (Shift.HasFlag(ShiftType.Up)) { d.Row--; } if (Shift.HasFlag(ShiftType.Down)) { d.Row++; } if (Shift.HasFlag(ShiftType.Left)) { d.Column--; } if (Shift.HasFlag(ShiftType.Right)) { d.Column++; } } var Origin = this.Items.Where(x => x.Direction == CompassDirection.Origin).First(); var RowColumn = new RowColumn(Origin.Row, Origin.Column); this.Direction = (CompassDirection)this.Directions[(--RowColumn.Row).ToInt32(), (--RowColumn.Column).ToInt32()]; }
private IEnumerable <OpenXmlAttribute> EnumCellProxyAttributes(uint row, uint col, CellProxy cellProxy) { yield return(new OpenXmlAttribute() { LocalName = "r", Value = RowColumn.ToAddress(row, col) }); if (cellProxy.DataType != null) { yield return(new OpenXmlAttribute() { LocalName = "t", Value = STCellType((CellValues)cellProxy.DataType) }); } if (cellProxy.StyleIndex != null) { yield return(new OpenXmlAttribute() { LocalName = "s", Value = cellProxy.StyleIndex.Value.ToString() }); } }
/*TODO: remove this GPG * public static UnitVector operator*(ElementaryMatrix em, UnitVector uv) * { * UnitVector uvOut = null; * //using following realtionships * //Eij * er = ei * e'j * er * // = &jr * ei where & is the Kronecker Delta * UnitVectorSpace uvp = new UnitVectorSpace(uv.Order); * UnitVector ei = uvp["e" + em.Major.ToString()]; * UnitVector ej = uvp["e" + em.Minor.ToString()]; * RowColumn rc = ej.IsRowOrColumn; * ej.IsRowOrColumn = RowColumn.Row; * * uvOut = ei * ej * uv; * ej.IsRowOrColumn = rc; //Set it back to what it was * return uvOut; * } */ public static ElementaryMatrix operator*(UnitVector e1, UnitVector e2) { ElementaryMatrix em = null; RowColumn rc = e2.IsRowOrColumn; if (e1.IsRowOrColumn == RowColumn.Row) //Dot product { return((ElementaryMatrix)DotProduct(e1, e2)); } e2.IsRowOrColumn = RowColumn.Row; //transpose string emName = "E" + e1.Name[1].ToString() + e2.Name[1].ToString(); em = new ElementaryMatrix(e1.Order, e2.Order, emName); em.FullRep = em.LatexName + " = " + e1.ToLatex() + e2.ToLatex() + " = " + em.ToLatex(); e2.IsRowOrColumn = rc; //set back to what it was return(em); }
public static void GetExcelRowColumn(int i, out RowColumn sRowColumn) { sRowColumn = new RowColumn(); sRowColumn.FixInsNoRow = 32; sRowColumn.FixInsNoColumn = 1; sRowColumn.ERPRow = 31; sRowColumn.ERPColumn = 21; sRowColumn.FixInsDescRow = 34; sRowColumn.FixInsDescColumn = 1; int currentNo = (i % 15); int RowNo = 16; RowNo = RowNo + currentNo; sRowColumn.BallonRow = RowNo; sRowColumn.BallonColumn = 1; sRowColumn.FixInsDimensionRow = RowNo; sRowColumn.FixInsDimensionColumn = 2; }
private void CreateRowCopies(uint rowFromIdx, int numOfRows, Func <CellProxy, CellProxy> fnCreate) { SortedList <uint, CellProxy> rowCache; if (_cachedCells.TryGetValue(rowFromIdx, out rowCache)) { Row cachedRow; _cachedRows.TryGetValue(rowFromIdx, out cachedRow); foreach (var newRowIdx in Enumerable.Range((int)rowFromIdx + 1, numOfRows)) { if (cachedRow != null) { Row cachedRowCopy = (Row)cachedRow.CloneNode(false); cachedRowCopy.RowIndex = (uint)newRowIdx; _cachedRows.Add(cachedRowCopy.RowIndex, cachedRowCopy); } foreach (var colIdx in rowCache.Keys) { RowColumn rcOld = new RowColumn() { Row = rowFromIdx, Column = colIdx }; RowColumn rcNew = new RowColumn() { Row = (uint)newRowIdx, Column = colIdx }; CellProxy cOld = GetCell(rcOld.Row, rcOld.Column); CellProxy cNew = fnCreate(cOld); if (cNew != null) { AddCellToCache(cNew, rcNew.Row, rcNew.Column); } } } } }
private void CreateRowCopies(uint rowFromIdx, int numOfRows, Func <CellProxy, CellProxy> fnCreate) { SortedList <uint, CellProxy> list; if (this._cachedCells.TryGetValue(rowFromIdx, out list)) { Row row; this._cachedRows.TryGetValue(rowFromIdx, out row); foreach (int num in Enumerable.Range(((int)rowFromIdx) + 1, numOfRows)) { if (row != null) { Row row2 = (Row)row.CloneNode(false); row2.RowIndex = (UInt32Value)(uint)num; this._cachedRows.Add((uint)row2.RowIndex, row2); } foreach (uint num2 in list.Keys) { RowColumn column = new RowColumn { Row = rowFromIdx, Column = num2 }; RowColumn column2 = new RowColumn { Row = (uint)num, Column = num2 }; CellProxy cell = this.GetCell(column.Row, column.Column); CellProxy c = fnCreate(cell); if (c != null) { this.AddCellToCache(c, column2.Row, column2.Column); } } } } }
static int GetMax(RowColumn rowColumn, ExcelVersion version) { switch (rowColumn) { case RowColumn.Row: switch (version) { case ExcelVersion.Xls: return(RowMaxXls); case ExcelVersion.Xlsx: return(RowMaxXlsx); } break; case RowColumn.Column: switch (version) { case ExcelVersion.Xls: return(ColumnMaxXls); case ExcelVersion.Xlsx: return(ColumnMaxXlsx); } break; } throw new InvalidEnumArgumentException("version", (int)version, version.GetType()); }