IMPOWER function?

Mihovil_Stanic · June 27, 2013, 10:22am

https://translations.documentfoundation.org/hr/libo_ui/scaddins/source/translate.html#unit=29745986

Why is "integer" power mentioned in english string?
As I understand and by looking at support article on Microsoft Excel help pages, you can use any power number, for example integer(eg. 3), decimal (eg. 0,5 or 1/2 fraction) or negative (eg. -3).
http://office.microsoft.com/en-us/excel-help/impower-function-HA102752983.aspx?CTT=5&origin=HA102752955

Does integer here stands for "whole number" without decimals or something else?

Also, result of this formuladoesn't follow default decimal separator for language in use.
For example, if you apply this formula:
=IMPOWER("2+3i";1/2)

Result is:
1.67414922803554+0.895977476129838i

When for croatian locale it should be:
1,67414922803554+0,895977476129838i

Best regards,
Mihovil

Sergio_Marques · June 27, 2013, 11:27am

It´s true. Even the ODF Formula standarts state it so.

"Returns the complex number X raised to the Yth power."

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018122_715980110

Mihovil_Stanic · June 27, 2013, 11:34am

I'll translate it without "integer" in croatian then, but english string should be corrected.

Best regards,
Mihovil

Dana 27.6.2013. 13:27, Sérgio Marques je napisao:

Olivier_Hallot · June 27, 2013, 11:36am

The issue on the locale happens with py-BR which also uses commas for
decimal separation and dots for thousands.
Linux, LibreOffice 4.0.4, pt-BR locale.

- --
Olivier Hallot
Founder, Board of Directors Member - The Document Foundation
The Document Foundation, Zimmerstr. 69, 10117 Berlin, Germany
Fundação responsável civilmente, de acordo com o direito civil
Detalhes Legais: http://www.documentfoundation.org/imprint
LibreOffice translation leader for Brazilian Portuguese
+55-21-8822-8812

Mihovil_Stanic · June 27, 2013, 11:59am

And another mistake:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#YEARFRAC
https://translations.documentfoundation.org/hr/libo_ui/scaddins/source/analysis.po/translate/#unit=29746327

Word "interest" doesn't belong here.

Best regards,
Mihovil

Dana 27.6.2013. 13:27, Sérgio Marques je napisao:

Sergio_Marques · June 27, 2013, 1:02pm

