DataPilot table, which is called PivotTable in Microsoft Office Excel, is one of the key features of Spreadsheet editor. DataPilot table is a useful tool to summarize and analyze large volumes of data. It is widely used in various spreadsheet applications. Lotus Symphony Spreadsheet team have been working on this feature for multiple releases to enhance the functionality and usability to meet spreadsheet user's requirements. We are still working on further improvement, so please try Lotus Symphony 1.3 and tell us your thoughts.
DataPilot's User Interface has been enhanced make this feature easier to use and more efficient. By using the brand new DataPilot sidebar, users can change the DataPilot table structure by dragging and dropping the fields, and the modification of the structure is applied at once.
Besides the sidebar, there are also some new functions enhanced in Lotus Symphony 1.3.
- Show or hide some data items of a field easily via a filter panel by checking or setting top N options.
- Sort a field: users can sort the data as manually, ascending, descending for specific fields.
- The width of column is resized automatically per the data. Users can also set the table option to enable or disable this feature.
- Drill down to details: you can double click the cell in DataPilot table to show the detailed data.
- User can set the display method of data values in data area . For example, to display the data value as percentage of total number, or relative to another field.:
Furthermore, since Symphony 1.3 has not yet supported easy formatting of a DataPilot table, we designed a default table style for users; for people who used this function for the first time, we provided more description on the empty table on how to manipulate the table. There are possibly more details for you to find out.
In addition to everything we added so far we are working on some other enhancements in coming releases. For example, we have improved the performance of calculating a DataPilot table algorithm, but still more work are ongoing. Your input is highly appreciated and will help us to prioritize the work.