Re: [users] Sorry, another quite stupid "how-to" question concerning basic, dialogs and spreadsheets...

2005-03-30 Thread Eike Rathke
Hi Johnny, On Mon, Mar 28, 2005 at 17:36:32 +0200, Johnny Andersson wrote: > Yes, I know, but I still can't understand what getDataArray returns! As documented at http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangeData.html#getDataArray it is a sequence of sequence(s) of any(

Re: [users] Sorry, another quite stupid "how-to" question concerning basic, dialogs and spreadsheets...

2005-03-29 Thread Johnny Andersson
Sasa Kelecevic <[EMAIL PROTECTED]> skrev den Mon, 28 Mar 2005 10:07:15 -0800: Jonathon Coombes wrote: On Sat, 2005-03-26 at 02:32 +0100, Johnny Andersson wrote: Hi! Having tried for hours now, searching on the web, trying and failing, there seem to be only one more thing I didn't try yet: To giv

Re: [users] Sorry, another quite stupid "how-to" question concerning basic, dialogs and spreadsheets...

2005-03-29 Thread Sasa Kelecevic
Jonathon Coombes wrote: On Sat, 2005-03-26 at 02:32 +0100, Johnny Andersson wrote: Hi! Having tried for hours now, searching on the web, trying and failing, there seem to be only one more thing I didn't try yet: To give up... What I want to do is to copy all values of the cells in a cell rang

Re: [users] Sorry, another quite stupid "how-to" question concerning basic, dialogs and spreadsheets...

2005-03-28 Thread Johnny Andersson
Andrew Douglas Pitonyak <[EMAIL PROTECTED]> skrev den Sat, 26 Mar 2005 10:45:51 -0500: Johnny Andersson wrote: The issue is that getDataArray() returns an array of arrays to handle the two dimensions. So it looks more like: Kunder=Array(array("a"), array("b"), array("c")) which is why you get an

Re: [users] Sorry, another quite stupid "how-to" question concerning basic, dialogs and spreadsheets...

2005-03-26 Thread Andrew Douglas Pitonyak
Johnny Andersson wrote: The issue is that getDataArray() returns an array of arrays to handle the two dimensions. So it looks more like: Kunder=Array(array("a"), array("b"), array("c")) which is why you get an error when using addItems. So if the data were in a row you could do something like: Ctl.

Re: [users] Sorry, another quite stupid "how-to" question concerning basic, dialogs and spreadsheets...

2005-03-26 Thread Johnny Andersson
Thanks! That explains a lot. I will check that dev@api.openoffice.org mail list out right away. Ian Laurenson <[EMAIL PROTECTED]> skrev den Sat, 26 Mar 2005 16:37:31 +1200: On Sat, 2005-03-26 at 13:32, Johnny Andersson wrote: [snip] 3. Use getDataArray() to copy every value to an array in on

Re: [users] Sorry, another quite stupid "how-to" question concerning basic, dialogs and spreadsheets...

2005-03-25 Thread Ian Laurenson
On Sat, 2005-03-26 at 13:32, Johnny Andersson wrote: [snip] > 3. Use getDataArray() to copy every value to an array in one step. > > 4. Using addItems to copy the whole array directly to the combo box... [remainder snipped] The issue is that getDataArray() returns an array of arrays to handle the

[users] Sorry, another quite stupid "how-to" question concerning basic, dialogs and spreadsheets...

2005-03-25 Thread Johnny Andersson
Hi! Having tried for hours now, searching on the web, trying and failing, there seem to be only one more thing I didn't try yet: To give up... What I want to do is to copy all values of the cells in a cell range to a combo box in a dialog. I was thinking about doing it the following way: 1. G