Pootle - Differerences in Help Calc Strings

Hi All

I noticed, while translating, this difference between sentences/formulas, package help/calc/01.po:

=FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0,9;1;TRUE();1)

(https://translations.documentfoundation.org/it/libo_help/translate/scalc/01.po#unit=108798679)

and

=FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0.8;4;TRUE();7)

(https://translations.documentfoundation.org/it/libo_help/translate/scalc/01.po#unit=108798683)

The difference is between 0,9 and 0.8, where I think the first is not correct. Is it possible to check?

TIA, ciao

Hi Valter,

I noticed, while translating, this difference between sentences/formulas,
package help/calc/01.po:

=FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0,9;1;TRUE();1)

(https://translations.documentfoundation.org/it/libo_help/translate/scalc/01.po#unit=108798679)

and

=FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0.8;4;TRUE();7)

(https://translations.documentfoundation.org/it/libo_help/translate/scalc/01.po#unit=108798683)

The difference is between 0,9 and 0.8, where I think the first is not
correct. Is it possible to check?

Yes, 0,9 is not correct, it should be 0.9 instead.

However, even when using the data provided in the help example and
having defined the named ranges, both function calls result in an
Err:502 (invalid argument)

On Cc Winfried, can you please check?

  Eike

Hi Eike,

>>
>> =FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0,9;1;TRUE();1)
>>
>> (https://translations.documentfoundation.org/it/libo_help/translate/scalc/01.po#unit=108798679)
>>
>> and
>>
>> =FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0.8;4;TRUE();7)
>>
>> (https://translations.documentfoundation.org/it/libo_help/translate/scalc/01.po#unit=108798683)
>>
>> The difference is between 0,9 and 0.8, where I think the first is not
>> correct. Is it possible to check?
>
> Yes, 0,9 is not correct, it should be 0.9 instead.
>
> However, even when using the data provided in the help example and
> having defined the named ranges, both function calls result in an
> Err:502 (invalid argument)
>
> On Cc Winfried, can you please check?

I don't have the document where the function call originates from, so I used another document with FORECAST.ETS data and functions (as attached to tdf#97021).
The function behaves as expected.

Upon closer look, the function calls from pootle differ in another aspect as well: the argument for period length is 1 in one case and 4 in the other case. The sample document provided with the help text has data with a period length of 12 (12 months).

I can't check if named ranges Values and Timeline are correct without the document itself.

Winfried