Using the Workbench´s report area to edit your table
for simple editing and export to EXCEL (applies to version 9.5 and later)

Last update: Dec 30 2019

The "Workbench" in any CDendro sample window has a large report area. The most basic Windows editing operations are here available. E.g. you can select text and delete it. You can insert text anywhere. You can copy text (Ctrl-C) and you can paste it back (Ctrl-V).

If you want to copy a CDendro table to a spreadsheet program like EXCEL, then things become a little tricky: You have to make the spreadsheet program understand which are the columns of data and which are not.

With the collection foursamples.rwl and the sample 6680NY.wid as a reference, use “Test towards ref.” to run a correlation. Then sort on TT (click the TT column header) and click “Test towards ref.” again to get an updated sorted text table. Select and copy that table and paste it into the report area on the Workbench of 6680NY:


Using Clear rectangle:
Say that you want to remove the middle part of this table, i.e. the wide column headed “Best match for P2YrsL------“.
For that, select that column as shown below, i.e. with the selection starting with “Best” and ending with “6.2  1985”
Then click the button “Clear rectangle” to get this result:

Using “Shift Clear rectangle” to retrieve a rectangle:
Say you want only the leftmost main column, then select as shown below:
Then hold down the “Shift”-key and click the “Clear rectangle” button

Exporting the table to EXCEL
By default EXCEL understands the tab character as a column separator. The button “Tabify report and copy to clipboard” (see pictures above) will replace all space character sequences with a tab character and then copy the text onto the clipboard from where you can paste it into your EXCEL spread sheet:


Copyright © 2019, Cybis Elektronik & Data AB, www.cybis.se