XL.Book.AddFormatFromBook
-------------------------

Copies a format definition.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [XL](component_XL.md) | [11.2](newinversion112.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "XL.Book.AddFormatFromBook"; BookRef; otherBookRef; Format ) 

**MBS**( **"XL.Book.AddFormatFromBook";** /\* Copies a format definition. \*/  
**$BookRef**; /\* The reference to the destination workbook.e.g. $book \*/   
**$otherBookRef**; /\* The reference to the source workbook.e.g. $book2 \*/   
**$Format**) /\* The index of an existing format in the source book which you want to use as a template.e.g. 0 \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| BookRef | The reference to the destination workbook. | $book |
| otherBookRef | The reference to the source workbook. | $book2 |
| Format | The index of an existing format in the source book which you want to use as a template. | 0 |

### Result

Returns index of new format or error.

### Description

Copies a format definition.  
Takes an existing format definition in one document and creates a new format in destination document by copying the properties.  
### See also

- [XL.Book.AddFontFromBook](XLBookAddFontFromBook.md)

### Release notes

- **Version 11.2**
    - Added [XL.Book.AddFontFromBook](https://www.mbsplugins.eu/XLBookAddFontFromBook.shtml) and [XL.Book.AddFormatFromBook](https://www.mbsplugins.eu/XLBookAddFormatFromBook.shtml) functions.

### Blog Entries

- [New in MBS FileMaker Plugin 11.2](https://www.mbsplugins.de/archive/2021-05-26/New_in_MBS_FileMaker_Plugin_11/monkeybreadsoftware_blog_filemaker)
- [Neues MBS FileMaker Plugin 11.2](https://www.mbsplugins.de/archive/2021-05-18/Neues_MBS_FileMaker_Plugin_112/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin 11.2 - More than 6500 Functions In One Plugin](https://www.mbsplugins.de/archive/2021-05-18/MBS_FileMaker_Plugin_112_-_Mor/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 11.2pr2](https://www.mbsplugins.de/archive/2021-04-07/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

Created 3th April 2021 , last changed 3th April 2021

  
[XL.Book.AddFormat](XLBookAddFormat.md) - [XL.Book.AddPictureContainer](XLBookAddPictureContainer.md)

[HTML Version](XLBookAddFormatFromBook.shtml)