On Wed, 2005-02-16 at 17:33 +0100, Ennio-Sr wrote:
> * Ennio-Sr <[EMAIL PROTECTED]> [150205, 12:17]:
> > * Ian Laurenson <[EMAIL PROTECTED]> [150205, 14:51]:
> > > Ennio-Sr wrote:
> > > [...]
> > >
> > > I did a quick google for "Lotus Millennium macros 123" and it appears to
> > > be referring to a book.
> > > Are you saying that you need more documentation
> > > for writing macros in OOo or that the macros that came with the book you
> > > require equivalents for Calc?
> > > If the latter, say what macros you would
> > > require and maybe I and others can write / help you write them.
> >
> > This is very kind of you. However, as I said above, I have no precise
> > idea right now. Generally speaking the .123 feature I would miss much is
> > the possibility to write a series of commands on subsequent (vertical)
> > cells, give the first cell a single letter 'range' name and be able to
> > run the full sequence of commands, any time you want, just pressing ALT
> > (or CTRL)+letter.
> >
> > If time comes that I tackle again the subject I'll remember your offer
> > ...
>
> Well, time might have come sooner than expected :-)
> I realized I had an OOo copy of a file with macros, originally written
> as a .123 file (maybe I migrated it through Excel and/or Gnumeric a few
> months ago).
> I see that formulas I had in the cells have been translated and seem to
> work.
> As to macros, you know they work differently on the two programs:
> in .123 you define a range (with a single letter or number) for the
> first of a vertical group of cells where you put the instructions to be
> executed when that range is called (pressing Ctrl+letter). May be these
> are not macros, but 'recorded keystrokes sequences' [I cannot check
> right now in the original]. I wonder how could I reproduce them in OOo:
> should I construct a macro for each of them or there is a quicker way?
> As a first example:
>
> {goto}saldar~/c~{down}~ # goto range named 'saldar' and copy it to ..
> /rndsaldar~
> /wtc{goto}ap1~
>
> This sequence was associated to the Ctrl+0 keystroke and was
> automatically executed when the file was opened. Should I repeat all the
> steps with the macro-recorder up and then save it as a macro?
>
> Thanks for your attention.
> Regards.
> Ennio.
>
>
>
Check if http://www.ooomacros.org/user.php#104617 duplicates what
happens in 123.
--
Documentation Co-Lead
PLEASE - keep list traffic on the list. Email sent directly to me may
be ignored utterly.
"Dinna meddle wi' things ye ken nuthin' aboot!"
J.Herriot
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
