| Summary: | Please add methods getTopMargin(), getBottomMargin(), etc, to XSSFSheet | ||
|---|---|---|---|
| Product: | POI | Reporter: | David Gauntt <dmgauntt> |
| Component: | XSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | enhancement | ||
| Priority: | P2 | ||
| Version: | 4.0.x-dev | ||
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | All | ||
I have refined the workaround:
public static double getTopMargin(XSSFSheet sheet) {
return getPageMargins(sheet).getTop();
}
public static double getBottomMargin(XSSFSheet sheet) {
return getPageMargins(sheet).getBottom();
}
private static CTPageMargins getPageMargins(XSSFSheet sheet) {
final CTWorksheet ctSheet = sheet.getCTWorksheet();
if (ctSheet.isSetPageMargins()) {
return ctSheet.getPageMargins();
} else {
return ctSheet.addNewPageMargins();
}
}
|
The XSSFPrintSetup class contains the methods getHeaderMargin() and getFooterMargin(). However, Excel documents also contain top, bottom, left, and right margin settings, so the methods getTopMargin(), getBottomMargin(), etc, should be added. It would also be useful to add these as methods of XSSFSheet. The code fragments below can be used as a template. class XSSFPrintSetup { public double getTopMargin() { return pageMargins.getTop(); } } class XSSFSheet { public double getTopMargin() { final CTPageMargins pageMargins; if(worksheet.isSetPageMargins()) { pageMargins = ctWorksheet.getPageMargins(); } else { pageMargins = ctWorksheet.addNewPageMargins(); } return pageMargins.getTop(); } } This is based on the following workaround: public static double getTopMargin(XSSFSheet sheet) { final CTWorksheet ctSheet = sheet.getCTWorksheet(); final CTPageMargins margins = ctSheet.getPageMargins(); return margins.getTop(); }