Dotan Cohen wrote:
2008/8/30 Michele <[EMAIL PROTECTED]>:Remember that you have to press F9 or Tools > Update > Fields to... guess what? update the fields :-) Fields are otherwise updated before you print, when you save the document and at some other events (maybe).I just discovered this one minute before I read your post. In fact, I came back to mention F9.
Use variables instead of fields, they will update automatically. E.g. Insert > Fields > Other > Variables > Set variable Name: SPEED Value: 2000 <Insert> Name: DISTANCE_FROM_AXIS Value: (200*10^3)/(2*PI*SPEED) <Insert>
...
But then I use the result 15.9155 later in the paper to see how much
distance the tool had traveled over the surface of the metal:
PASSES={30-DISTANCE_FROM_AXIS}/0.3
sum from{n=0} to{PASSES} {2 cdot %pi cdot (DISTANCE_FROM_AXIS + 0.3 cdot n)}
...
If I could use variables in the Equation Editor I would save about an
hours work each time the revs change. And as we experiment with
different lube formulas, the revs change often.
There is no way to pass information into or out of OOo's formula editor.I know I've seen people ask about doing it, so there is certainly some interest, but I can't find any feature request in Issuezilla for it.
But even if you get around the live formula values problem, neither Writer, nor even Calc, will make your last calculation: you need a loop for a sum like that.
MathCAD is the only tool I know of for doing what you describe. <Joe --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
