Package io.jmix.reports.yarg.formatters.impl.xls

Class HSSFRangeHelper

java.lang.Object

io.jmix.reports.yarg.formatters.impl.xls.HSSFRangeHelper

public final class HSSFRangeHelper
extends Object

Method Summary

Modifier and Type	Method	Description
static org.apache.poi.ss.util.AreaReference	getAreaForRange(org.apache.poi.hssf.usermodel.HSSFWorkbook workbook, String rangeName)
static org.apache.poi.ss.util.CellReference[]	getRangeContent(org.apache.poi.hssf.usermodel.HSSFWorkbook workbook, String rangeName)
static org.apache.poi.hssf.usermodel.HSSFSheet	getTemplateSheetForRangeName(org.apache.poi.hssf.usermodel.HSSFWorkbook workbook, String rangeName)
static boolean	isMergeRegionInsideNamedRange(Integer rangeFirstRow, Integer rangeFirstColumn, Integer rangeLastRow, Integer rangeLastColumn, Integer regionFirstRow, Integer regionFirstColumn, Integer regionLastRow, Integer regionLastColumn)
static boolean	isNamedRangeInsideMergeRegion(Integer rangeFirstRow, Integer rangeFirstColumn, Integer rangeLastRow, Integer rangeLastColumn, Integer regionFirstRow, Integer regionFirstColumn, Integer regionLastRow, Integer regionLastColumn)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

isMergeRegionInsideNamedRange

public static boolean isMergeRegionInsideNamedRange(Integer rangeFirstRow,
 Integer rangeFirstColumn,
 Integer rangeLastRow,
 Integer rangeLastColumn,
 Integer regionFirstRow,
 Integer regionFirstColumn,
 Integer regionLastRow,
 Integer regionLastColumn)

isNamedRangeInsideMergeRegion

public static boolean isNamedRangeInsideMergeRegion(Integer rangeFirstRow,
 Integer rangeFirstColumn,
 Integer rangeLastRow,
 Integer rangeLastColumn,
 Integer regionFirstRow,
 Integer regionFirstColumn,
 Integer regionLastRow,
 Integer regionLastColumn)

getRangeContent

public static org.apache.poi.ss.util.CellReference[] getRangeContent(org.apache.poi.hssf.usermodel.HSSFWorkbook workbook,
 String rangeName)

getAreaForRange

public static org.apache.poi.ss.util.AreaReference getAreaForRange(org.apache.poi.hssf.usermodel.HSSFWorkbook workbook,
 String rangeName)

getTemplateSheetForRangeName

public static org.apache.poi.hssf.usermodel.HSSFSheet getTemplateSheetForRangeName(org.apache.poi.hssf.usermodel.HSSFWorkbook workbook,
 String rangeName)