Mersenne Twister Random Number Generator Add-In

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.

Since Apache OpenOffice 4.0, RAND spreadsheet function uses Mersenne Twister algorithm from Boost. Therefore you do not need this extension except for the purpose for API use.

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. See here for more detail.

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