Peter Ruman wrote:
"Terry" <[EMAIL PROTECTED]> napísal v správe
news:[EMAIL PROTECTED]
Peter Ruman wrote:
Hello,
I'm creating macro in Calc that should (besides other things) add inner
and outer borders to a group of cells. As I am a beginner in OOo, I'm
using the macro recorder to record the actions and then modifying the
actions to suit my needs. So I recorded a macro of following actions:
1. select group of cells,
2. add inner borders using menu.
The recorded macro follows:
<snip>
The problem is that when I run the code, it doesn't work. It acts as it's
working - selects proper group of cells, but doesn't add the borders. But
when I do the same (recording a macro and playing it back) with outer
borders, it works fine. Can anyone please tell me, what is wrong and how
do I work this out?
Thanks in advance :)
Peter Ruman
Hi. I've run the recorded code. It selected a group of cells and failed
to add any border.
You may have used the dialogue of Format >Cells incorrectly. What exactly
did you do and what did you hope to achieve?
Why do you need separate macros for the borders?
Hi. I don't think I have used it incorrectly. I just selected a group of
cells, clicked Format->Cells, then clicked the Borders tab, chose width of
the border, clicked the inner borders and then OK. Exactly like I do it
everytime, whether I'm recording a macro or not. You see, the problem is not
that I'm doing it wrong. The problem is I record the macro, the effects of
my actions are normally applied to the spreadsheet, but when I try to
reproduce the effects by running the recorded macro, somehow I don't get
them. The macro does exactly what you wrote - selects a group but doesn't
add any border.
I don't need separate macros, just posted it as a separate one. It's part of
a larger macro code, but it would be of no use to post it here completely.
Well, try it for yourself (record the same macro, play it back and see if
you get the results) and if you succeed, please post the code. I'd be very
grateful.
P.S. - <snip>... OOo version is
2.0.2.
I've just recorded and run a macro inserting internal borders in a
selection. With the same result as you. It looks like a bug. It
probably has not been fixed, but, like you, I am using version 2.0.2 and
I have no intention of changing that.
There is a macro recorder for Calc which uses StarBasic. It may have
been extended now but, when I used it, it was limited to recording
changes to a single cell. Even so, it helped me to compose my own
macros for borders. If necessary, I or someone else could fairly easily
provide you with StarBasic code not involving the dispatcher. I know
that you could also find such code on the forum both in the Code
Snippets forum and the Macros and API forum. I take it that you want
all borders of each cell within your selection.
The link to the other recorder is http://www.ooomacros.org/dev.php#104617
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
