java.lang.Object
io.jmix.reports.yarg.formatters.impl.xlsx.Range

public class Range extends Object
  • Field Details

    • UNLIMITED_ROW_FORMULA_RANGE_PATTERN

      public static final Pattern UNLIMITED_ROW_FORMULA_RANGE_PATTERN
    • UNLIMITED_COLUMN_FORMULA_RANGE_PATTERN

      public static final Pattern UNLIMITED_COLUMN_FORMULA_RANGE_PATTERN
    • FORMULA_RANGE_PATTERN

      public static final Pattern FORMULA_RANGE_PATTERN
    • SINGLE_CELL_RANGE_PATTERN

      public static final Pattern SINGLE_CELL_RANGE_PATTERN
    • NOT_STRICT_RANGE_PATTERN

      public static final Pattern NOT_STRICT_RANGE_PATTERN
    • STRICT_RANGE_PATTERN

      public static final Pattern STRICT_RANGE_PATTERN
    • MIN_LENGTH_RANGE

      public static final int MIN_LENGTH_RANGE
      See Also:
    • MAX_LENGTH_RANGE

      public static final int MAX_LENGTH_RANGE
      See Also:
  • Constructor Details

    • Range

      public Range(String sheet, int firstColumn, int firstRow, int lastColumn, int lastRow)
  • Method Details

    • fromCells

      public static Range fromCells(String sheetName, String firstCellRef, String lastCellRef)
    • fromFormula

      public static Range fromFormula(String range)
    • fromRange

      public static Range fromRange(String sheet, String range)
    • fromCellFormula

      public static Set<Range> fromCellFormula(String sheet, org.xlsx4j.sml.Cell cellWithFormula)
    • contains

      public boolean contains(CellReference cellReference)
    • contains

      public boolean contains(Range range)
    • containsAny

      public boolean containsAny(Collection<Range> range)
    • containsAll

      public boolean containsAll(Collection<Range> range)
    • intersectsByVertical

      public boolean intersectsByVertical(Range range)
    • intersects

      public boolean intersects(Range range)
    • shift

      public Range shift(int downShift, int rightShift)
    • shiftDown

      public Range shiftDown(int shift)
    • shiftRight

      public Range shiftRight(int shift)
    • grow

      public Range grow(int downGrow, int rightGrow)
    • growDown

      public Range growDown(int grow)
    • growRight

      public Range growRight(int grow)
    • copy

      public Range copy()
    • toString

      public String toString()
      Overrides:
      toString in class Object
    • toFormula

      public String toFormula()
    • toRange

      public String toRange()
    • toFirstCellReference

      public String toFirstCellReference()
    • toCellReferences

      public List<CellReference> toCellReferences()
    • isOneCellRange

      public boolean isOneCellRange()
    • equals

      public boolean equals(Object o)
      Overrides:
      equals in class Object
    • hashCode

      public int hashCode()
      Overrides:
      hashCode in class Object
    • getSheet

      public String getSheet()
    • getFirstColumn

      public int getFirstColumn()
    • getFirstRow

      public int getFirstRow()
    • getLastColumn

      public int getLastColumn()
    • getLastRow

      public int getLastRow()