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