Calc Copy Cell format

Keyboard macros or custom scripts

Calc Copy Cell format

Postby ANteC » 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:
Code: Select all   Expand viewCollapse view
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
Posts: 10
Joined: Tue Apr 15, 2008 11:07 am

Re: Calc Copy Cell format

Postby gdd » 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)
Basic information: OOo version 3.0.0 / VS + Dutch languagepack / Windows XP
(Posts before 14th October OOo version 2.4 or 2.3)
OOo 3.0.X on Ms Windows XP
Posts: 54
Joined: Mon Feb 11, 2008 9:54 am
Location: Netherlands

Return to OpenOffice Basic, Python, BeanShell, JavaScript

Who is online

Users browsing this forum: Google [Bot] and 6 guests