SAP Financial Consolidation Web User Guide

Excel Web Schedule cells containing spread formulas

Cells containing spread formulas start with SPREAD.

There are three different types of cell:

  • SPREADM cells, which are specific to Financial Consolidation and are generated when the schedule is open.
  • SPREADD cells, which are specific to Financial Consolidation and are generated when you create local modeling enhancements.
  • SPREAD cells, which are specific to Excel and contain standard Excel formulas.

The copy,paste, and delete functions work differently for SPREAD type formulas.

When you copy or paste a cell containing a SPREADM or SPREADD type formula, the formula is not copied. Only the data in the cell is copied.

When a cell containing a SPREAD-type formula is copiedor pasted, only the formula is pasted, as is standard in Excel.