org.apache.poi.ss.usermodel.Sheet.getForceFormulaRecalculation()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(1.4k)|赞(0)|评价(0)|浏览(112)

本文整理了Java中org.apache.poi.ss.usermodel.Sheet.getForceFormulaRecalculation()方法的一些代码示例,展示了Sheet.getForceFormulaRecalculation()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Sheet.getForceFormulaRecalculation()方法的具体详情如下:
包路径:org.apache.poi.ss.usermodel.Sheet
类名称:Sheet
方法名:getForceFormulaRecalculation

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);
}

相关文章

微信公众号

最新文章

更多