Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 9.2   9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5    Statistic    FMM    Blog  

XL.CopyColumn

Copies cells from one column to another column.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 10.5 Yes Yes Yes Yes Yes
MBS( "XL.CopyColumn"; bookRef1; bookRef2; sheetIndex1; sheetIndex2; SourceCol; DestCol { ; Options } )   More

Parameters

Parameter Description Example Flags
bookRef1 The reference to the source workbook. Please use XL.LoadBook to load a file. $ref
bookRef2 The reference to the destination workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex1 The source index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
sheetIndex2 The destination index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
SourceCol The source col index. $scol
DestCol The destination col index. $dcol
Options Which items to skip when copying content. "" Optional

Result

Returns OK or error.

Description

Copies cells from one column to another column.
Source and destination can be in different sheets/books.
This copies most properties and all cells.
If something is missing, please let us know.

OptionDescription.
SkipPicturesDon't copy pictures.
SkipMergesDon't copy merged cells.
SkipNamedRangesDon't copy named ranges.
SkipPrintAreaDon't copy print area.
SkipPrintRepeatDon'T copy print repeat
SkipPrintFitDon't copy print fit.
SkipHorPageBreakDon't copy horizontal page breaks.
SkipCommentsDon't copy cell comments.
SkipFormatsDon't copy formats.
SkipRowHiddenDon't copy hidden rows.
SkipColHiddenDon't copy hidden columns.

Examples

Copy 3rd column to 5th:

Set Variable [ $r ; Value: MBS( "XL.CopyColumn"; $bookRef; $bookRef; $sheet; $sheet; 2; 4 ) ]

See also

Blog Entries

Release notes

  • Version 10.5
    • Added XL.CopyColumn function.

Created 30th September 2020, last changed 30th September 2020


XL.Color.UnPack   -   XL.CopyContent

Feedback: Report problem or ask question.




Links
MBS Xojo Plugins