Copying Formatting With the Clone Formatting Tool

Use the Clone Formatting tool to copy formatting from a text selection or from an object and apply the formatting to another text selection or object.

  1. Select the text or object whose formatting you want to copy.

  2. On the Standard Bar, click the Clone Formatting icon. The mouse cursor will change to a paint bucket.

  3. Select or click the text or object that you want to apply the formatting to.

tip

If you want to apply the formatting to more than one selection, double-click the Clone Formatting icon Icon. After you apply all the formatting, click the icon again.


By default only the character formatting is copied ; to include paragraph formatting, hold down when you click. To copy only the paragraph formatting, hold down +Shift when you click.

warning

In Calc, the Clone Formatting tool only copies formatting applied using the Format - Cells dialog or other equivalent methods. Therefore, any formatting applied directly to characters by selecting text inside a cell and then going to the Format - Character dialog will not be copied using the Clone Formatting tool.


The paragraph formats are the formats applied to the whole paragraph. The character formats are those applied to a portion of the paragraph. For example, if you apply the bold format to a whole paragraph the bold format is a paragraph format. Then if you unbold a portion of this paragraph, the bold format is still a paragraph format but the portion you unbold has a "not bold" character format.

The following table describes the formatting attributes that the Clone Formatting tool can copy:

рдЪрдпрди рдХреА рдХрд╝рд┐рд╕реНрдо

рдЯрд┐рдкреНрдкрдгреА

рдХреБрдЫ рднреА рдЪрдпрдирд┐рдд рдирд╣реАрдВ рд╣реИ, рдкрд░рдВрддреБ рд╕рдВрдХреЗрддрдХ рдкрд╛рда рдкрд░рд┐рдЪреНрдЫреЗрдж рдХреЗ рдЕрдВрджрд░ рд╣реИ

рд╡рд░реНрддрдорд╛рди рдЕрдиреБрдЪреНрдЫреЗрдж рдХреЗ рдлрд╝реЙрд░реНрдореЗрдЯрд┐рдВрдЧ рддрдерд╛ рдкрд╛рда рдкреНрд░рд╡рд╛рд╣ рджрд┐рд╢рд╛ рдореЗрдВ рдЕрдЧрд▓реЗ рдЕрдХреНрд╖рд░ рдХреЗ рдЕрдХреНрд╖рд░ рдлрд╝реЙрд░реНрдореЗрдЯрд┐рдВрдЧ рдХреА рдирдХрд╝рд▓ рдмрдирд╛рддрд╛ рд╣реИ.

рдкрд╛рда рдЪреБрдирд╛ рдЧрдпрд╛ рд╣реИ

рдЕрдВрддрд┐рдо рдЪрдпрдирд┐рдд рдЕрдХреНрд╖рд░ рддрдерд╛ рдЬрд╣рд╛рдБ рдЕрдХреНрд╖рд░ рд╣реИ рдЙрд╕ рдЕрдиреБрдЪреНрдЫреЗрдж рдХреЗ рдлрд╝реЙрд░реНрдореЗрдЯрд┐рдВрдЧ рдХреА рдирдХрд╝рд▓ рдХрд░рддрд╛ рд╣реИ.

рдлреНрд░реЗрдо рдЪреБрдирд╛ рдЧрдпрд╛ рд╣реИ

Copies the frame attributes that are defined in Format - Frame and Object - Properties dialog. The contents, size, position, linking, hyperlinks, and macros in the frame are not copied.

рд╡рд╕реНрддреБ рдЪреБрдирд╛ рдЧрдпрд╛ рд╣реИ

Copies the object formatting that is defined in the Format - Graphics or Format - Drawing Object dialogs. The contents, size, position, hyperlinks, and macros in the object are not copied.

рдлрд╝реЙрд░реНрдо рдирд┐рдпрдВрддреНрд░рдг рдЪреБрдирд╛ рдЧрдпрд╛ рд╣реИ

Not supported

рдбреНрд░рд╛рдЗрдВрдЧ рд╡рд╕реНрддреБ рдЪрдпрдирд┐рдд рд╣реИрдВ

рд╕рднреА рдлрд╝реЙрд░реНрдореЗрдЯрд┐рдВрдЧ рдЧреБрдгреЛрдВ рдХреА рдирдХрд╝рд▓ рдмрдирд╛рддрд╛ рд╣реИ. рдЗрдореНрдкреНрд░реЗрд╕ рддрдерд╛ рдбреНрд░рд╛ рдореЗрдВ, рд╡рд╕реНрддреБ рдХреА рдкрд╛рда рд╕рд╛рдордЧреНрд░рд┐рдпрд╛рдБ рднреА рдирдХрд╝рд▓ рдХреА рдЬрд╛рддреА рд╣реИрдВ.

Text within Calc cells is selected

Not supported

рд░рд╛рдЗрдЯрд░ рддрд╛рд▓рд┐рдХрд╛ рдпрд╛ рдХрдХреНрд╖ рдЪрдпрдирд┐рдд рд╣реИрдВ

Copies the formatting that is specified in Table, Text Flow, Borders, and Background tab pages in the Format - Table dialog. The paragraph and character formatting are also copied.

рдХреЕрд▓реНрдХ рддрд╛рд▓рд┐рдХрд╛ рдпрд╛ рдХрдХреНрд╖ рдЪрдпрдирд┐рдд рд╣реИрдВ

Copies cell formatting specified using the Format - Cells dialog.


Please support us!