Daryl wrote:
I am trying to find if there is such a thing as a calculator to be used
with OpenOffice as a plugin or something. Heres what I am getting at...
I took a MS Excel class a couple years ago. When you enter a value into
a cell, you can then upgrade that value by clicking on the cell (which
already has a value in it), and when you do, a little tiny calculator
about the size of the cell itself comes up. The value in the cell is
displayed on the calculator and you can the click (for example) '+',
'145', '=' and the number in the cell is increased by 145. This is
useful when (for example) entering weekly income amounts in a monthly
spreadsheet.
Now I am using OpenOffice and would like to see the same thing. Is this
available? Can someone make one? Has anyone ever seen this? I tried to
fing the answer a while back and never found anyone who ever heard of it.
Thanks,
Daryl Helwig
You could use the usual spreadsheet method of setting the cell to, for
example, '=5+2'.
That cell will then display 7.
You can also use cell names in the equations
'=A2+5' will display the number in cell A2 plus 5.
In OO.org 2.0 you can goto Insert>Function... (Ctrl+F2) for a list of
functions that you can use in your formulae. The help should have a list
of functions somewhere in any case.
I'm sorry if this is completely unhelpful, but this is pretty much the
standard way of doing this sort of thing as far as I know. The ability
to have the spreadsheet program dynamically evaluate cell values is the
power of the medium, and it is worth the effort to learn.
If you use spreadsheets you should be familiar with everything on
<a
href="http://www.tutorialsforopenoffice.org/tutorial/First_Time_User_Calc.html";>
http://www.tutorialsforopenoffice.org/tutorial/First_Time_User_Calc.html</a>
Again, sorry if this is completely below your knowledge level, or unhelpful.
Grady
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
