Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

  • If a formula references cells above all data marker rows, ExcelWriter will not move or modify it.

  • * If a formula references cells below a data marker row, the references will be updated if new rows are inserted between the data marker row and the cells referenced in the formula.
    *
  • If a formula references a data marker cell, the formula will be "stretched" to include the imported cell values.
    \

Example

In the ExcelWriter template, cell A11 contains the formula =SUM(A9:A9).

...