public static void PrintPointsInSpreadSheet(bool WaitForKeypress = false) { Program.SpreadSheet_ObjectList[Program.SheetNumber].PrintAllRows_Columns_WithinSpreadSheet(); if (true == WaitForKeypress) { ToolsInput.WaitForUser(); } ToolsScreen.MakeEmptyLines(1); }
public void PrintAllColumnsWithinSpreadSheetRow(int SpreadSheetRow) { ToolsScreen.MakeEmptyLines(1); for (int ColumnCounter = 0; ColumnCounter < SpreadSheetMatrix[SpreadSheetRow].Count; ColumnCounter++) { ToolsOutput.PrintPoint(SpreadSheetMatrix[SpreadSheetRow][ColumnCounter]); ToolsOutput.PrintStringOnSameLine(" "); } ToolsScreen.MakeEmptyLines(1); }
public void AddAllRowsWithinSpreadSheetColumn(int SpreadSheetColumn) { Point AddPoint_Object = new Point(Const.DefaultPointValue_Object.XCoordinate, Const.DefaultPointValue_Object.YCoordinate); ToolsScreen.MakeEmptyLines(1); for (int RowCounter = 0; RowCounter < SpreadSheetMatrix.Count; RowCounter++) { AddPoint_Object += SpreadSheetMatrix[RowCounter][SpreadSheetColumn]; } ToolsScreen.MakeEmptyLines(1); ToolsOutput.PrintStringOnSameLine("Summen af alle punkter i søjle " + SpreadSheetColumn + " er : " + AddPoint_Object); }
public void AddAllColumnsWithinSpreadSheetRow(int SpreadSheetRow) { Point AddPoint_Object = new Point(Const.DefaultPointValue_Object.XCoordinate, Const.DefaultPointValue_Object.YCoordinate); ToolsScreen.MakeEmptyLines(1); for (int ColumnCounter = 0; ColumnCounter < SpreadSheetMatrix[SpreadSheetRow].Count; ColumnCounter++) { AddPoint_Object += SpreadSheetMatrix[SpreadSheetRow][ColumnCounter]; } ToolsScreen.MakeEmptyLines(1); ToolsOutput.PrintStringOnSameLine("Summen af alle punkter i række " + SpreadSheetRow + " er : " + AddPoint_Object); }
public void PrintAllRows_Columns_WithinSpreadSheet() { ToolsScreen.MakeEmptyLines(1); for (int RowCounter = 0; RowCounter < SpreadSheetMatrix.Count; RowCounter++) { ToolsOutput.PrintStringOnSameLine("Række " + RowCounter + " : "); for (int ColumnCounter = 0; ColumnCounter < SpreadSheetMatrix[RowCounter].Count; ColumnCounter++) { ToolsOutput.PrintPoint(SpreadSheetMatrix[RowCounter][ColumnCounter]); ToolsOutput.PrintStringOnSameLine(" "); } ToolsScreen.MakeEmptyLines(1); } }
public void AddAllPointsWithinSheet() { Point AddPoint_Object = new Point(Const.DefaultPointValue_Object.XCoordinate, Const.DefaultPointValue_Object.YCoordinate); ToolsScreen.MakeEmptyLines(1); for (int RowCounter = 0; RowCounter < SpreadSheetMatrix.Count; RowCounter++) { for (int ColumnCounter = 0; ColumnCounter < GetMaxNumberOfColumnsInRows(); ColumnCounter++) { AddPoint_Object += SpreadSheetMatrix[RowCounter][ColumnCounter]; } } ToolsScreen.MakeEmptyLines(1); ToolsOutput.PrintStringOnSameLine("Summen af alle punkter i sheet " + Program.SheetNumber + " er : " + AddPoint_Object); }
private static int GetSpreadSheetColumnNumber(string InputString) { int CurrentColumnNumber; ToolsScreen.MakeEmptyLines(1); do { ToolsInput.GetUserInput(out CurrentColumnNumber, InputString); if (!((CurrentColumnNumber >= 0) && (CurrentColumnNumber < Program.SpreadSheet_ObjectList[Program.SheetNumber].GetMaxNumberOfColumnsInRows()))) { ToolsScreen.ClearLine(); } } while (!((CurrentColumnNumber >= 0) && (CurrentColumnNumber < Program.SpreadSheet_ObjectList[Program.SheetNumber].GetMaxNumberOfColumnsInRows()))); return(CurrentColumnNumber); }
public static void AddSheetToSpreadSheet(bool init = false) { SpreadSheet SpreadSheetObject = new SpreadSheet(); Program.SpreadSheet_ObjectList.Add(SpreadSheetObject); SpreadSheet.AddRowsAndColumsToSheetInSpreadSheet(SpreadSheetObject); if (!init) { ToolsScreen.MakeEmptyLines(2); ToolsInput.GetUserInput(out Program.SpreadSheet_ObjectList[Program.SpreadSheet_ObjectList.Count - 1].SheetNameInSpreadSheet, "Indtast ønsket navn for Sheet " + (Program.SpreadSheet_ObjectList.Count - 1) + " : "); } else { Program.SpreadSheet_ObjectList[Program.SpreadSheet_ObjectList.Count - 1].SheetNameInSpreadSheet = Const.DefaultNameForFirstSheet; } }
public void PrintAllRowsWithinSpreadSheetColumn(int SpreadSheetColumn) { if (GetMaxNumberOfColumnsInRows() >= SpreadSheetColumn) { ToolsScreen.MakeEmptyLines(1); for (int RowCounter = 0; RowCounter < SpreadSheetMatrix.Count; RowCounter++) { ToolsOutput.PrintStringOnSameLine("Række " + RowCounter + " : "); if (SpreadSheetMatrix[RowCounter].Count > SpreadSheetColumn) { ToolsOutput.PrintPoint(SpreadSheetMatrix[RowCounter][SpreadSheetColumn]); } ToolsOutput.PrintStringOnSeperateLine(""); } ToolsScreen.MakeEmptyLines(1); } }
public static void AddPointToRowInSpreadSheet() { int CurrentRowNumber; CurrentRowNumber = GetSpreadSheetRowNumber("Indtast række nummer der skal have punkt adderet (0 - " + (Program.SpreadSheet_ObjectList[Program.SheetNumber].GetNumberOfRowsInSpreadSheet() - 1) + ") : "); if (CurrentRowNumber >= 0) { ToolsScreen.MakeEmptyLines(1); double XCoordinate = 0; double YCoordinate = 0; ToolsInput.GetUserInput(out XCoordinate, "Indtast punktets x-koordinat : "); ToolsInput.GetUserInput(out YCoordinate, "Indtast punktets y-koordinat : "); Point Point_Object = new Point(XCoordinate, YCoordinate); Program.SpreadSheet_ObjectList[Program.SheetNumber].AddPointValueToSpreadSheetRow(CurrentRowNumber, Point_Object); ToolsInput.WaitForUser(); } }
public static void ChangePointFromSpreadSheet() { int CurrentRowNumber = -1; int CurrentColumnNumber = -1; GetRowAndColumnNumber(ref CurrentRowNumber, ref CurrentColumnNumber, "Indtast række nummer der skal have punkt ændret (0 - " + (Program.SpreadSheet_ObjectList[Program.SheetNumber].GetNumberOfRowsInSpreadSheet() - 1) + ") : ", "Indtast søjle nummer der skal punkt ændret (0 - " + (Program.SpreadSheet_ObjectList[Program.SheetNumber].GetNumberOfColumnsInSpreadSheet() - 1) + ") : "); if ((CurrentRowNumber >= 0) && (CurrentColumnNumber >= 0)) { ToolsScreen.MakeEmptyLines(1); double XCoordinate = 0; double YCoordinate = 0; ToolsInput.GetUserInput(out XCoordinate, "Indtast punktets nye x-koordinat : "); ToolsInput.GetUserInput(out YCoordinate, "Indtast punktets nye y-koordinat : "); Program.SpreadSheet_ObjectList[Program.SheetNumber].ChangePointInSpreadSheet(CurrentRowNumber, CurrentColumnNumber, XCoordinate, YCoordinate); } }
public static void PrintTopOfScreen(int SheetNumber) { ToolsScreen.ClearScreen(); if (Const.NoSheetInSpreadSheet != SheetNumber) { ToolsOutput.PrintStringOnSeperateLine("Antal Sheet i Regneark : " + HandleSpreadSheet.GetNumberOfSheetsInSpreadSheet()); ToolsOutput.PrintStringOnSameLine("Sheets : "); for (int SheetCounter = 0; SheetCounter < HandleSpreadSheet.GetNumberOfSheetsInSpreadSheet(); SheetCounter++) { ToolsOutput.PrintStringOnSameLine(SheetCounter + " (" + SpreadSheet_ObjectList[SheetCounter].SheetNameInSpreadSheet + ")"); if (SheetCounter < HandleSpreadSheet.GetNumberOfSheetsInSpreadSheet() - 1) { ToolsOutput.PrintStringOnSameLine(" - "); } } ToolsOutput.PrintStringOnSeperateLine(""); ToolsOutput.PrintStringOnSeperateLine("Aktiv Sheet i Regneark : " + SheetNumber + " (" + SpreadSheet_ObjectList[SheetNumber].SheetNameInSpreadSheet + ")"); ToolsOutput.PrintStringOnSeperateLine("Antal rækker i Sheet " + SheetNumber + " : " + SpreadSheet_ObjectList[SheetNumber].GetNumberOfRowsInSpreadSheet()); ToolsOutput.PrintStringOnSeperateLine("Max søjler i række i sheet " + SheetNumber + " : " + SpreadSheet_ObjectList[SheetNumber].GetMaxNumberOfColumnsInRows()); ToolsOutput.PrintStringOnSeperateLine("---------------------------------"); ToolsScreen.MakeEmptyLines(1); } }
private static int GetSpreadSheetRowNumber(string InputString) { int NumberOfRowsInSpreadSheet = Program.SpreadSheet_ObjectList[Program.SheetNumber].GetNumberOfRowsInSpreadSheet(); int CurrentRowNumber = 0; if (NumberOfRowsInSpreadSheet > 0) { ToolsScreen.MakeEmptyLines(1); do { ToolsInput.GetUserInput(out CurrentRowNumber, InputString); if (!((CurrentRowNumber >= 0) && (CurrentRowNumber < NumberOfRowsInSpreadSheet))) { ToolsScreen.ClearLine(); } } while (!((CurrentRowNumber >= 0) && (CurrentRowNumber < NumberOfRowsInSpreadSheet))); } else { CurrentRowNumber = Const.NoRowsInSpreadSheet; } return(CurrentRowNumber); }
private static int GetSpreadSheet_SheetNumber(string InputString) { int NumberOfSheetsInSpreadSheet = GetNumberOfSheetsInSpreadSheet(); int CurrentSheetNumber = 0; if (NumberOfSheetsInSpreadSheet > 0) { ToolsScreen.MakeEmptyLines(2); do { ToolsInput.GetUserInput(out CurrentSheetNumber, InputString); if (!((CurrentSheetNumber >= 0) && (CurrentSheetNumber < NumberOfSheetsInSpreadSheet))) { ToolsScreen.ClearLine(); } } while (!((CurrentSheetNumber >= 0) && (CurrentSheetNumber < NumberOfSheetsInSpreadSheet))); } else { CurrentSheetNumber = Const.NoSheetInSpreadSheet; } return(CurrentSheetNumber); }
public static void RenameSheetNameInSpreadSheet() { ToolsScreen.MakeEmptyLines(2); ToolsInput.GetUserInput(out Program.SpreadSheet_ObjectList[Program.SheetNumber].SheetNameInSpreadSheet, "Indtast nyt ønsket navn for nuværende Sheet => " + Program.SheetNumber + " (" + Program.SpreadSheet_ObjectList[Program.SheetNumber].SheetNameInSpreadSheet + ") : "); }