package gw.exportimport

@ReadOnly
class ExportImportHelper {

  /**
   * Converts a row and column to a string representing an excel formatted cell location.
   * Example: convertCellLocationToExcelFormat(0, 0, false) returns "A1"
   * Example: convertCellLocationToExcelFormat(0, 0, true) returns "$A$1"
   */
  static function convertCellLocationToExcelFormat(row : int, column : int, staticReference : boolean) : String {
    var formattedRow = convertRowToExcelFormat(row)
    var formattedColumn = convertColumnToExcelFormat(column)
    return ((staticReference) ? "\$${formattedColumn}$" : formattedColumn) + formattedRow
  }

  private static function convertRowToExcelFormat(row : int) : String {
    return (row + 1) as String
  }
  
  internal static function convertColumnToExcelFormat(column : int) : String{
    var columnRemainder = column
    var formattedReturn = ""
    while (columnRemainder >= 0) {
      formattedReturn = ('A' + columnRemainder % 26) as char + formattedReturn
      //get rid of modulo
      columnRemainder /= 26
      //Zero-index
      columnRemainder --
    }
    return formattedReturn
  }
}