What would be really neat - and perhaps more attainable - is the ability to
write a mini-program
with pseudo code (within certain limitations) that could be compiled into
OOo Calc formulae.
Example (really simple)
if B2 < 0 then
A1 = 4
else
A1 = 2
endif
in A1 would be =IF(B2 < 0;4;2)
On 1/2/06, Daniele Filippetto <[EMAIL PROTECTED]> wrote:
>
> My picture was just a simple equation like one you can write with Math,
> with the only peculiarity that it contained some cell references instead
> of just numbers (Example: B1+A2....). Actually I'm not proposing
> anything really new. The difficulty in Calc (as well as in Excel) is
> that in long equations it's sometimes difficult to check the correct
> sequence of the terms. See the expression below, that it's taken from a
> REAL calculation sheet that I prepared for my work. It would be easier
> if the fraction marks and the square roots (among others) would be
> represented in a graphical view, in order to understand which terms they
> include and to see where they begin and where they end.
> I've tried to use Math as Rigel suggested on 27th december, but I wan't
> able. In any case it seems complicated for a common user. It would be
> nice to have an automatic graphical compilation. The Hewlett-Packard
> calculator (hp48G) makes something similar.
> Thanks
> Daniele Filippetto
>
> =((((PI.GRECO()*($CR.D6/60)*$CR.D8)^2)*$CR.D14)/SEN($CR.D12*PI.GRECO
> ()/180))*($DI.D10*($CR.D15/$CR.D13)*((COS($CR.D12*PI.GRECO
> ()/180))^2+4*(SEN($CR.D12*PI.GRECO()/180))^2)+$DI.D10*$CR.D9/$CR.D10)
>
>
> Niklas Nebel wrote:
>
> >
> > Attachments are filtered by the list server. It would be great if you
> > could attach the picture to an issue or put it somewhere on the web so
> > we can see it.
> >
> > Niklas
> >
> >
>
>
>
>
>
>
> ___________________________________
> Yahoo! Mail: gratis 1GB per i messaggi e allegati da 10MB
> http://mail.yahoo.it
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
My OpenOffice Calc Website
http://www.openofficetips.com
