Spreadsheet Destination Dialog Options

The Spreadsheet Destination Dialog allows the user to select three different file formats for the destination spreadsheet file. Optionally the user may edit or view the results in the spreadsheet designer prior to saving the file.

Edit or View the Results

This option will invoke the Excel Workbook Designer (spreadsheet editor). The spreadsheet may be modified and saved or simply viewed or printed.

Launch the Associated Application

If the user has installed software for editing (or viewing) the saved file format, this option will invoke that software and load the new file for editing (or viewing).

Select - Edit or View the Results - the output is sent to a spreadsheet that is not saved.

Named Output

Select Excel Spreadsheet, HTML Document, or ASCII Export, and it is saved to a named file - each feature has a default filename.

You can optionally Launch the Associated Application as well.

The default filenames for Bug Tracker is as follows:

bugtracker.xls - bugtracker.htm - bugtracker.csv

It is saved by default to the EZChangeLog Main Data folder, unless you redirect to a Project Folder. This is illustrated in the following screen shots.

You can change this default name at the Destination File Name prompt or in the Save As prompt location as well.

Redirect to a Project Folder - click on Browse

Navigate to Project Folder

Accept default name or change - Click Save button.

TIP!

If you haven't created at least one Change Log entry AND exported it, a project folder will not have been created, and won't appear in the list of sub folders located in the main EZChangelog folder.

Existing Filename - Confirm if you want to replace it.

Processing Records window before Spreadsheet display

Saved Spreadsheet is displayed (IF you chose to launch the application)

Suggestion on saving spreadsheets!

When you save and launch a spreadsheet report - save the spreadsheet in Microsoft Excel. The saved format produced by EZChangeLog Reporter might display a warning when reopened in Excel. Saving the spreadsheet in Excel at least once will avoid this warning.

If working with Excel 2007, save in one of the following formats as desired.

Page url: http://www.encouragersoftware.com/help/index.html?spreadsheet_destination_dialog.htm