macros and writing to cells

Discuss the spreadsheet application

macros and writing to cells

Postby duncanbbd » Sun Dec 09, 2007 10:33 pm

Hi,
I am writing a simple macro and wish to fill some cells. I have an example from an Excel spreadsheet which uses the "Cells(1,1) = 200" format as an example.

I can't seem to do this in openoffice, i.e 'cells' is not a valid function. (I do see however other specific functions from OO to do this), but the project is for university and I have to submit as an XLS file so I'd like to be able to use 'Cells' function.

is there some information on the compatibility of writing to cells across OO and XLS ?

thanks for any help.
duncanbbd
 
Posts: 1
Joined: Sun Dec 09, 2007 10:27 pm

Re: macros and writing to cells

Postby RonIA » Mon Dec 10, 2007 12:17 am

Sorry, the macro languages between OO.o and MS Office are not compatible. Anything you find out about how to address a particular cell in OO.o will not translate when you save as XLS format.
Ron from Iowa, USA
RonIA
Volunteer
 
Posts: 139
Joined: Mon Oct 08, 2007 1:34 am
Location: Iowa USA

Re: macros and writing to cells

Postby Villeroy » Mon Dec 10, 2007 12:22 am

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27295
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 23 guests