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




----- Forwarded Message -----
> 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?
> >
> >
> > 2013/6/27 Mihovil Stanic <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 <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?
> > > >     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<l10n%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
> > 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