On 05/04/2011 03:41 AM, [email protected] wrote:
Mr. Pitonyak c/o authors at documentation dot openoffice dot org
Nope, no one here by that name.... :-)
To whom it may concern;
I have tried sending a message to Mr. Pitonyak at the address given in
the .pdf file, but it was not valid or there was some sort of server
issue so I would appreciate it if you could forward the email to him
or if you have a resolution to my problem any help would be appreciated.
What email address did you use? Curious.
First, I would like to thank you for writing Chapter 13.
I placed the original words and figures on paper. Many in the group have
likely touched it to make it what it is today. Your welcome.
I found it very informative and helped me to accoplish all but one of
my goals. The last that for some reason I cannot seem to find any
information on is how to incorporate the use of a form with my calc
spreadsheet which would enable the user to easily add and edit the
data in my spreadsheet.
You are correct, this topic is not covered in that particular document.
I do not know off hand if this is covered in any document. I rarely do
personal database things so I have not bothered to do this. Well, not
much anyway. I did work a project where I inserted drop down combo boxes
into a Calc document and then I associated these to a specific cell.
Experiment a little bit.
There is one tricky point (I just checked).
Make certain you can view all of the relevant toolbars (use View >
TOolbars and enable form controls and form design).
CLick the "Design on/off" toolbar button.
Select a combo box from the form controls toolbar.
Drag an area on your Calc document
A wizard opens. This wizard desires that you select a database. ignore
this and click Cancel.
Right click on the control and select control (to open the control
properties dialog)
On the general tab, set "Dropdown" to yes
Select the Data tab.
Enter the address of the linked cell (say A7)
You can set the Source cell range to reference a set of data to fill the
control.
Now, turn off design view. change the data in the dropdown box and the
value is shown in cell A7. Change cell A7 and the value is shown in the
list box.
I believe that you can also set the list of values in the drop down as
hard-coded values on the General tab. I think that I discuss how to
enter a list on AndrewBase.odt and I don't remember off hand how to do
it. Now, I am a few hours past when I should have been sleeping (which
is when I usually answer this type of email) so I am off without further
investigation.
Hope This Helps some.
Do you have any knowledge and/or experience with creating forms in
Calc? I have searched the web for a great many days with the very
minimal information indicating to click View>Tools>Form, but no actual
information of an instructional value.
Any help would be appreciated. I have also searched the open office
site which only seems to discuss using forms in Base.
Thank you in advance.
Katt
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
