本文整理了Java中org.apache.poi.ss.usermodel.Sheet.getForceFormulaRecalculation()
方法的一些代码示例,展示了Sheet.getForceFormulaRecalculation()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Sheet.getForceFormulaRecalculation()
方法的具体详情如下:
包路径:org.apache.poi.ss.usermodel.Sheet
类名称:Sheet
方法名:getForceFormulaRecalculation
[英]Whether Excel will be asked to recalculate all formulas in this sheet when the workbook is opened.
[中]打开工作簿时,是否会要求Excel重新计算此工作表中的所有公式。
代码示例来源:origin: pentaho/pentaho-kettle
@Test
public void forcesToRecalculate_Hssf() throws Exception {
data.wb = new HSSFWorkbook();
data.wb.createSheet( "sheet1" );
data.wb.createSheet( "sheet2" );
step.recalculateAllWorkbookFormulas();
if ( !data.wb.getForceFormulaRecalculation() ) {
int sheets = data.wb.getNumberOfSheets();
for ( int i = 0; i < sheets; i++ ) {
Sheet sheet = data.wb.getSheetAt( i );
assertTrue( "Sheet #" + i + ": " + sheet.getSheetName(), sheet.getForceFormulaRecalculation() );
}
}
}
}
代码示例来源:origin: org.jxls/jxls-poi
public static void copySheetProperties(Sheet src, Sheet dest){
dest.setAutobreaks(src.getAutobreaks());
dest.setDisplayGridlines(src.isDisplayGridlines());
dest.setVerticallyCenter(src.getVerticallyCenter());
dest.setFitToPage(src.getFitToPage());
dest.setForceFormulaRecalculation(src.getForceFormulaRecalculation());
dest.setRowSumsRight(src.getRowSumsRight());
dest.setRowSumsBelow( src.getRowSumsBelow() );
copyPrintSetup(src, dest);
}
内容来源于网络,如有侵权,请联系作者删除!