---------- Forwarded message ----------
From: Madhur Kashyap <physiologo...@gmail.com>
Date: Mon, Dec 7, 2009 at 2:55 PM
Subject: How to take complex user inputs in a Calc application
To: d...@sc.openoffice.org
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 ____
--
Regards
Madhur Kashyap
--
Regards
Madhur Kashyap
