Native Excel interaction within reports

Native Excel interaction is preserved within reports. This means that you can:

  • Add formulas any place you want and they will always be preserved.
  • Format things using native Excel formatting and it is preserved.
  • Insert columns or rows any place you want and they will be preserved when dynamic reports are refreshed.

Caution: Dynamic column and row expansion by Callisto inserts and deletes columns and rows, so if you insert columns or rows in the middle of an Expand type range, they may move around unexpectedly under some expansion conditions. You will probably find the behavior easier to understand if you choose to insert columns or rows before or after an Expand type range.

  • canvasplanning/userguide/nativeexcelinteractionwithinreports.txt
  • Last modified: 2014/02/17 12:54
  • by pcevli