[users] Re: CALC

2011-09-21 Thread rlarrye
unsubscribe Irv [K3IRV] McWherter irv4...@gmail.com wrote: Can someone please help me? I open CALC and there is a large window offering a selection of themes, backgrounds, etc. How do I make this window go away? Many thanks, Irv. -- “Experience hath shewn, that even under

[users] Re: Help with writing macro

2011-09-21 Thread Johnny Rosenberg
2011/9/20 Grzesiek Sójka p...@sojka.co: Hi there. I need to write a macro accepting variable length parameter list. I was tryint to googl but no luck. So the question is how to write (preferably in OpenOffice Basic) macro accepting variable length parameter list. Thanks in advance for any

[users] Re: CALC

2011-09-21 Thread David B Teague sr
On 9/21/2011 9:44 AM, rlar...@carolina.rr.com wrote: unsubscribe rlarrye: YOU have to do that yourself. How is listed at the bottom of every message you get from this list. Here is how: - *To unsubscribe send email

[users] Re: Help with writing macro

2011-09-21 Thread Grzesiek Sójka
On 09/21/11 17:08, Johnny Rosenberg wrote: Can you give an example? I'm not sure what you mean by ”accepting variable length parameter list”. I do need to get some kind of statistic-like data. So I can not make any assumptions on the number of the results specified. Lets say that my macro is

[users] Re: Help with writing macro

2011-09-21 Thread Johnny Rosenberg
2011/9/21 Grzesiek Sójka p...@sojka.co: On 09/21/11 17:08, Johnny Rosenberg wrote: Can you give an example? I'm not sure what you mean by ”accepting variable length parameter list”. I do need to get some kind of statistic-like data. So I can not make any assumptions on the number of the

[users] Re: Help with writing macro

2011-09-21 Thread Grzegorz Sójka
On 09/21/11 18:53, Johnny Rosenberg wrote: I haven't done this myself, but I would try to use ”Optional” and ”IsMissing”, something like this: Function MyFunction(A As Double, Optional B As Double, Optional C As Double) As Double ' Some code If IsMissing(B) Then ' Do

[users] Re: CALC

2011-09-21 Thread openoffice . mbourne
rlar...@carolina.rr.com wrote: unsubscribe Irv [K3IRV] McWherterirv4...@gmail.com wrote: Can someone please help me? I open CALC and there is a large window offering a selection of themes, backgrounds, etc. How do I make this window go away? Many thanks, Irv. That sounds like the

[users] Re:

2011-09-21 Thread Jim Parkhurst
What are the specifications of the computer (Intel? MAC? 32-bit? 64bit? Operating System? Version? Patches up-to-date?) What was the error message(s) received/observed? What is the CURRENT OOo you are running? You realize that you can download the latest version and install it? On 09/20/2011 at

[users] Re: Help with writing macro

2011-09-21 Thread Dennis E. Hamilton
From your example, there is potentially another way to solve this in Calc formulas. You can specify a list of references that would then be a single parameter: =MACRO(A13~D15~C1) For example, =SUM(A13~D15~C1) works. The question is, how does the definition of the macro specify that it

[users] Re: Help with writing macro

2011-09-21 Thread Tom Keene
How about passing your data in an array. Then you only need one parameter. On Sep 21, 2011, at 12:53 PM, Grzegorz Sójka wrote: On 09/21/11 18:53, Johnny Rosenberg wrote: I haven't done this myself, but I would try to use ”Optional” and ”IsMissing”, something like this: Function

[users] Re: Help with writing macro

2011-09-21 Thread Grzesiek Sójka
On 09/21/11 23:12, Tom Keene wrote: How about passing your data in an array. Then you only need one parameter. Could you please be a little more specific?? I do not have to much experience in writing macros. -- - To unsubscribe

[users] Re: Help with writing macro

2011-09-21 Thread Andrew Douglas Pitonyak
On 09/20/2011 04:48 PM, Grzesiek Sójka wrote: I need to write a macro accepting variable length parameter list. I was tryint to googl but no luck. So the question is how to write (preferably in OpenOffice Basic) macro accepting variable length parameter list. I am not aware of any way to write