beautypg.com

Microsoft excel import options, Tagged-text import options – Adobe InCopy CC 2015 User Manual

Page 175

background image

172

Text

Last updated 6/13/2015

Extra Carriage Returns

Specifies how extra paragraph returns are imported. Choose Remove At End Of Every Line or

Remove Between Paragraphs.

Replace

Replaces the specified number of spaces with a tab.

Use Typographer’s Quotes

Ensures that imported text includes left and right quotation marks (“ ”) and apostrophes (’)

instead of straight quotation marks (" ") and apostrophes (').

Microsoft Excel import options

You can choose from these options when importing an Excel file:

Sheet

Specifies the worksheet you want to import.

View

Specifies whether to import any stored custom or personal views, or to ignore the views.

Cell Range

Specifies the range of cells, using a colon (:) to designate the range (such as A1:G15). If there are named

ranges within the worksheet, these names appear in the Cell Range menu.

Import Hidden Cells Not Saved In View

Includes any cells formatted as hidden cells in the Excel spreadsheet.

Table

Specifies how the spreadsheet information appears in the document.

Formatted Table

InCopy tries to preserve the same formatting used in Excel, although the formatting of text within

each cell may not be preserved. If the spreadsheet is linked rather than embedded, updating the link will override any
formatting applied to the table in InCopy .

Unformatted Table

The table is imported without any formatting from the spreadsheet. When this option is selected,

you can apply a table style to the imported table. If you format text using paragraph and characters styles, the formatting
is preserved even if you update the link to the spreadsheet.

Unformatted Tabbed Text

The table is imported as tab-delimited text, which you can then convert to a table in

InDesign or InCopy.

Formatted Only Once

InDesign preserves the same formatting used in Excel during the initial import. If the

spreadsheet is linked rather than embedded, formatting changes made to the spreadsheet are ignored in the linked table
when you update the link. This option isn’t available in InCopy.

Table Style

Applies the table style you specify to the imported document. This option is available only if Unformatted

Table is selected.

Cell Alignment

Specifies the cell alignment for the imported document.

Include Inline Graphics

Preserves inline graphics from the Excel document in InCopy .

Number Of Decimal Places To Include

Specifies the number of decimal places of spreadsheet figures.

Use Typographer’s Quotes

Ensures that imported text includes left and right quotation marks (“ ”) and apostrophes (’)

instead of straight quotation marks (" ") and apostrophes (').

Tagged-text import options

You can import (or export) a text file capable of taking advantage of InCopy formatting capabilities by using the tagged
text
format. Tagged-text files are text files containing information describing the formatting you want InCopy to apply.
Properly tagged text can describe almost anything that can appear in an InCopy story, including all paragraph-level
attributes, character-level attributes, and special characters.

For information on specifying tags, view the Tagged Text PDF at

www.adobe.com/go/learn_id_taggedtext_cs5_en

(PDF).