> > > I got this far but for some strange reason
> > > I cannot display the formula in a cell.
> > > All I get are the results of the formula.
> > > How do I see the hidden formulas that gave these results?
> > > > > > Of course I can retype the formulas because I know
> > > what they are. I don't want to do that over and over.
> > > I can copy then with relative addressing if I could get
> > > them to appear.
> > > > > > Seems life would be a lot simpler if cells had two sections.
> > > One section to hold the formula and the other to hold
> > > the results of the formula instead of hiding the formula
> > > in the same cell.
> > > > > > Paul Lamar ...No rotor no motor.
> > > > > > > > > Paul,
> > > > > > In the Excel world, formulas are entered into a cell with o preceding "="
> > > equals sign.  Without the "=", the application thinks you are just entering
> > > the value that results from the mathematical expression you are using.
> > > > > > I'm not an Open Office user, so I hope I have not added confusion.
> > > > > > Grant
> > > > > > That is the same in Open Office. I am beyond that.
> > > Once I calculate the sheet I can't see the formulas to copy
> > > them below the next set of data. For some strange reason it
> > > worked in the original sheet. Then I saved it and I reloaded
> > > it. Perhaps that has something to do with it.
> > > > > > Paul Lamar ...No rotor no motor.
> > > > > > The Rotary Engine NewsLetter. Powered by Linux.
> > > ACRE NL web site. http://www.rotaryeng.net
> > > Copyright 1998-2005 All world wide rights reserved.
> > > > > > > > > > > Paul,
> > > > Please send me the sheet you are having this problem with.  I've been
> > trying to figure out how to change the results of a formula to an
> > actual value.  That makes it easier to copy some calculated data to
> > another spreadsheet for example.  Maybe you've found a way to do it.
> > > > Bob W.
> > > Here is the latest.
> > Paul Lamar ...No rotor no motor.
> > That's the data.  I wanted the spreadsheet you are having trouble with.
> > Thanks,
> Bob W.
>
That could be the clue to my problem. I am saving it as data and not
as a spred sheet. If that is the case I'll have to do the formula s
over as I think I lost the sheet. What are the file extensions for
a sheet? csv or sxc? I suspect csv is data and results only.
While sxc is the spred sheet. Is that correct?

Paul Lamar ...No rotor no motor.


Yes, that sound like it might be it.  I will have to try saving the
results I want to copy as csv.  You are correct, the spreadsheet is .sxc
for OO 1.x.  For OO 2.0 it has changed to .ods.

I've upgraded to OO 2.0, and it seems to be working great.  It looks
like they have a half way decent data base application included now.
It seems to load a little faster and MS compatability is supposed to
be better.

Bob W.

Looks like I'll have to redo my coast down sheet as well.

Now the questions how do I see the results without saving
it as an csv? :)

Paul Lamar

If you want to graph it, get the data you want to graph in two columns
next to each other.  Select the data range you want to plot. Go to
Insert -> chart and it will give you a wizard for crating the chart.  I
did the ones I sent as X Y charts with no connecting lines.

If you have something you want to do with the .csv data, you can always
save it in both formats.  Just be sure to save the latest spreadsheet
before saving it as csv.

BTW, I think your MPG calculation is GPM.

Bob W.