You can copy data from Chronolator Integrate to another program by using the system Clipboard

Copy to the Clipboard

Copying the table

Use one of the buttons above the table to copy it.

  • the Copy (data) button copies the selected event, or the entire chronology if no event is selected. Columns in the resulting clipboard item are separated by tabs, and might need to be converted to a table in the receiving application. Any line breaks in the table will be converted to the ` character.
  • the Copy (formatted) button copies the entire chronology. The resulting clipboard item will be pasted as a table in the receiving application, and line breaks are automatically converted.Any colours applied to the table will be preserved (except if you are using Firefox).

Copying the current display

  • press the Clipboard button on the Print / Copy group on the Ribbon to copy the display in the active Presentation Area.

Paste the Clipboard

You can paste the clipboard into another application such as Microsoft Word or Excel (or, indeed, any other).


In Microsoft Office applications, you can paste the clipboard by using the Paste button on the Home tab, or by pressing Ctrl+V.


The following instructions assume you are pasting into a new, blank Microsoft Office document.

After pasting

Excel

Excel should automatically split the data into columns when you paste it into a blank spreadsheet.

Word

If you have used the Copy (formatted) button, Word will produce a table when you paste it as long as you press the Keep source formatting option on the small Paste Options menu:


(for more information, see this Microsoft article).


If you accidentally paste as plain text, or have used the Copy (data) button, you will need to convert it to a table like this:


  • Select All (Ctrl+A)
  • Convert the selection to a table using the Insert tab, choosing Table > Convert text to table and using all the defaults

Line breaks: Word and Excel

If you used the Copy (data) button, or pasted as plain text, any line breaks in the table will have been transformed into the ` character.


Do the following to change them back into line breaks:


  • Select All (Ctrl+A)
  • Open the Replace dialog (Ctrl+H)
  • Type ` in the Find What box. You should find the ` character at the top left of your keyboard


  • (In Word): Type ^p in the Replace with box. You should find the ^ character with Shift+6
  • (In Excel): Type Ctrl+Shift+J in the Replace with box


  • Press Replace All