________________________________
From: Mihovil Stanic <mihovil.stanic@gmail.com>
To: Tom Davies <tomdavies04@yahoo.co.uk>
Cc: "l10n@global.libreoffice.org" <l10n@global.libreoffice.org>
Sent: Thursday, 27 June 2013, 15:49
Subject: Re: Fw: [libreoffice-l10n] YearFrac NOT IMPOWER function
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:
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
------------------------------------------------------------------------
*From:* Mihovil Stanic <mihovil.stanic@gmail.com>
*To:* l10n@global.libreoffice.org
*Sent:* Thursday, 27 June 2013, 14:36
*Subject:* Re: Fw: [libreoffice-l10n] YearFrac NOT IMPOWER function
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:
> 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 :)
>
>
>
>
> ----- Forwarded Message -----
>> From: Tom Davies <tomdavies04@yahoo.co.uk
<mailto:tomdavies04@yahoo.co.uk>>
>> To: Sérgio Marques <smarquespt@gmail.com
<mailto:smarquespt@gmail.com>>; Mihovil Stanic
<mihovil.stanic@gmail.com <mailto:mihovil.stanic@gmail.com>>
>> Cc: LibreOffice-l10n <l10n@global.libreoffice.org
<mailto: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
<mailto:smarquespt@gmail.com>>
>>> To: Mihovil Stanic <mihovil.stanic@gmail.com
<mailto:mihovil.stanic@gmail.com>>
>>> Cc: LibreOffice-l10n <l10n@global.libreoffice.org
<mailto:l10n@global.libreoffice.org>>
>>> Sent: Thursday, 27 June 2013, 14:02
>>> Subject: Re: [libreoffice-l10n] IMPOWER function?
>>>
>>>
>>> 2013/6/27 Mihovil Stanic <mihovil.stanic@gmail.com
<mailto:mihovil.stanic@gmail.com>>
>>>
>>>> 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> <mailto:
>>>>> mihovil.stanic@gmail. <mailto:mihovil.stanic@gmail.>**com
<mihovil.stanic@gmail.com <mailto: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. <mailto:unsubscribe@global.>**
>>>>> libreoffice.org <l10n%2Bunsubscribe@global.libreoffice.org
<mailto:2Bunsubscribe@global.libreoffice.org>>
>>>>>
<mailto:l10n%2Bunsubscribe@**global.libreoffice.org<l10n%252Bunsubscribe@global.libreoffice.org
<mailto:252Bunsubscribe@global.libreoffice.org>>
>>>>>
> Problems?
>>>>> http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
>>>>>
unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
>>>>> Posting guidelines + more:
>>>>>
http://wiki.**documentfoundation.org/**Netiquette<http://wiki.documentfoundation.org/Netiquette>
>>>>> List archive:
http://listarchives.**libreoffice.org/global/l10n/<http://listarchives.libreoffice.org/global/l10n/>
>>>>> All messages sent to this list will be publicly
archived and
>>>>> cannot be deleted
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Sérgio Marques
>>>>>
>>>>
>>>> --
>>>> To unsubscribe e-mail to: l10n+unsubscribe@global.
<mailto:unsubscribe@global.>**libreoffice.org<l10n%2Bunsubscribe@global.libreoffice.org
<mailto:2Bunsubscribe@global.libreoffice.org>>
>>>> Problems?
http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
>>>>
unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
>>>> Posting guidelines + more:
http://wiki.**documentfoundation.org/**
>>>> Netiquette <http://wiki.documentfoundation.org/Netiquette>
>>>> List archive:
http://listarchives.**libreoffice.org/global/l10n/<http://listarchives.libreoffice.org/global/l10n/>
>>>> All messages sent to this list will be publicly archived and
cannot be
>>>> deleted
>>>>
>>>>
>>>
>>> --
>>> Sérgio Marques
>>>
>>> --
>>> To unsubscribe e-mail to:
l10n+unsubscribe@global.libreoffice.org
<mailto:unsubscribe@global.libreoffice.org>
>>> Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>> Posting guidelines + more:
http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://listarchives.libreoffice.org/global/l10n/
>>> All messages sent to this list will be publicly archived and
cannot be deleted
>>>
>>>
>>>
>>
--
To unsubscribe e-mail to: l10n+unsubscribe@global.libreoffice.org
<mailto:unsubscribe@global.libreoffice.org>
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/l10n/
All messages sent to this list will be publicly archived and
cannot be deleted
--
To unsubscribe e-mail to: l10n+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/l10n/
All messages sent to this list will be publicly archived and cannot be deleted
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.