macro for Libre Office Calc

[vin1 0]

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

 

Edited June 4, 2013 by vin1

[Nessie 30]

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 June 5, 2013 by Nessie

[vin1 0]

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

Edited June 5, 2013 by vin1

[water 2,118]

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