Advanced comment options (dialog)

The Advanced comment options dialog lets you specify rules under which specific ranges of a Microsoft® Excel® document, marked using the Mark selected ranges dialog, are  importedas comments into memoQ.

How to begin

You can invoke the Advanced comment options dialog when importing a Microsoft® Excel® file, from the Document import settings dialog by selecting Import through Office Interop and then clicking Use advanced commenting, then Comment options.

Use

The dialog has two sections, Non-commented data ranges and Comment rules for other ranges:

•The Non-commented data ranges section enables you to specify ranges in the Microsoft® Excel® file, which are not to be commented.

•The Comment rules for other ranges section lets you specify ranges in the Microsoft® Excel® file for which comments will be imported. These comments are imported according to rules you specify for each of the ranges using the Rule for the top-left cell input box.
 

Non-commented data ranges section:

•Select ranges: Click this button to start Microsoft® Excel® and to open the Mark selected ranges dialog to mark non-commented cells, rows or columns in Microsoft® Excel® directly. Any ranges you select using the Mark selected ranges dialog will be recorded as Microsoft® Excel® codes in the Non-commented data ranges list.

These codes have the following structure:

 
{name of worksheet}!{top left cell}:{bottom right cell}

•Remove: Click this button to remove a selected range from the list.

•Remove all: Click this button to remove all ranges from the list.
 

Comment rules for other ranges section:

Select ranges: Click this button to start Microsoft® Excel® and to open the Mark selected ranges dialog to mark commented cells, rows or columns in Microsoft® Excel® directly. Any ranges you select using the Mark selected ranges dialog will be recorded as Microsoft® Excel® codes in the Comment rules for other ranges pane.

These codes have the following structure:

 
{name of worksheet}!{top left cell}:{bottom right cell}

See the screenshot above.

•Remove: Click this button to remove a selected range from the pane.

•Remove all: Click this button to remove all ranges from the pane.

•Range: This field indicates the range selected in the Comment rules for other ranges pane.

•Rule for the top-left cell: Use this field to specify the required comment rule, relative to the top-left cell of the range. This field is shaded in red if the code you enter is not valid.

Note: For example, if the source text is in the B3:B27 range and the corresponding comments are in the C3:C27 range, the range selected in the Comment rules for other ranges pane should be B3:B27, where the top-left cell is B3, which means that the rule for cell B3 should be C3 or $C3.

The rules you specify are shown in the Comment rules for other ranges section in brackets, next to the ranges they apply to.

If a certain range of your Microsoft® Excel® file is imported as comments and you do not want to have the range imported for translation, which is often the case, mark this section as non-translatable using the means in the Document import settings dialog (Non-translatable data ranges section).

Navigation

After you have made all your settings in the Advanced comment options dialog, click Close to close dialog and return to the Document import settings dialog.