NbbTools > Documentation Applications

TsTable Component

Table of contents

General description

This component represents chronological series into a tabular way. As a component (NbbTsTable from the NbbGenericGraphics.dll) it can be inserted in .Net applications.  By default, every column represents a series whose name is the title of the column (and the contrary after a transpose command). The dimension of every zone can be modified. To do this, move the mouse cursor over the line between two zones. The cursor shape will change in a double arrow. Then, click on the line and while holding the mouse button pressed, move the mouse to change the size of the zone.

           

Back to table of contents

Mode

Two modes are available: the "Normal" mode and the "Splitted in years" mode. The Normal mode is the default one.

In "Splitted in years" mode, the table will represent the series divided in years. Only the series with a month, quarter or half-year frequency are allowed. Only one series at a time can be displayed. If the table contains more than one series, only the first one is displayed.

The user can change the mode in the Properties dialog box (see later for a description of this box).

           

Back to table of contents

Drag and Drop

 From a table, you can drag and drop into:

          - Another Table module.

            - A Graph module.

            - Excel or any program supporting drag and drop of textual data.

According to the place where the drag started, the data will be copied differently:

- From the "Top left" zone, the entire table is copied (only with the default mode).

- From a series title zone (Columns or rows title zone depending the transposed state), only this series is copied (two rows or two columns, one with the dates and one with the observations).

- From the date row or column, only the row or column of observations with the date.

When you drop series in a ts table already filled with series, the series are added at the end of the table.

For the format of series imported from Excel, please see see DataImportUK.htm document.

Back to table of contents

Menus description

Depending on the place you trigger the contextual menus (with a right mouse click), the menus will be different.

 Rows title zone :

 - Default situation with the rows title zone filled with dates.

           

Edit > Copy : load the clipboard with a copy of the selected row.

 - Situation of the rows title zone filled with series names (in the case the table was transposed)

           

Edit > Copy : load the clipboard with a copy of the selected row only (without the dates).

 Edit > Copy TS : load the clipboard with a copy of the selected series (with the dates). Even if the series was horizontal oriented, the pasted series will be vertical.

 Edit > Delete : deletes the selected series.

Back to table of contents

 Top left zone :

           

Edit > Copy : load the clipboard with a copy of the first column. With the default mode the column filled with dates and otherwise with the series names.

 Edit > Copy with headers : idem Edit > Copy.

 Edit > Copy TS : nothing happens. The clipboard is still loaded with the forelast copy command.

 Edit > Delete : nothing happens.

Back to table of contents

 Columns title zone :

 - Default situation with the columns title zone filled with series names.

           

Edit > Copy : load the clipboard with a copy of the selected column (without dates and with the color formats).

Edit > Copy with headers : load the clipboard with a copy of the selected column (with the dates and color formats).

Edit > Copy TS : load the clipboard with a copy of the selected series (with the dates but without formats).

Edit > Delete : deletes the selected series.

- Situation of the columns title zone filled with dates (in the case the table was transposed).

           

Edit > Copy : load the clipboard with a copy of the selected column (with the date title and with the color formats).

Back to table of contents

 Data zone :

To reach the general contextual menu you must click the right mouse button on any cell of the data zone excepted the current selected cell (yellowed) in this zone (you should display a usual contextual menu for editing a text field).

           

Edit Menu

           

Edit > Copy : load the clipboard with a copy of all the series table (with the dates, the color formats and the current orientation)

 Edit > Copy TsCollection : load the clipboard with a copy of all the series (with the dates but without formats and always vertical orientation even if the table was transposed).

 Edit > Paste : drops the clipboard contents in the data zone (data format must be compatible, see DataImportUK.htm document ).

 Edit > Reset : resets the whole TsTable.

 Properties menu

           

What you see in the figure above are the default values.

 Title frame :

 - Show Title : unchecked the title of the Caption text box isn't displayed.

 - Caption :  the title displayed if the check box Show Title above is checked.

 NbbTsTable frame :

 - Auto Fit Rows : if checked rows are autofitted.

 - Auto Fit Columns : if checked columns are autofitted.

 - Allow column resize : if checked, allows to resize the columns wide. The resizing action can only happen at the interface line between two columns in the title line of the table.  

 - Thousand Separator : if checked, displays a space as thousand separator.

 - Split in years : redraws a table with only the first series. One line per year, one month per column.

Back to table of contents

 Print

 Prints the complete table with the colors.

 Print Preview

 Displays a preview of the printing.

 Zoom menu

           

- Zoom In : enlarges the Ts Table.

 - Zoom Out : shrinks the Ts Table.

 - Show Normal : resets the zooming to 100%.

 - Show All : displays the whole Ts Table.

 Transpose

 Changes the table orientation. Interesting if you have too many series (more than 255) to fit in an Excel sheet and that the number of dates is less than 255.

Back to table of contents