Hi Tom
That's another route to go. I'll give it a go. Hope I can do it without
signing up to that list.
Hi Jean, it may well be the reason that it's still there. Makes doing
the docs a real time-consuming pain though.
As a by-the-by, the location for the two new functions AVERAGEIF and
AVERAGEIFS is in the Mathematical category on the Function Wizard. The
other AVERAGE, AVEDEV and AVERAGEA functions are in the Statistical
category. In Excel all these functions are in the Statistical category.
As the first two are new functions I'm wondering if they have been
wrongly located? How do we ask that question, and to whom? I'm going to
ignore it in the docs and write it as I find it, maybe it'll get changed
later.
Feedback from reporting the Function Wizard bug crashing LO is that it
will be fixed for 4.1.3. I'll keep an eye on it and remove the Caution
from Calc chapter 7 when it's done.
Regards
JohnS
On 18/09/2013 12:35, Tom Davies wrote:
Hi :)
This looks like a question that might be good to pass on to the Users
Mailing List? They might have answers to the 2 questions here.
Since you can't get Convert to work it might be good to post a
bug-report anyway and then wait for feedback from the Users List.
I keep getting told off for liaising between lists so it would be
better if you posted the question there rather than me passing it on
to them.
Regards from
Tom :)
------------------------------------------------------------------------
*From:* Jean Weber <jeanwe...@gmail.com>
*To:* John Smith <clicks...@yahoo.co.uk>
*Cc:* documentation <documentation@global.libreoffice.org>
*Sent:* Wednesday, 18 September 2013, 11:43
*Subject:* Re: [libreoffice-documentation] CONVERT function in Calc
Isn't it, and some other functions, still there so old spreadsheets
that used it will still work? (Just a guess; I don't know.)
--Jean
On 18/09/2013, at 20:17, John Smith <clicks...@yahoo.co.uk
<mailto:clicks...@yahoo.co.uk>> wrote:
> Thanks Shelagh and Steve.
> CONVERT_ADD is the next function in the Function Wizard list, and I
hadn't yet reached that one. It looks, from reading the Help files, as
if that one supersedes CONVERT as the function to use for converting
units. I don't know why the function has been left in.
> In the Help, it says; "The functions whose names end with _ADD
return the same results as the corresponding Microsoft Excel
functions". But, does opening a Calc spreadsheet containing
CONVERT_ADD, in Excel, cause an error?
>
> Because I can't get CONVERT to work I think I may raise a bug. If
it's a dead function then it will hopefully get removed. I can't see
much use for a function for dead European currencies.
>
> Regards
> JohnS
> On 17/09/2013 22:41, shelagh.man...@gmail.com
<mailto:shelagh.man...@gmail.com> wrote:
>> I searched on Google - apparently convert should be convert_add and
the list of units you can use (and works 'cause I tried some out) can
be found for the help of that function.
>>
>> Now the question is, is it a documentation bug that the convert
function is mentioned in the help, if you are supposed to use
convert_add? Or perhaps convert is for a limited set of conversions. I
just tried the exact example given for the convert function in the
help and that works for converting deutchmarks to euros.
>>
>> Cheers
>>
>> Shelagh
>>
>>
>> On 18 September 2013 06:45, John Smith <clicks...@yahoo.co.uk
<mailto:clicks...@yahoo.co.uk> <mailto:clicks...@yahoo.co.uk
<mailto:clicks...@yahoo.co.uk>>> wrote:
>>
>> Hi all.
>> I'm working on the Appendix B chapter for Calc and I am looking at
>> the =CONVERT function. This function converts a numerical value
>> from one unit of measure, to another unit of measure in the same
>> group, for example feet into yards, both in the distance group.
>> Within the dialogue of the Function Wizard is a statement
>> "Converts a value according to a conversion table in the
>> configuration (main.xcd)".
>>
>> My question is basically a two parter; is this list available to a
>> user, and if so how do you access it? and because the two
>> parameters in the function for units are both case sensitive and
>> entered inside quotes, how do you find what the valid entries are
>> for these parameters?
>> The syntax is CONVERT(Number, "text", "text") where text is the
>> unit of conversion.
>>
>> I have tried a few of the entries which I found here;
>>
http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#CONVERT
>> such as "lbm" and "stone" for mass, "pt" and "qt" for volume and
>> "ft" and "in" for distance, without success.
>>
>> Pulling my hair out here:-) . Please help.
>>
>> Regards
>> JohnS
>>
>> -- To unsubscribe e-mail to:
>> documentation+unsubscr...@global.libreoffice.org
<mailto:unsubscr...@global.libreoffice.org>
>> <mailto:documentation%2bunsubscr...@global.libreoffice.org
<mailto:2bunsubscr...@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/documentation/
>> All messages sent to this list will be publicly archived and
>> cannot be deleted
>>
>>
>
>
> --
> To unsubscribe e-mail to:
documentation+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/documentation/
> All messages sent to this list will be publicly archived and cannot
be deleted
--
To unsubscribe e-mail to:
documentation+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/documentation/
All messages sent to this list will be publicly archived and cannot be
deleted
--
To unsubscribe e-mail to: documentation+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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted
