Apache OpenOffice Community Forum

Posted: **Fri Oct 31, 2008 2:25 pm**

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

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

Posted: **Tue Nov 25, 2008 10:45 pm**

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)

Apache OpenOffice Community Forum

Calc Copy Cell format

Calc Copy Cell format

Re: Calc Copy Cell format