Autofilling macro

Creating a macro - Writing a Script - Using the API

Autofilling macro

Postby Faladrath » Mon May 13, 2019 12:13 am

Hi

I wish to fill a box with a color and a number once another box has numbers put it.
How do I do this?
open office 4.1
Faladrath
 
Posts: 1
Joined: Mon May 13, 2019 12:11 am

Re: Autofilling macro

Postby UnklDonald418 » Mon May 13, 2019 3:15 am

Your question is too vague to give a specific answer.
Is your "box" a control on a Base form, a shape on a Draw page or maybe a cell on a Calc spreadsheet?
To learn the basics of macros including using the Macro Recorder see Chapter 13 of the Getting Started User Guide
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/OOo3.3_User_Guide_Chapters
To learn about coding macros in Star Basic, download Andrew Pitonyak's book "OpenOffice.org Macros Explained"
http://www.pitonyak.org/oo.php
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1163
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Autofilling macro

Postby RusselB » Mon May 13, 2019 6:46 am

If, by "box" you are referring to a cell in a spreadsheet, then this can be done using functions and formulas that are already available, without having to write a macro.
As UnklDonald stated, your question is much too vague, thus we need more specific details... at minimum, I would think, the application that you are actually working in.
In addition to the 3 options already mentioned, a Writer document is also a possibility that I can think of as an option for what you have stated you wish to do.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5104
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Macros and UNO API

Who is online

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