"Peter Ruman" <[EMAIL PROTECTED]> napísal v správe news:[EMAIL PROTECTED] > > "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
OK, so I've tried OOo 2.0.4 and it did solve the problem... Well, life's full of surprises :) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
