Return-Path: X-Original-To: apmail-poi-commits-archive@minotaur.apache.org Delivered-To: apmail-poi-commits-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 59B641158C for ; Thu, 24 Jul 2014 15:02:17 +0000 (UTC) Received: (qmail 35857 invoked by uid 500); 24 Jul 2014 15:02:17 -0000 Delivered-To: apmail-poi-commits-archive@poi.apache.org Received: (qmail 35814 invoked by uid 500); 24 Jul 2014 15:02:17 -0000 Mailing-List: contact commits-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@poi.apache.org Delivered-To: mailing list commits@poi.apache.org Received: (qmail 35799 invoked by uid 99); 24 Jul 2014 15:02:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Jul 2014 15:02:17 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Jul 2014 15:02:11 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id 828BE2388BBD; Thu, 24 Jul 2014 15:01:26 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1613157 [9/10] - in /poi/site/publish/apidocs: ./ org/apache/poi/hssf/usermodel/ org/apache/poi/openxml4j/opc/ org/apache/poi/ss/formula/ org/apache/poi/ss/formula/class-use/ org/apache/poi/ss/formula/eval/ org/apache/poi/ss/formula/eval/c... Date: Thu, 24 Jul 2014 15:01:19 -0000 To: commits@poi.apache.org From: nick@apache.org X-Mailer: svnmailer-1.0.9 Message-Id: <20140724150126.828BE2388BBD@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/AreaReference.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/AreaReference.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/AreaReference.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/AreaReference.html Thu Jul 24 15:01:16 2014 @@ -74,12 +74,24 @@ +org.apache.poi.hssf.usermodel + +
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
+ + + org.apache.poi.hssf.util
util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.
+ +org.apache.poi.ss.formula + +
This package contains common internal POI code for manipulating formulas.
+ + org.apache.poi.ss.formula.ptg @@ -90,11 +102,34 @@ HSSF concepts. org.apache.poi.ss.util   + +org.apache.poi.xssf.usermodel +  +
  • Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellReference.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellReference.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellReference.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/util/class-use/CellReference.html Thu Jul 24 15:01:16 2014 @@ -80,37 +80,43 @@ +org.apache.poi.hssf.usermodel + +
    usermodel package maps HSSF low level strutures to familiar workbook/sheet model
    + + + org.apache.poi.hssf.util
    util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.
    - + org.apache.poi.ss.formula
    This package contains common internal POI code for manipulating formulas.
    - + org.apache.poi.ss.formula.ptg
    formula package contains binary PTG structures used in Formulas
    - + org.apache.poi.ss.usermodel.charts   - + org.apache.poi.ss.util   - + org.apache.poi.xssf.usermodel   - + org.apache.poi.xssf.usermodel.charts   @@ -145,6 +151,25 @@ HSSF concepts. +
  • + + +

    Uses of CellReference in org.apache.poi.hssf.usermodel

    + + + + + + + + + + + + +
    Methods in org.apache.poi.hssf.usermodel with parameters of type CellReference 
    Modifier and TypeMethod and Description
    PtgHSSFEvaluationWorkbook.get3DReferencePtg(CellReference cr, + SheetIdentifier sheet) 
    +
  • @@ -188,6 +213,22 @@ HSSF concepts. + + + + + + + + + + + + +
    Methods in org.apache.poi.ss.formula with parameters of type CellReference 
    Modifier and TypeMethod and Description
    PtgFormulaParsingWorkbook.get3DReferencePtg(CellReference cell, + SheetIdentifier sheet) +
    Produce the appropriate Ptg for a 3d cell reference
    +
  • @@ -204,6 +245,15 @@ HSSF concepts. int externIdx)  +Ref3DPxg(int externalWorkbookNumber, + java.lang.String sheetName, + CellReference c)  + + +Ref3DPxg(java.lang.String sheetName, + CellReference c)  + + RefPtg(CellReference cr)  @@ -328,6 +378,20 @@ HSSF concepts. + + + + + + + + + + + + +
    Methods in org.apache.poi.xssf.usermodel with parameters of type CellReference 
    Modifier and TypeMethod and Description
    PtgXSSFEvaluationWorkbook.get3DReferencePtg(CellReference cell, + SheetIdentifier sheet) 
  • Modified: poi/site/publish/apidocs/org/apache/poi/ss/util/package-use.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/util/package-use.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/util/package-use.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/util/package-use.html Thu Jul 24 15:01:16 2014 @@ -267,18 +267,21 @@ HSSF concepts. +AreaReference  + + CellRangeAddress
    See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'

    - + CellRangeAddressBase
    See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'

    Common subclass of 8-bit and 16-bit versions

    - + CellRangeAddressList
    Implementation of the cell range address lists,like is described in OpenOffice.org's Excel Documentation: excelfileformat.pdf sec 2.5.14 - @@ -288,6 +291,9 @@ HSSF concepts.
    several records (not formulas). + +CellReference  + Region
    Deprecated.  @@ -355,6 +361,9 @@ HSSF concepts.
    +AreaReference  + + CellReference  @@ -512,11 +521,14 @@ HSSF concepts. +AreaReference  + + CellRangeAddress
    See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'

    - + CellRangeAddressList
    Implementation of the cell range address lists,like is described in OpenOffice.org's Excel Documentation: excelfileformat.pdf sec 2.5.14 - @@ -526,7 +538,7 @@ HSSF concepts.
    several records (not formulas). - + CellReference  Modified: poi/site/publish/apidocs/org/apache/poi/util/class-use/Internal.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/util/class-use/Internal.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/util/class-use/Internal.html (original) +++ poi/site/publish/apidocs/org/apache/poi/util/class-use/Internal.html Thu Jul 24 15:01:16 2014 @@ -136,42 +136,48 @@ +org.apache.poi.ss.formula + +
    This package contains common internal POI code for manipulating formulas.
    + + + org.apache.poi.ss.formula.udf   - + org.apache.poi.ss.util   - + org.apache.poi.xslf   - + org.apache.poi.xslf.model   - + org.apache.poi.xslf.usermodel   - + org.apache.poi.xssf.model   - + org.apache.poi.xssf.usermodel   - + org.apache.poi.xssf.usermodel.charts   - + org.apache.poi.xssf.usermodel.extensions   - + org.apache.poi.xwpf.usermodel   @@ -9878,6 +9884,34 @@
  • +
  • + + +

    Uses of Internal in org.apache.poi.ss.formula

    + + + + + + + + + + + + + + + + +
    Classes in org.apache.poi.ss.formula with annotations of type Internal 
    Modifier and TypeClass and Description
    class CollaboratingWorkbooksEnvironment +
    Manages a collection of WorkbookEvaluators, in order to support + evaluation of formulas across spreadsheets.
    +
    interface WorkbookEvaluatorProvider +
    Provides access to a WorkbookEvaluator, eg for use with + CollaboratingWorkbooksEnvironment
    +
    +
  • @@ -10225,9 +10259,9 @@ -ExternalLinksTable +java.util.List<ExternalLinksTable> XSSFWorkbook.getExternalLinksTable() -
    Returns the ExternalLinksTable object for this workbook.
    +
    Returns the list of ExternalLinksTable object for this workbook
    Modified: poi/site/publish/apidocs/org/apache/poi/util/class-use/LittleEndianOutput.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/util/class-use/LittleEndianOutput.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/util/class-use/LittleEndianOutput.html (original) +++ poi/site/publish/apidocs/org/apache/poi/util/class-use/LittleEndianOutput.html Thu Jul 24 15:01:16 2014 @@ -1174,68 +1174,84 @@ HSSF concepts. void +Ref3DPxg.write(LittleEndianOutput out)  + + +void ValueOperatorPtg.write(LittleEndianOutput out)  + +void +Area3DPxg.write(LittleEndianOutput out)  + void -Ref3DPtg.write(LittleEndianOutput out)  +NameXPxg.write(LittleEndianOutput out)  void -BoolPtg.write(LittleEndianOutput out)  +Ref3DPtg.write(LittleEndianOutput out)  void -IntersectionPtg.write(LittleEndianOutput out)  +BoolPtg.write(LittleEndianOutput out)  void -MissingArgPtg.write(LittleEndianOutput out)  +IntersectionPtg.write(LittleEndianOutput out)  void -ExpPtg.write(LittleEndianOutput out)  +MissingArgPtg.write(LittleEndianOutput out)  void -UnknownPtg.write(LittleEndianOutput out)  +ExpPtg.write(LittleEndianOutput out)  void -ErrPtg.write(LittleEndianOutput out)  +UnknownPtg.write(LittleEndianOutput out)  void -IntPtg.write(LittleEndianOutput out)  +ErrPtg.write(LittleEndianOutput out)  void -UnionPtg.write(LittleEndianOutput out)  +IntPtg.write(LittleEndianOutput out)  void -FuncVarPtg.write(LittleEndianOutput out)  +UnionPtg.write(LittleEndianOutput out)  void -TblPtg.write(LittleEndianOutput out)  +FuncVarPtg.write(LittleEndianOutput out)  +void +TblPtg.write(LittleEndianOutput out)  + + abstract void Ptg.write(LittleEndianOutput out)  - + void Area2DPtgBase.write(LittleEndianOutput out)  - + void MemFuncPtg.write(LittleEndianOutput out)  - + void NameXPtg.write(LittleEndianOutput out)  + +void +Deleted3DPxg.write(LittleEndianOutput out)  + protected void AreaPtgBase.writeCoordinates(LittleEndianOutput out)  Modified: poi/site/publish/apidocs/org/apache/poi/util/package-use.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/util/package-use.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/util/package-use.html (original) +++ poi/site/publish/apidocs/org/apache/poi/util/package-use.html Thu Jul 24 15:01:16 2014 @@ -890,9 +890,15 @@ HSSF concepts. -LittleEndianInput  +Internal +
    Program elements annotated @Internal are intended for + POI internal use only.
    + +LittleEndianInput  + + LittleEndianOutput  Modified: poi/site/publish/apidocs/org/apache/poi/xssf/model/ExternalLinksTable.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/model/ExternalLinksTable.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xssf/model/ExternalLinksTable.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xssf/model/ExternalLinksTable.html Thu Jul 24 15:01:16 2014 @@ -194,13 +194,26 @@ extends getDefinedNames()  +java.lang.String +getLinkedFileName() +
    Returns the last recorded name of the file that this + is linked to
    + + + java.util.List<java.lang.String> getSheetNames()  - + void readFrom(java.io.InputStream is)  + +void +setLinkedFileName(java.lang.String target) +
    Updates the last recorded name for the file that this links to
    + + void writeTo(java.io.OutputStream out)  @@ -330,6 +343,27 @@ extends + + +
      +
    • +

      getLinkedFileName

      +
      public java.lang.String getLinkedFileName()
      +
      Returns the last recorded name of the file that this + is linked to
      +
    • +
    + + + +
      +
    • +

      setLinkedFileName

      +
      public void setLinkedFileName(java.lang.String target)
      +
      Updates the last recorded name for the file that this links to
      +
    • +
    Modified: poi/site/publish/apidocs/org/apache/poi/xssf/model/class-use/ExternalLinksTable.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/model/class-use/ExternalLinksTable.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xssf/model/class-use/ExternalLinksTable.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xssf/model/class-use/ExternalLinksTable.html Thu Jul 24 15:01:16 2014 @@ -87,16 +87,16 @@

    Uses of ExternalLinksTable in org.apache.poi.xssf.usermodel

    - + - + Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFEvaluationWorkbook.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFEvaluationWorkbook.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFEvaluationWorkbook.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFEvaluationWorkbook.html Thu Jul 24 15:01:16 2014 @@ -102,8 +102,6 @@ extends java.lang.Object implements FormulaRenderingWorkbook, EvaluationWorkbook, FormulaParsingWorkbook
    Internal POI use only
    -
    Author:
    -
    Josh Micich
    @@ -139,20 +137,56 @@ implements - + + + + + + + + + + int externNameIndex) +
    HSSF Only - fetch the external-style name details
    + +
    + + + + + + + - + @@ -187,9 +221,9 @@ implements getNameText(NamePtg namePtg)  - - + + @@ -266,10 +300,12 @@ implements

    convertFromExternSheetIndex

    public int convertFromExternSheetIndex(int externSheetIndex)
    +
    XSSF doesn't use external sheet indexes, so when asked treat + it just as a local index
    Specified by:
    convertFromExternSheetIndex in interface EvaluationWorkbook
    -
    Returns:
    the sheet index of the sheet with the given external index.
    + @@ -339,23 +375,74 @@ implements EvaluationWorkbook.ExternalName getExternalName(int externSheetIndex, int externNameIndex) +
    Description copied from interface: EvaluationWorkbook
    +
    HSSF Only - fetch the external-style name details
    Specified by:
    getExternalName in interface EvaluationWorkbook
    - + + + + + + + + + + + + + @@ -394,6 +481,9 @@ implements

    getExternalSheet

    public EvaluationWorkbook.ExternalSheet getExternalSheet(int externSheetIndex)
    +
    Description copied from interface: EvaluationWorkbook
    +
    HSSF Only - fetch the external-style sheet details +

    Return will have no workbook set if it's actually in our own workbook

    Specified by:
    getExternalSheet in interface EvaluationWorkbook
    @@ -402,6 +492,23 @@ implements Returns:
    null if externSheetIndex refers to a sheet inside the current workbook
    + + + + Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFFormulaEvaluator.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFFormulaEvaluator.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFFormulaEvaluator.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFFormulaEvaluator.html Thu Jul 24 15:01:16 2014 @@ -94,13 +94,13 @@
  • All Implemented Interfaces:
    -
    FormulaEvaluator
    +
    WorkbookEvaluatorProvider, FormulaEvaluator


    public class XSSFFormulaEvaluator
     extends java.lang.Object
    -implements FormulaEvaluator
    +implements FormulaEvaluator, WorkbookEvaluatorProvider
    Evaluates formula cells.

    For performance reasons, this class keeps a cache of all previously calculated intermediate @@ -152,18 +152,24 @@ implements Method and Description

  • + + + + - + - + - + - + - + - + - + - + + + + +
    Methods in org.apache.poi.xssf.usermodel that return ExternalLinksTable Methods in org.apache.poi.xssf.usermodel that return types with arguments of type ExternalLinksTable 
    Modifier and Type Method and Description
    ExternalLinksTablejava.util.List<ExternalLinksTable> XSSFWorkbook.getExternalLinksTable() -
    Returns the ExternalLinksTable object for this workbook.
    +
    Returns the list of ExternalLinksTable object for this workbook
    intconvertFromExternSheetIndex(int externSheetIndex) convertFromExternSheetIndex(int externSheetIndex) +
    XSSF doesn't use external sheet indexes, so when asked treat + it just as a local index
    +
    static XSSFEvaluationWorkbook create(XSSFWorkbook book) 
    Ptgget3DReferencePtg(AreaReference area, + SheetIdentifier sheet) +
    Produce the appropriate Ptg for a 3d area reference
    +
    Ptgget3DReferencePtg(CellReference cell, + SheetIdentifier sheet) +
    Produce the appropriate Ptg for a 3d cell reference
    +
    EvaluationWorkbook.ExternalName getExternalName(int externSheetIndex, - int externNameIndex) 
    EvaluationWorkbook.ExternalNamegetExternalName(java.lang.String nameName, + java.lang.String sheetName, + int externalWorkbookNumber) +
    XSSF Only - fetch the external-style name details
    +
    EvaluationWorkbook.ExternalSheetgetExternalSheet(int externSheetIndex) +
    HSSF Only - fetch the external-style sheet details
    +
    EvaluationWorkbook.ExternalSheetgetExternalSheet(int externSheetIndex) getExternalSheet(java.lang.String sheetName, + int externalWorkbookNumber) +
    XSSF Only - fetch the external-style sheet details
    +
    int
    NameXPtggetNameXPtg(java.lang.String name, - int sheetRefIndex) NameXPxggetNameXPtg(java.lang.String name, + SheetIdentifier sheet) 
    EvaluationSheet
    WorkbookEvaluator_getWorkbookEvaluator() +
    Provide the underlying WorkbookEvaluator
    +
    void clearAllCachedResultValues()
    Should be called whenever there are major changes (e.g.
    static XSSFFormulaEvaluator create(XSSFWorkbook workbook, IStabilityClassifier stabilityClassifier, UDFFinder udfFinder) 
    CellValue evaluate(Cell cell)
    If cell contains a formula, the formula is evaluated and returned, @@ -171,28 +177,28 @@ implements +
    void evaluateAll()
    Loops over all cells in all sheets of the supplied workbook.
    static void evaluateAllFormulaCells(XSSFWorkbook wb)
    Loops over all cells in all sheets of the supplied workbook.
    int evaluateFormulaCell(Cell cell)
    If cell contains formula, it evaluates the formula, and saves the result of the formula.
    XSSFCell evaluateInCell(Cell cell)
    If cell contains formula, it evaluates the formula, and @@ -200,34 +206,41 @@ implements +
    void notifyDeleteCell(Cell cell)
    Should be called to tell the cell value cache that the specified cell has just become a formula cell, or the formula text has changed
    void notifySetFormula(Cell cell)
    Should be called to tell the cell value cache that the specified (value or formula) cell has changed.
    void notifyUpdateCell(Cell cell)
    Should be called to tell the cell value cache that the specified (value or formula) cell has changed.
    void setDebugEvaluationOutputForNextEval(boolean value)
    Perform detailed output of formula evaluation for next evaluation only? Is for developer use only (also developers using POI for their XLS files).
    voidsetupReferencedWorkbooks(java.util.Map<java.lang.String,FormulaEvaluator> evaluators) +
    Sets up the Formula Evaluator to be able to reference and resolve + links to other workbooks, eg [Test.xls]Sheet1!A1.
    +
    + + + +
      +
    • +

      setupReferencedWorkbooks

      +
      public void setupReferencedWorkbooks(java.util.Map<java.lang.String,FormulaEvaluator> evaluators)
      +
      Description copied from interface: FormulaEvaluator
      +
      Sets up the Formula Evaluator to be able to reference and resolve + links to other workbooks, eg [Test.xls]Sheet1!A1. +

      For a workbook referenced as [Test.xls]Sheet1!A1, you should + supply a map containing the key Test.xls (no square brackets), + and an open FormulaEvaluator onto that Workbook.

      +
      +
      Specified by:
      +
      setupReferencedWorkbooks in interface FormulaEvaluator
      +
      +
    • +
    + + + + Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html Thu Jul 24 15:01:16 2014 @@ -379,9 +379,9 @@ implements getCustomXMLMappings()  -ExternalLinksTable +java.util.List<ExternalLinksTable> getExternalLinksTable() -
    Returns the ExternalLinksTable object for this workbook.
    +
    Returns the list of ExternalLinksTable object for this workbook
    @@ -2047,13 +2047,17 @@ public 

    getExternalLinksTable

    @Internal
    -public ExternalLinksTable getExternalLinksTable()
    -
    Returns the ExternalLinksTable object for this workbook. +public java.util.List<ExternalLinksTable> getExternalLinksTable() +
    Returns the list of ExternalLinksTable object for this workbook

    The external links table specifies details of named ranges etc that are referenced from other workbooks, along with the last seen - values of what they point to.

    -
    Returns:
    the ExternalLinksTable object or null if not defined
    + values of what they point to.

    + +

    Note that Excel uses index 0 for the current workbook, so the first + External Links in a formula would be '[1]Foo' which corresponds to + entry 0 in this list.

    +
    Returns:
    the ExternalLinksTable list, which may be empty
  • Modified: poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/helpers/XSSFFormulaUtils.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/helpers/XSSFFormulaUtils.html?rev=1613157&r1=1613156&r2=1613157&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/helpers/XSSFFormulaUtils.html (original) +++ poi/site/publish/apidocs/org/apache/poi/xssf/usermodel/helpers/XSSFFormulaUtils.html Thu Jul 24 15:01:16 2014 @@ -136,8 +136,9 @@ extends java.lang.Object void -updateSheetName(int sheetIndex, - java.lang.String name) +updateSheetName(int sheetIndex, + java.lang.String oldName, + java.lang.String newName)
    Update sheet name in all formulas and named ranges.
    @@ -180,25 +181,24 @@ extends java.lang.Object

    Method Detail

    - +
    • updateSheetName

      public void updateSheetName(int sheetIndex,
      -                   java.lang.String name)
      + java.lang.String oldName, + java.lang.String newName)
      Update sheet name in all 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. The FormulaParsingWorkbook passed to the formula parser - is constructed from the old workbook (sheet name is not yet updated) and - the FormulaRenderingWorkbook passed to FormulaRenderer#toFormulaString is a custom implementation that - returns the new sheet name. + 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
      name - the new sheet name
      +
      Parameters:
      sheetIndex - the 0-based index of the sheet being changed
      oldName - the old sheet name
      newName - the new sheet name
    --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org For additional commands, e-mail: commits-help@poi.apache.org