# using OooDev to for easy access to LibreOffice
from ooodev.dialog.msgbox import MsgBox
from ooodev.macro.macro_loader import MacroLoader
import numpy as np

def np_ex01(*args):
    with MacroLoader():
        # using MacroLoader so we can use OooDev in macros
        x = np.arange(15, dtype=np.int64).reshape(3, 5)
        # Create a 2-D array, set every second element in
        # some rows and find max per row:
        x[1:, ::2] = -99
        _ = MsgBox.msgbox(str(x), "Numpy 01")
        # array([[  0,   1,   2,   3,   4],
        #        [-99,   6, -99,   8, -99],
        #        [-99,  11, -99,  13, -99]])

        _ = MsgBox.msgbox(str(x.max(axis=1)).center(50), "x.max(axis=1)")
        # array([ 4,  8, 13])

def np_ex02(*args):
    with MacroLoader():
        # using MacroLoader so we can use OooDev in macros.
        # Generate normally distributed random numbers:
        rng = np.random.default_rng()
        samples = rng.normal(size=2500)
        _ = MsgBox.msgbox(str(samples), "Numpy 02")


g_exportedScripts = (np_ex01, np_ex02)