Aspose::Cells::Cell::GetPrecedents method

Cell::GetPrecedents method

Gets all references appearing in this cell’s formula.

ReferredAreaCollection Aspose::Cells::Cell::GetPrecedents()

ReturnValue

Collection of all references appearing in this cell’s formula.

Remarks

  • Returns null if this is not a formula cell.
  • All references appearing in this cell’s formula will be returned no matter they are referenced or not while calculating. For example, although cell A2 in formula “=IF(TRUE,A1,A2)” is not used while calculating, it is still taken as the formula’s precedents.
  • To get those references which influence the calculation only, please use GetPrecedentsInCalculation().

Examples

Aspose::Cells::Startup();
Workbook workbook;
Cells cells = workbook.GetWorksheets().Get(0).GetCells();
cells.Get(u"A1").SetFormula(u"=B1+SUM(B1:B10)+[Book1.xls]Sheet1!A1");
ReferredAreaCollection areas = cells.Get(u"A1").GetPrecedents();
for (int i = 0; i < areas.GetCount(); i++)
{
    ReferredArea area = areas.Get(i);
    U16String stringBuilder = "";
    if (area.IsExternalLink())
    {
        stringBuilder += u"[";
        stringBuilder += area.GetExternalFileName();
        stringBuilder += u"]";
    }
    stringBuilder += area.GetSheetName();
    stringBuilder += u"!";
    stringBuilder += CellsHelper::CellIndexToName(area.GetStartRow(), area.GetStartColumn());
    if (area.IsArea())
    {
        stringBuilder += u":";
        stringBuilder += CellsHelper::CellIndexToName(area.GetEndRow(), area.GetEndColumn());
    }

    std::cout << stringBuilder.ToUtf8() << std::endl;
}
Aspose::Cells::Cleanup();

See Also

Aspose::Cells::Cell::GetContainsExternalLink method Aspose::Cells::Cell::GetDependents method