Built-in calculator for spreadsheets ( openoffice excel )

[sofasurfer]

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.

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.

 

[Al Klein]

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.

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.

It would generate a circular reference.

 

[Won Dampchin]

It would generate a circular reference.

Quicken has had this feature for years.

 

[Mel]

Quicken has had this feature for years.

Is it Freeware?

 

[Al Klein]

Quicken has had this feature for years.

To pop up a calculator, or to calculate a cell equal to itself plus
some operation?

You can't have both a value and a formula in the same cell.

You can have a spreadsheet that pops up a calculator if you press some
key combination while in a cell. That's entirely different - it's
part of the program, not something a user can write after the program
has been compiled.

It may be possible by using a macro and some VBA code, though.

 

[sofasurfer]

It may be possible by using a macro and >some VBA code, though.

That is what I'm asking...Is there a macro or something that does this.

You can't have both a value and a formula in >the same cell.

You can have a spreadsheet that pops up a >calculator if you press some
key combination while in a cell

Its a calculator. You click a cell and a tiny calculator appears so
that you can perform a calculation and when your done the answer
becomes the value in the cell.

 

[Al Klein]

Its a calculator. You click a cell and a tiny calculator appears so
that you can perform a calculation and when your done the answer
becomes the value in the cell.

Any time you click on any cell? That would be annoying.