Using data spreading in a websheet

You can use data spreading to enter or edit numeric data in a websheet with a predefined distribution method, called a data spread method.

For example, you can evenly distribute a value across a range of cells or increment all values in a range of cells by a percentage.

Note: TM1® Web saves the spread values to either the copy of an uploaded Excel file on the TM1 server or to the original location of an attached Excel file, depending on how the file was added to TM1 Web. You do not need to submit the data after TM1 Web completes the spread.

Procedure

  1. To spread data in a websheet, right-click on a cell and select Data spread.
  2. From the Spreading menu, select any data spread method.