CarlP wrote:
Terry wrote:
CarlP wrote:
CarlP wrote:
I was sure that OOo 2 was supposed to have incorporated
text-to-column functionality in Calc instead of having to install
the macro (which I haven't been able to get to work properly). But
a quick scan of archives seems to suggest you do still have to
install the macro. Is that right, or is there another way to split
one column in a spreadsheet into multiple columns based on comma,
quote, space, or other characters? This would be a VERY helpful
feature...
Carl
BTW, I have the latest macro package but still cannot figure out how
to load it. Anthony Chilco kindly sent some instructions a while
ago, but that was for an earlier version, and unfortunately his
instructions didn't match my screen options, and everything I tried
failed.
Please help me understand how to install this macro as it's an
important feature for me.
Thanks and happy holidays!
Carl
Put the downloaded file somewhere it can stay. Then use Tools
>Package Manager. That's it.
The Tools menu will acquire another branch, "Add-Ons" and "Text to
Columns" will be in that branch. The Help menu will acquire "About
text to columns". You may have to re-start OOo to get those changes.
Thanks for the suggestion, but I've never run the package manager
before, and when I try, I can select Add for "My Packages" but then
the download folders don't contain anything that looks like a package
to me. If I select some of the xba scripts in the Text-To-Columns
folder of the download, I get an error "cannot detect media type."
Now, after doing something to try to install the macro (I can't recall
what I did), I now have a library under My Macros with three routines
in it that have the same names as the macros in the download file
(there are a ton of other xba scripts in the download, none of which
are available in my libraries). I've tried running the one called
Main, which I think was the one to select when you want to run the
Text-To-Columns macro, but when I do that, it chokes with the
following highlighted:
If IsCellRangeEmpty(oSelection) Then
The error is a BASIC subroutine error with "sub-procedure or function
procedure not defined"
I've selected the cells in the column I want to run the macro on, so
that can't be the problem. It sounds like it could be a missing
sub-routine, but I can't figure out what, nor how to get it from the
download set since I can't figure out what I did to get the three
routines into My Macros in the first place.
Now, I'm reasonably talented with computers, software, databases, etc.
and can do some simple programming, and I'm committed to working with
OOo, but this process of installing macros is VERY confusing to me...
Carl
*Do NOT unzip* the package which you downloaded.
When you select "Add", you get a File Picker which you use to browse to
the file (unzipped) which you downloaded.
--
Xfce on PCLinuxOS, OOo 2.0.2 (en_GB).
Direct mail to teaman is not opened; if necessary, email realmail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
