Hi :)
The note was to do with YearFrac, i think. It was on this page
https://translations.documentfoundation.org/hr/libo_ui/scaddins/source/analysis.po/translate/#unit=29746327
Regards from
Tom :)
________________________________
From: Tom Davies <tomdavies04@yahoo.co.uk>
To: LibreOffice-l10n <l10n@global.libreoffice.org>
Sent: Thursday, 27 June 2013, 14:20
Subject: 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
Context
Re: [libreoffice-l10n] YearFrac NOT IMPOWER function · Tom Davies
Re: [libreoffice-l10n] IMPOWER function? · Sérgio Marques
Re: [libreoffice-l10n] IMPOWER function? · Andras Timar
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.