2008/10/9 Niklas Nebel <[EMAIL PROTECTED]> > On 10/ 9/08 05:14 PM, Johnny Rosenberg wrote: > >> Don't be… it seems like no one else has a solution neither… But I think >> that >> DataArray structure is a bit odd, because if I create a combo box on a >> spreadsheet, rather than in a dialogue, I can associate it directly with a >> cell range of one column, can't I? How does that work? >> > > The form controls use service com.sun.star.table.CellRangeListSource. You > could also use that, or use FunctionAccess and the TRANSPOSE function.
I'm still kind of a beginner, so it would be nice with a short example. That CellRangeListSource sounds like a good idea, I will try to get more information about that. If there is some kind of reference manual for these kinds of things, I would appreciate a link to it. > But how big are your arrays? Copying 100 string entries doesn't usually add > a noticeable delay. At the moment about 200 entries, growing all the time. Ans yes, it really takes too long filling the combo box at the moment. Maybe not on the computer I use right now, but when running on my Eee 900 it really does. It takes a bit more than one second before my dialogue appears (which it does when the combo box is filled), which I feel is maybe almost acceptable right now, but what about when I have 500 rows? Should I just sit there and wait for more than 2 seconds for it to open? I don't think so… So every ms count for me. > > > Just found out that I can't unless I register the cell range as a >> database, >> but it was possible to do this without a database registration in an >> earlier >> version, like 1.1.5 or so, I think. >> > > Select the source cell range in the control's properties, not a data source > for the form. Oh… thanks, I'll try that. > > > Niklas > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
