"Johannes Graumann" <johannes_graum...@web.de> wrote in message
news:i5r303$6v...@dough.gmane.org...
Hi,
Is it possible to have form controls in an ODT who's numerical content
automatically derives from each other?
I envision to have three "Formatted Field"s A,B and C and C would - after
A
and B have been filled in by the user display the sum of A's and B's
contents.
I know how to do this with jscript in scribus-generated pdf, but would
like
to achieve something similar (without the need for a database) in writer -
optimally this would survive the PDF export, but I'm probably asking to
much
...
Thanks for any pointers, Joh
1. Insert a table into your writer document; the "Table" toolbar will
appear; if it doesn't you can make it appear via View>Toolbars>Table.
2. Enter the first value into the top left cell of the table, which Writer
refers to as "<A1>".
3. Enter the second value into the cell immediately to the right of the
first ("<B1>").
4. Position the cursor in the third cell, first row ("<C1>").
5. Click the "Sigma" icon in the Table toolbar; the text "=sum(<A1>|<B1>)"
(without the quotes) will appear above the table in an "input line".
6. Hit Enter. The cell C1 will now show the sum of cells A1 and B1; changes
to either will be properly reflected in C1.
In other words, a Writer "table" can operate as a simple spreadsheet. Many
other functions are available too. You can change the appearance of the
table - size, borders, font, etc. etc. in the usual ways.
I leave it as an exercise for the class to determine if this behaviour
survives export to PDF ...
--
Harold Fuchs
London, England
Please do *not* reply to my personal e-mail address.
---------------------------------------------------------------------
To unsubscribe, e-mail: discuss-unsubscr...@openoffice.org
For additional commands, e-mail: discuss-h...@openoffice.org
