Examples of com.extentech.formats.XLS.Shrfmla

com.extentech.formats.XLS.Shrfmla

SHRFMLA is a file optimization that stores many identical formulas once. The SHRFMLA record appears immediately after the first FORMULA record in the group. Each FORMULA record in the group will have fShrFmla set and will contain only a PtgExp pointing to the cell containing the SHRFMLA record.

Occasionally Excel writes a FORMULA record with fShrFmla set whose expression is an instantiation of the relevant shared formula instead of the usual PtgExp. We currently handle these by clearing fShrFmla. At some point in the future we will attempt to detect which shared formula is applied and make the cell a member of its group.

ExtenXLS does not currently create shared formulas or add cells to existing ones. Existing shared formulas will be preserved in output. Removal of formulas from the group is supported, including the cell currently hosting the SHRFMLA record. Shared formula member cells will be reference-tracked and recalculated properly.

 OFFSET NAME        SIZE CONTENTS 0      rwFirst     2    First Row 2      rwLast      2    Last Row 4      colFirst    1    First Column 5      colLast     1    Last Column 6      (reserved)  2    pass through, zero for new 8      cce         2    Length of the parsed expression 10     rgce        cce  Parsed Expression

      
  /**
   * custom RefTracker usage:  uses entire range covered by all shared formulas
   */
  public PtgArea getArea() {
    Shrfmla sh= (Shrfmla) this.getParentRec();
      int[] i = new int[4];
        if (fRwRel) {
            i[0] = sh.getFirstRow() + firstPtgN.rw;
        }else {
            i[0] = firstPtgN.rw;
        }
        if (fColRel) {
            i[1] = sh.getFirstCol() + firstPtgN.col;
        }else {
            i[1] = firstPtgN.col;
        }
        if (fRwRel) {
            i[2] = sh.getLastRow() + lastPtgN.rw;
        }else {
            i[2] = lastPtgN.rw;
        }
        if (fColRel) {
            i[3] = sh.getLastCol() + lastPtgN.col;
        }else {
            i[3] = lastPtgN.col;
        }
        
      if (i[1]>=MAXCOLS_BIFF8 &&

Examples of com.extentech.formats.XLS.Shrfmla

Related Classes of com.extentech.formats.XLS.Shrfmla