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 <tomdavie...@yahoo.co.uk> >To: Sérgio Marques <smarque...@gmail.com>; Mihovil Stanic ><mihovil.sta...@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 <smarque...@gmail.com> >>To: Mihovil Stanic <mihovil.sta...@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.sta...@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.sta...@gmail.com <mailto: >>>> mihovil.stanic@gmail.**com <mihovil.sta...@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%2bunsubscr...@global.libreoffice.org> >>>> >>>><mailto:l10n%2Bunsubscribe@**global.libreoffice.org<l10n%252bunsubscr...@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%2bunsubscr...@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+unsubscr...@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+unsubscr...@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