Sign in to follow this  
Followers 0
vin1

macro for Libre Office Calc

4 posts in this topic

#1 ·  Posted (edited)

how can i create an autoit program fro Libre Office Calc that writes in column D, from row 15 to 36 randomly chosen rows with random values (numbers) within an array of number values

eg: randomly chosen, column D, row 24 random value = "5" from array of numbers (8, 5, 9, 3, 0, 1, 22, 55) looping to a number limit eg: 100 values written even if repeat

 

libreoffiemacro.jpg

Edited by vin1

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

Take a look here, https://help.libreoffice.org/Common/Scripting. There are some API to do what you want in any language that you want :)

Hi!

Edited by Nessie

My UDF: NetInfo UDF Play with your network, check your download/upload speed and much more! YTAPI Easy to use YouTube API, now you can easy retrive all needed info from a video. NavInfo Check if a specific browser is installed and retrive other usefull information. YWeather Easy to use Yahoo Weather API, now you can easily retrive details about the weather in a specific region. No-IP UDF Easily update your no-ip hostname(s).

My Script: Wallpaper Changer Change you wallpaper dinamically, you can also download your wallpaper from your website and share it with all!   My Snippet: _ImageSaveToBMPConvert an image to bmp format. _SciteGOTO Open a file in SciTE at specific fileline. _FileToHex Show the hex code of a specified file

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

what about .txt files? can an autoit program do the same thing with .txt files? Ln 15 to 36?

Edited by vin1

Share this post


Link to post
Share on other sites

Or search the forum for an Open Office UDF. You will find something like >this. Maybe at least a good starting point.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0