> Am 23.02.2013 17:17, schrieb Orchid Win7 v1:
>> http://research.microsoft.com/en-us/um/people/simonpj/Papers/excel/excel.pdf
>>
>
> No connection from here.
>

It's working from here.  I guess the Internet hamsters have gone back on 
their wheel.

The paper talks about user-defined functions in Excel for example, if 
column a has temperatures in Celcius, and you want column B to have them 
in Farenheit, you can easily type "=A1*9/5+32" in B1 and copy that the 
whole way down, but their ide was to create a function called, say 
"C2F()" that did that and then B1 would be: ="C2F(A1)".

Of course, this is a trivial example, but if you need to revisit your 
formula, modify one user-defined function would a lot simpler than 
having to hunt down every cell in the spreadsheet where it might have 
been used.

To Andy's point of it not catching on, The authors make it quite clear 
in the abstract that they don't like the idea of a full-fledged 
programming language being bolted-on to Excel.  I guess they got shot 
down when the Powers-That-Be(tm) decided that VBA would be the way to go.
-- 
/*Francois Labreque*/#local a=x+y;#local b=x+a;#local c=a+b;#macro P(F//
/*    flabreque    */L)polygon{5,F,F+z,L+z,L,F pigment{rgb 9}}#end union
/*        @        */{P(0,a)P(a,b)P(b,c)P(2*a,2*b)P(2*b,b+c)P(b+c,<2,3>)
/*   gmail.com     */}camera{orthographic location<6,1.25,-6>look_at a }

Post a reply to this message