"Terry" <[EMAIL PROTECTED]> napísal v správe news:[EMAIL PROTECTED] > 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
OK, I guess it means end of work for me :). I guess this part of macro will have to be carried out by hand by the end user, it's not that much work and I don't intend to spend any more time on this (it's a one-time-task-only, so I don't intend to dig deeper into OOo programming). Perhaps I will give it a try with OOo 2.0.4. If that will work things out, I don't see a problem, even if it means upgrading OOo on 10+ computers. Anyway, thank you for your cooperation and time. Peter --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
