IBM Lotus Symphony


Setting DataPilot table properties

You can set properties of a DataPilot table to ignore empty rows, identify categories, calculate grand totals, and keep table formatting.

  1. Click Data > DataPilot.
  2. On the DataPilot menu, select DataPilot Table Option. In the window, select one of the following options:
    • Ignore empty rows – Ignores empty fields in the data source.
    • Identify categories – Automatically assigns an empty row with the values from the preceding row.
    • Total columns – Calculates and displays the grand total of the column calculation.
    • Total rows – Calculates and displays the grand total of the row calculation.
    • Enable show details – Double click cells of row or column in DataPilot table, some data can be displayed or hidden with this option enabled. Double click cells of data area in DataPilot table, a new sheet which contains the related source data is created with this option enabled.
    • Automatically resize column width – DataPilot table column width is auto-resized to fit the width of the contents when data changed in the DataPilot table with this option enabled.
    • Preserve formatting – Preserves formatting for Field and Data areas with this option enabled.

Product Feedback | Additional Documentation | Trademarks