Tinkerer wrote:
I was trying to convert 'one and two
If you can upload a test file with typical inputs, then someone (maybe
even me?) could have a look at writing a function (Calc function or
Macro) that addresses your need(s).
Regards
Stephan
--
Unsubscribe instructions: E-mail to
Thank you Stephan
I copied and pasted the quantities in text from an article.
In the end it was quicker to print it out and just type them in, but I
thought using CT2N would guarantee the accuracy.
Do you think there would be much demand for such a function?
Best regards, Tink.
--
View this
Tinkerer wrote:
BTW. I should be able to Convert text to Numbers using the Value() function,
in which case, I would not need CT2N.
I have tried using Value several ways and all I get is either #Value, or
Error 502.
Hi Tinkerer,
could you perhaps upload a test file of where this function is
Hi Stephan
It appears I may be at fault here.
The Bug is: 38314
According to Libre Guide Value() requires that you type in the text to be
converted eg 123 and not one two three, neither will a cell reference
suffice.
As for CT2N that bug remains, though I have been told I must contact the
My most abject apologies to all concerned.
Both problems CT2N and Value() require whole numbers as a quotation.
eg '2 or 3
They then remove the quote marks.
I was trying to convert 'one and two
May I ask to be forgiven,
Tink.
--
View this message in context:
WHo :)
Congrats :) Yes, forgiven if you have got it workingnow :) At least from me.
Regards from
Tom :)
From: Tinkerer j_taylo...@btinternet.com
To: users@global.libreoffice.org
Sent: Wed, 15 June, 2011 19:13:32
Subject: [libreoffice-users] Re: CT2N
--
View this message in context:
http://nabble.documentfoundation.org/CT2N-Extension-tp3043414p3063831.html
Sent from the Users mailing list archive at Nabble.com.
--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to
June, 2011 17:58:36
Subject: [libreoffice-users] Re: CT2N Extension.
--
View this message in context:
http://nabble.documentfoundation.org/CT2N-Extension-tp3043414p3063831.html
Sent from the Users mailing list archive at Nabble.com.
--
Unsubscribe instructions: E-mail to users+h
On 2011-06-14, Tom Davies wrote:
Hi :)
It seems that none of the OpenOffice Extensions are available now? Can
anyone
confirm or better still, suggest where to get extensions from now?
The extension service servers are working... kind of.
It sometimes does not serve images or
: [libreoffice-users] Re: CT2N Extension.
On 2011-06-14, Tom Davies wrote:
Hi :)
It seems that none of the OpenOffice Extensions are available now? Can
anyone
confirm or better still, suggest where to get extensions from now?
The extension service servers are working... kind of.
It sometimes does
On 2011-06-14, Tom Davies wrote:
From: Nuno J. Silva nunojsi...@ist.utl.pt
On 2011-06-14, Tom Davies wrote:
It seems that none of the OpenOffice Extensions are available now? Can
anyone
confirm or better still, suggest where to get extensions from now?
The extension service servers are
Sent: Tue, 14 June, 2011 19:07:22
Subject: Re: [libreoffice-users] Re: CT2N Extension.
On 2011-06-14, Tom Davies wrote:
From: Nuno J. Silva nunojsi...@ist.utl.pt
On 2011-06-14, Tom Davies wrote:
It seems that none of the OpenOffice Extensions are available now? Can
anyone
confirm
Many thanks Tom.
I have replaced CT2N with a fresh download and it still does not work.
It appears as an Add On CT2NThe menu appears.
Clicking on Whole sheet, or Selected produces a Nil result.
Have you checked this and filed a bug?
Tink.
--
View this message in context:
, 14 June, 2011 19:55:15
Subject: [libreoffice-users] Re: CT2N Extension.
Many thanks Tom.
I have replaced CT2N with a fresh download and it still does not work.
It appears as an Add On CT2NThe menu appears.
Clicking on Whole sheet, or Selected produces a Nil result.
Have you checked this and filed
BTW. I should be able to Convert text to Numbers using the Value() function,
in which case, I would not need CT2N.
I have tried using Value several ways and all I get is either #Value, or
Error 502.
Tink.
--
View this message in context:
Tinkerer wrote (14-06-11 20:55)
I have replaced CT2N with a fresh download and it still does not work.
It appears as an Add On CT2NThe menu appears.
Clicking on Whole sheet, or Selected produces a Nil result.
Have you checked this and filed a bug?
No need to file a bug.
Step in the
Tinkerer wrote (14-06-11 21:10)
BTW. I should be able to Convert text to Numbers using the Value() function,
in which case, I would not need CT2N.
I have tried using Value several ways and all I get is either #Value, or
Error 502.
Prolly some changes from 3.3. 3.0 in handling numbers/strings.
[typo in previous]
Tinkerer wrote (14-06-11 21:10)
BTW. I should be able to Convert text to Numbers using the Value() function,
in which case, I would not need CT2N.
I have tried using Value several ways and all I get is either #Value, or
Error 502.
Prolly some changes from 3.3. 3.4 in
:)
From: Tinkererj_taylo...@btinternet.com
To: users@global.libreoffice.org
Sent: Tue, 14 June, 2011 17:58:36
Subject: [libreoffice-users] Re: CT2N Extension.
--
View this message in context:
http://nabble.documentfoundation.org/CT2N-Extension-tp3043414p3063831.html
Sent from the Users
19 matches
Mail list logo