Calc Copy Cell format

[ANteC]

Hello. Please help me solve problem:
There is two xls files. I need copy cell format from one file to another.
I try:

Code: Select all

SheetTemplate.getCellByPosition(nn+Smechenie, hh + Pos).NumberFormat = SheetSource.getCellByPosition(nn, hh + Pos).NumberFormat

i understand that this code wrong, becouse NumberFormat of 2 different files is different.

Sorry my english

[gdd]

Hi ANteC,

No need for a macro

To move: Select the cells and drag them into the other spreadsheet
To copy: Do the same and use the Ctrl key also. (look at the little + sign at the mouse pointer)