Re: [libreoffice-l10n] YearFrac NOT IMPOWER function

Tom Davies <tomdavies04 -AT- yahoo.co.uk>
Thu, 27 Jun 2013 15:35:36 +0100 (BST)

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: Fw: [libreoffice-l10n] YearFrac NOT IMPOWER function (continued)
- Re: [libreoffice-l10n] IMPOWER function? · Andras Timar
  - Re: [libreoffice-l10n] IMPOWER function? · Mihovil Stanic

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.