Class XSSFFormulaUtils

java.lang.Object
org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils

public final class XSSFFormulaUtils extends Object
Utility to update formulas and named ranges when a sheet name was changed
Author:
Yegor Kozlov
  • Constructor Details

    • XSSFFormulaUtils

      public XSSFFormulaUtils(XSSFWorkbook wb)
  • Method Details

    • updateSheetName

      public void updateSheetName(int sheetIndex, String oldName, String newName)
      Update sheet name in all charts, formulas and named ranges. Called from XSSFWorkbook.setSheetName(int, String)

      The idea is to parse every formula and render it back to string with the updated sheet name. This is done by parsing into Ptgs, looking for ones with sheet references in them, and changing those

      Parameters:
      sheetIndex - the 0-based index of the sheet being changed
      oldName - the old sheet name
      newName - the new sheet name