There are several ways of resetting, reverting, and otherwise clearing settings in Spread Designer. If you have made changes in Spread Designer that you do not want to apply, and you want to continue to work in the Spread Designer, you can reset all the sheet setting, you can revert to when Spread Designer was opened, or you can clear certain cells.

To revert to the original settings that were in the FpSpread component at the time you opened Spread Designer, from the File menu choose Revert, then click Yes in the confirmation dialog. The component in Spread Designer is restored to the settings that were in the component at the time you opened Spread Designer. This action is not available if you are running Spread Designer stand-alone (outside of a development environment). This removes all the settings, including data, that were added after you opened the Designer.

To reset all the settings in the Spread Designer, including deleting all the data in the component, from the File menu choose New, then click Yes in the confirmation dialog. The component in Spread Designer then has all properties for all objects set back to their default values, and all data is removed, and all sheets beyond the first one are removed. For more information on resetting items, refer to Setting and Resetting User Interaction. This does not affect the preference settings for working with the Spread Designer, only the data and settings for the component being designed.

To clear the cells, select the cells and from the context menu, select Clear. This removes the data and formatting from those cells.

For more tasks in Spread Designer, return to Working with the Design.