Autofilling macro

Creating a macro - Writing a Script - Using the API

Autofilling macro

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


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
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
To learn about coding macros in Star Basic, download Andrew Pitonyak's book " Macros Explained"
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 - Windows 10 Professional
Posts: 1326
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.7 and LibreOffice 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
Posts: 6106
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 4 guests