This extension provides pseud-random number generator based on Mersenne Twister algorithm which has 2^19937 -1 period, as an spreadsheet function add-in. And the generator as an UNO component is also provided.

Implementation of the generator is based on Richard J. Wagner's C++ MTRand class.

How to Install

1. Install the extension package from Tools - Extension Manager.
2. Re-start your office.

Spreadsheet functions

=MTRAND()

Generates pseud-random number between 0 to 1 in [0,1).
This result is one of 32-bit random numbers.

=MTRANDBETWEEN(Bottom;Top)

Generates pseud-random integer number between Bottom to Top in [Bottom,Top].

You can specify a seed for initialization of the generator through Tools - Options - Calc - MT Random page. See help page for detail.

They can be found in the Mathematical category.

UNO component: mytools.math.MTRandom service.

Original RAND function should use MT, and an issue is opened: http://www.openoffice.org/issues/show_bug.cgi?id=14730 .

Platform	Télécharger	Détails sur le produit	Date	Taille
Linux		0.2.1	2010-nov.-21	69.89 Ko
Windows		0.2.1-Win32	2010-nov.-21	56.75 Ko
Windows		0.2.2	2011-déc.-06	55.75 Ko
Linux		0.2.2-Linux-x86	2011-déc.-06	68.29 Ko

Signaler les abus ici