[SOLVED] Openoffice mod, modulo function?

[MBantz]

Hey all,

just messing around with Calc, v. 3.2.0, Zen (upgraded) and can't get modulo to work. Haven't used Calc much, but I'm expert in Excel....

The 'function guide' tell me that mod is an unknown function - the danish translation 'rest' is also unknown. Using the guide further, it suggest REST() () and I try REST(25)(3) which throw an error 509

I try:

=mod(25; 3) and this result in #NAVN (name in english)

the translation of mod to danish is REST and

=rest(25;3) also results in #NAVN


Does the english version work (I'll drop the danish version then) - or do I need a function addon lib??

thanks
MBantz

[organica]

I tried this using Calc 3.2.1 and it converted the semicolon to a comma.  Have you tried typing a comma instead of the semicolon?

[pinoc]

Hi MBantz,
don't know why this happens in 3.2.0 but maybe that got fixed in the current version 3.2.1 (run GOO to update OO)?  
just a guess, have not tested it though.
best,
-p.

[MBantz]

Thanks,

tried comma, no result,

trying upgrade,

I'll post back.....

[MBantz]

Solved!

Upgrade to 3.2.1 did it,

now I can do a rest(25;3) and get a result.

The english version mod(25;3) throws an error, this must be by design - and now I only hope I can use this sheet in both english and danish systems...

Thanks to all :-)

cheers,
MBantz