[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]