public final class XSSFFormulaUtils extends java.lang.Object
|Modifier and Type||Method and Description|
Update sheet name in all formulas and named ranges.
public XSSFFormulaUtils(XSSFWorkbook wb)
public void updateSheetName(int sheetIndex, java.lang.String oldName, java.lang.String newName)
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
sheetIndex- the 0-based index of the sheet being changed
oldName- the old sheet name
newName- the new sheet name
Copyright 2017 The Apache Software Foundation or its licensors, as applicable.