Thanks for all the inputs received in past from mailling lists. I am Tcl'er for most of my work but some frontend stuff I had to use OpenOffice. I tried my best to find a built-in routing for hashes in OO Basic but it seems there ain't any.
Also, I am yet not comfortable in creating a variable single-d or multi-d array in V Basic. The linked-list or vectors are really handy in such cases. Bottom line I could not find equivalent to C++ STL or Tcl constructs. Any information on the above two would be useful. So, I went ahead and implemented it as described in previous email as strings where multitude of delimeters gives the option to implement multidimensional. I liked the Split and Join functions they were easy to use. Thanks, Madhur On Fri, Dec 25, 2009 at 9:13 PM, Joseph Areeda <[email protected]> wrote: > > > Andreas Saeger wrote: > >> Madhur Kashyap wrote: >> >>> ---------- Forwarded message ---------- >>> From: Madhur Kashyap <[email protected]> >>> Date: Mon, Dec 7, 2009 at 2:55 PM >>> Subject: How to take complex user inputs in a Calc application >>> To: [email protected] >>> >>> >>> Hi, >>> >>> I am developing a small application using in Calc. The application is >>> heavy >>> on the number of user inputs required. So, far I have been able to >>> satisfy >>> my needs by pre-defining the columns and rows in the sheet with what data >>> it >>> would contain to make it work for me. >>> >>> There is a situation when the user inputs are dependent in a linear >>> fashion >>> where I am thinking of implementing them as dialog. Although, I am not >>> sure >>> if that is the best way. If dialogs are the best way to implement these, >>> then I am failing to find the right tutorial on how a dialog should be >>> implemented which is created during run-time from scratch. First let me >>> describe what I need to do. >>> >>> User Parameters >>> ============== >>> >>> Technology - A pulldown list { A B C D } (Fixed cell in spreadsheet) >>> >>> Library - Possible options depend upon technology input and are obtained >>> from data already stored in hidden sheets. For example, if Technology is >>> A, >>> Library list would be {A1 A2 A3}. >>> >>> Devices - Foreach library there would be three or more device inputs, >>> e.g. >>> for A assume { L S H }. These inputs I can dynamically obtain stored in >>> other sheets in the document. I wanted to deal with this input in >>> following >>> way. >>> >>> Possible Implementation >>> =================== >>> >>> 1. User selects a technology, Lets say "A". >>> 2. A button sits next to a cell and when clicked opens a dialog box. >>> 3. The dialog box gets populated with all the possible libraries for the >>> technology and their respective device inputs. It initializes values from >>> the cell if present. >>> >>> Cell string stored - >>> A1,L,0%,S,0%,H,0%;A2,L,0%,S,0%,H,0%;A3,L,0%,S,0%,H,0%; >>> >>> >>> Library: A1 L ____ S ____ H ____ >>> Library: A2 L ____ S ____ H ____ >>> Library: A3 L ____ S ____ H ____ >>> >>> >> You describe a 100% database application. >> Just my 2 Cents for Xmas >> >> If I understand what you are trying to do correctly, I agree with > Andreas. I think I would write a custom db application to optimize the user > experience and if need be an export to the spreadsheet. > > Joe > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- Regards Madhur Kashyap
