[Q] What does this sentense mean? "If given the number to whose multiple the value is rounded, else -1 or 1 depending on sign of Number."

l10n
#1

Hello.

I'm translating LibO UI master from pootle.
I faced a sentence which I couldn't understand at all.
Is anyone helps me?

UI master - sc - source - ui - src -
1451 line : "If given the number to whose multiple the value is rounded,
else -1 or 1 depending on sign of Number."

I guess this is about rounding or ceiling numbers. but that's all. no idea.
https://gerrit.libreoffice.org/#/c/6767/2/sc/source/ui/src/scfuncs.src,cm

please help me.
thank you.

#2

You can read the standard, maybe it is clearer:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018606_715980110
Some examples:
=CEILING(23.2,1) is 24
=CEILING(23.2,5) is 25
=CEILING(23.2,9) is 27

Regards,
Andras

#3

Hello.

I'm translating LibO UI master from pootle.

General note: Please always give the unit-link - makes stuff much easier.

I faced a sentence which I couldn't understand at all.
Is anyone helps me?

UI master - sc - source - ui - src -
1451 line : "If given the number to whose multiple the value is rounded,
else -1 or 1 depending on sign of Number."

The parameter is the steps to use when rounding up. So when you
specify 5, it is rounded to the next multiple of 5, if you specify 20,
it is rounded to the next multiple of 20. If it is missing, it is the
next whole number (a multiple of 1)

ciao
Christian

#4

Hi :slight_smile:
Blimey! The OASIS description does make it a lot easier to understand.
It's still difficult to wrap my head around! I can see why it was tricky
trying to get that down to such a short summary! Could that original
queried summary be expanded easily? I'd guess not but jic my guess is
wrong i think it's worth asking. I take it that space there is seriously
limited (otherwise the original summary would have been longer, i'm sure)?

Andras' examples make it MUCH clearer, to me, than either of the
descriptions. I think they are the only thing that could improve the Oasis
description. Thanks Andras, that was brilliant! :slight_smile:

There is another native English-speaker who joined this mailing list a
couple of years ago specifically to try to help with questions like this.
So, please don't be afraid to ask :slight_smile: This one was possibly tooo technical
but in the past we had a whole spate of ones that were much easier to
answer. I'm not sure if it's possible to simplify the Oasis description
but if it's needed i'm sure Anne or others would be happy to help.

Good luck and many regards from
Tom :slight_smile:

#5

(i had written this only to one address (email) , i did not see they
are several, and now i copy to all including mailing list.)

i think there are missing commas, and different words used for one
thing. it should be:

If given, the number to whose multiple the Value is rounded, else -1
or 1 depending on sign of the Value.