[EMAIL PROTECTED] wrote:
Hi,

I'm creating a form, in Writer, from scratch, using the Form Controls widgets, 
for travel expenses. There's no corresponding database. There are the following 
types of fields:

Travel: $1000
Food: $80
Other: $100

Total:  $1180

My question is, how do I create a field that automatically calculates the total?
Unfortunately, I think that with fields, you must solve this using a macro.

Nope, scratch that, I found a solution. It is simple, and you can fill in the extra details

Insert | Fields | Others

Click on the Variables tab.

Select type "User Field".

Enter the name FF1 and a value of 800 then select Insert.
Enter the name FF2 and a value of 150 then select Insert.

Select type "Insert Formula".
You can not enter a name, but enter the Formula FF1 + FF2 then select Insert.

You have the value 950.

Hope this helps. Nice to see you again Solveig.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to