And another mistake:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-
v1.2-os-part2.html#YEARFRAC<http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#YEARFRAC>
https://translations.**documentfoundation.org/hr/**
libo_ui/scaddins/source/**analysis.po/translate/#unit=**29746327<https://translations.documentfoundation.org/hr/libo_ui/scaddins/source/analysis.po/translate/#unit=29746327>

Word "interest" doesn't belong here.

True. Will fix it on my locale.

Thanks

Tom_Davies · June 27, 2013, 1:18pm

Hi
The note under it makes more sense;
"Returns the serial number of the date that is a specified number of months before or after the start date"

So the user specifies a time-interval and this function tells you what the date would be after you give it the start date?

I'm not sure i could find a simpler way of saying it than that and my way and the note looks quite horrible.
Good luck! Regards from
Tom

Tom_Davies · June 27, 2013, 1:20pm

Hi
Sorry! I think i should have broken my last response into a new thread. We were no longer talking about IMPOWER. I think we had started talking about YearFrac instead.

Apols and regards from

Tom

From: Tom Davies <tomdavies04@yahoo.co.uk>
To: Sérgio Marques <smarquespt@gmail.com>; Mihovil Stanic <mihovil.stanic@gmail.com>
Cc: LibreOffice-l10n <l10n@global.libreoffice.org>
Sent: Thursday, 27 June 2013, 14:17
Subject: Re: [libreoffice-l10n] IMPOWER function?

Hi
The note under it makes more sense;
"Returns the serial number of the date that is a specified number of months before or after the start date"

So the user specifies a time-interval and this function tells you what the date would be after you give it the start date?

I'm not sure i could find a simpler way of saying it than that and my way and the note looks quite horrible.
Good luck! Regards from
Tom

________________________________
From: Sérgio Marques <smarquespt@gmail.com>
To: Mihovil Stanic <mihovil.stanic@gmail.com>
Cc: LibreOffice-l10n <l10n@global.libreoffice.org>
Sent: Thursday, 27 June 2013, 14:02
Subject: Re: [libreoffice-l10n] IMPOWER function?

And another mistake:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-
v1.2-os-part2.html#YEARFRAC<http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#YEARFRAC>
https://translations.**documentfoundation.org/hr/**
libo_ui/scaddins/source/**analysis.po/translate/#unit=**29746327<https://translations.documentfoundation.org/hr/libo_ui/scaddins/source/analysis.po/translate/#unit=29746327>

Word "interest" doesn't belong here.

True. Will fix it on my locale.

Thanks

Best regards,
Mihovil

Dana 27.6.2013. 13:27, Sérgio Marques je napisao:

It´s true. Even the ODF Formula

standarts state it so.

"Returns the complex number X raised to the Yth power."

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-
v1.2-os-part2.html#__**RefHeading__1018122_715980110<http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018122_715980110>

2013/6/27 Mihovil Stanic <mihovil.stanic@gmail.com <mailto:
mihovil.stanic@gmail.**com <mihovil.stanic@gmail.com>>>

https://translations.**documentfoundation.org/hr/**
libo_ui/scaddins/source/**translate.html#unit=29745986<https://translations.documentfoundation.org/hr/libo_ui/scaddins/source/translate.html#unit=29745986>

Why is "integer" power mentioned in english string?
As I understand and by looking at support article on Microsoft
Excel help pages, you can use any power number, for example
integer(eg. 3), decimal (eg. 0,5 or 1/2 fraction) or negative (eg.

-3).

http://office.microsoft.com/en-us/excel-help/impower-
function-HA102752983.aspx?CTT=**5&origin=HA102752955<http://office.microsoft.com/en-us/excel-help/impower-function-HA102752983.aspx?CTT=5&origin=HA102752955>

Does integer here stands for "whole number" without decimals or
something else?

Also, result of this formuladoesn't follow default decimal
separator for language in use.
For example, if you apply this formula:
=IMPOWER("2+3i";1/2)

Result

is:

1.67414922803554+0.**895977476129838i

When for croatian locale it should be:
1,67414922803554+0,**895977476129838i

Best regards,
Mihovil

-- To unsubscribe e-mail to: l10n+unsubscribe@global.**
libreoffice.org <l10n%2Bunsubscribe@global.libreoffice.org>
<mailto:l10n%2Bunsubscribe@**global.libreoffice.org<l10n%252Bunsubscribe@global.libreoffice.org>
>

Problems?

Tom_Davies · June 27, 2013, 1:21pm

Hi
Looks right. I'm guessing a few other locales have the same issue with commas and stops.
Regards from
Tom

Mihovil_Stanic · June 27, 2013, 1:37pm

Yes, it's about YEARFRAC , but I don't see that sentence there.
YEARFRAC calculates time in YEARS between 2 dates.

So if you enter start date 1.1.2013 / end date 1.7.2013, result will be 0,5 years because there is exactly 6 month (0,5 year) betweent those dates.

My report is for description of variable "Basis" which is optional variable.
In description there is word "interest" which doesn't belong.

It should be ignored by translators and deleted from english string.

Best regards,
Mihovil

Dana 27.6.2013. 15:20, Tom Davies je napisao:

Sergio_Marques · June 27, 2013, 2:13pm

Where did you find this note?

Regards

Tom_Davies · June 27, 2013, 2:35pm

Hi
The note was to do with YearFrac, i think. It was on this page
https://translations.documentfoundation.org/hr/libo_ui/scaddins/source/analysis.po/translate/#unit=29746327

Regards from
Tom

________________________________
From: Tom Davies <tomdavies04@yahoo.co.uk>
To: LibreOffice-l10n <l10n@global.libreoffice.org>
Sent: Thursday, 27 June 2013, 14:20
Subject: Fw: [libreoffice-l10n] YearFrac NOT IMPOWER function

Hi
Sorry! I think i should have broken my last response into a new thread. We were no longer talking about IMPOWER. I think we had started talking about YearFrac instead.

Apols and regards from

Tom

From: Tom Davies <tomdavies04@yahoo.co.uk>
To: Sérgio Marques <smarquespt@gmail.com>; Mihovil Stanic <mihovil.stanic@gmail.com>
Cc: LibreOffice-l10n <l10n@global.libreoffice.org>
Sent: Thursday, 27 June 2013, 14:17
Subject: Re: [libreoffice-l10n] IMPOWER function?

Hi
The note under it makes more sense;
"Returns the serial number of the date that is a specified number of months before or after the start date"

So the user specifies a time-interval and this function tells you what the date would be after you give it the start date?

I'm not sure i could find a simpler way of saying it than that and my way and the note looks quite horrible.
Good luck! Regards from
Tom

________________________________
From: Sérgio Marques <smarquespt@gmail.com>
To: Mihovil Stanic <mihovil.stanic@gmail.com>
Cc: LibreOffice-l10n <l10n@global.libreoffice.org>
Sent: Thursday, 27 June 2013, 14:02
Subject: Re: [libreoffice-l10n] IMPOWER function?

And another mistake:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-

v1.2-os-part2.html#YEARFRAC<http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#YEARFRAC>

https://translations.**documentfoundation.org/hr/**
libo_ui/scaddins/source/**analysis.po/translate/#unit=**29746327<https://translations.documentfoundation.org/hr/libo_ui/scaddins/source/analysis.po/translate/#unit=29746327>

Word "interest" doesn't belong here.

True. Will fix it on my locale.

Thanks

Best regards,
Mihovil

Dana 27.6.2013. 13:27,

Sérgio Marques je napisao:

It´s true. Even the ODF Formula

standarts state it so.

"Returns the complex number X raised to the Yth power."

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-
v1.2-os-part2.html#__**RefHeading__1018122_715980110<http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018122_715980110>

2013/6/27 Mihovil Stanic <mihovil.stanic@gmail.com <mailto:
mihovil.stanic@gmail.**com <mihovil.stanic@gmail.com>>>

https://translations.**documentfoundation.org/hr/**
libo_ui/scaddins/source/**translate.html#unit=29745986<https://translations.documentfoundation.org/hr/libo_ui/scaddins/source/translate.html#unit=29745986>

Why is "integer" power mentioned in english string?
As I understand and by looking at support article on Microsoft
Excel help pages,

you can use any power number, for example

integer(eg. 3), decimal (eg. 0,5 or 1/2 fraction) or negative (eg.

-3).

http://office.microsoft.com/en-us/excel-help/impower-
function-HA102752983.aspx?CTT=**5&origin=HA102752955<http://office.microsoft.com/en-us/excel-help/impower-function-HA102752983.aspx?CTT=5&origin=HA102752955>

Does integer here stands for "whole number" without decimals or
something else?

Also, result of this formuladoesn't follow default decimal
separator for language in use.
For example, if you apply this formula:

=IMPOWER("2+3i";1/2)

Result

is:

1.67414922803554+0.**895977476129838i

When for croatian locale it should be:
1,67414922803554+0,**895977476129838i

Best regards,
Mihovil

-- To unsubscribe e-mail to: l10n+unsubscribe@global.**
libreoffice.org <l10n%2Bunsubscribe@global.libreoffice.org>
<mailto:l10n%2Bunsubscribe@**global.libreoffice.org<l10n%252Bunsubscribe@global.libreoffice.org>
>

Problems?

Tom_Davies · June 27, 2013, 2:43pm

Hi
It is just under the blue section, about half-way down this page
https://translations.documentfoundation.org/hr/libo_ui/scaddins/source/analysis.po/translate/#unit=29746327

I am not familiar with the work-flow nor the UI used by translators so i have no idea if that section of the page is meant to be useful.
Regards from
Tom

Mihovil_Stanic · June 27, 2013, 2:49pm

That is string from different function called EDATE.
Only opened string, in the middle of that page is from YEARFRAC.

Best regards,
Mihovil

Dana 27.6.2013. 16:43, Tom Davies je napisao:

Tom_Davies · June 27, 2013, 3:09pm

Hi
Ahhh, that's why this link is better
http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#YEARFRAC

"YearFrac
Summary: Extracts the number of years (including fractional part) between two dates"
Regards from
Tom

timar · June 28, 2013, 10:12am

Hi,

I fixed the confusing text, but only in master, because there is string
freeze on the libreoffice-4-1 branch. The wrong text has been there
since 2004, so I think it is not extremely urgent to fix it in branches.
Your proofreading work is much appreciated.

Thanks,
Andras

timar · June 28, 2013, 10:44am

Probably it worked with only integers when the help text was written.
Microsoft Excel help pages may be misleading, too, because they describe
Excel, not LibreOffice. The best it to make some experiments and read
the ODF specs. It seems that LibreOffice accepts real powers but not
complex powers. I fixed the help text accordingly in master. Thanks for
your bug report.

Best regards,
Andras

Mihovil_Stanic · June 28, 2013, 10:52am

One of collegues provided link to ODF pages which also doesn't say anything about integer and formula is working with all types of numbers.

Thanks for changes.

Best regards,
Mihovil

Dana 28.6.2013. 12:44, Andras Timar je napisao:

Tom_Davies · June 28, 2013, 11:03am

Hi
Thanks :) However it is other people that are doing the hard work of proof-reading tons of pages of this sort of thing and then flagging up the odd problems that have crept in over the years.

I can make suggestions quite easily because i happen to be a native English speaker. It's not always an advantage because i don't always know the rules and i do make typos sometimes and my version of English is (GB) rather than (US) so prepositions are sometimes mixed up. However it is great to see that i've been able to shake a few sentences up so that people on this list can get to a decent answer.

So, many thanks for your thanks but the thanks is really deserved by yourself and others here. You are all doing a fantastic job and that is very much appreciated.
Many thanks and regards from
Tom

Tom_Davies · June 28, 2013, 11:12am

Hi
Yes, if it's been wrong for 9 years then another 1 month or so is unlikely to cause major problems. Fixing in Master sounds like the correction will automatically start to ripple out to everywhere it needs to be as soon as the freeze is over and then get translated as people get to it. So, that all sounds good
Thanks and regards from
Tom