ReportTweak - Array Sheet

When the Array Sheet is used in conjunction with ReportTweak reports, you can easily work with data that is spread out across a SheetSet. If you have multiple annotation from a single DataSet spread across multiple sheets in a SheetSet, you can view the entire DataSet at a glance using the Array Sheet. You can also move annot from one sheet to another, copy a single view to all sheets in the SheetSet, or search for specific data all on a single sheet.

If you are working with a large number of sheets, consider Altering the Array Sheet.

While in the Array Sheet, and ReportTweak is toggled on, special buttons are displayed in the margins of the top right and lower left corners of the sheet.

Active Sheet (toggle)

If the box is filled in, the sheet is currently the Active Sheet

The Active Sheet has menu options that may only apply to a sheet marked as Active

• Send to Active Sheet
• Select all Annot from Active Sheet

New Sheet

1. New - creates a new sheet in the array
   1. The new sheet will be added adjacent to the button used to create the sheet
      1. If the button on the top left border of the sheet is clicked, the new sheet will be added prior to the current sheet
      2. If the button on the bottom right border of the sheet is clicked, the new sheet will be appended
         
2. Ctrl + - creates a new sheet and copies the view that is on the sheet you clicked the New button on to the new sheet

Delete Sheet

• Delete - deletes the sheet that you click the Delete button on
• Ctrl + - the sheet that you click the Delete button on will be removed without the confirmation dialog

Ghost Mode

Shows annot in Ghost form, i.e., only text (DataSet row or Feature Label and Characteristic, and DataSet label) and view outlines are displayed.  In this mode, reports are drawn faster when there are numerous sheets and annot in the SheetSet. It also allows for quick navigation and layout of your documents.

1. Ghost - only "ghosts" the annot on the sheet that you click the ghost mode button
2. Ctrl + - puts the entire SheetSet into "Ghost" mode

Hide Sheet

To hide the sheet, click the Hide button on the sheet that you want to hide.

• Hide - conceals the sheet in the array

Show Sheet

Shows the sheet that is adjacent to the one on which the Show Sheet icon is selected.

1. Show - reveals a hidden sheet in the array
   1. If the button on the top left border of the sheet is clicked, the sheet hidden to prior to the current sheet will be shown
   2. If the button on the bottom right border of the sheet is clicked, the sheet hidden to after the current sheet will be shown
2. ctrl + - shows all consecutive hidden sheets that are adjacent to the selected Show button
   1. The number of consecutive hidden sheets will be displayed inside the glyph

Can we improve this topic?