Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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 :)  





________________________________
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



-- 
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

Context


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.