Spreadsheet

Björnke von Gierke bvg at mac.com
Sat May 12 13:23:45 EDT 2007


Hi David

Unfortunately, I don't have any spreadsheet to share. I would be 
interested in your OpenOffice code though, any chance of making an 
example stack which contains your snippets?

As for formula handling, is there a special format you had in mind with 
"standard formulae"? Otherwise you could do (hehe) something like this:

1. Make up your code, as similar to rev code as possible. For example 
(off the top of my mind):
cell 1,3 + cell 1,4 / cell 1,5

2. Replace stuff rev doesn't understand with rev stuff (assuming every 
cell is a rev field):
field "cell 1,3" + field "cell 1,4" / field "cell 1,5"

3. evaluate the string in rev:
put value(field "cell 1,3" + field "cell 1,4" / field "cell 1,5") into 
field "cell 1,6"

You could of course use "do" as an alternative, I'm not sure if that'd 
be more complex, but it would certainly be less secure.

have fun
Björnke

On 12 May 2007, at 17:17, David Bovill wrote:

> I am just starting work on a basic spreadsheet in Rev - I have a few
> fragments but was wandering if anyone has some work they would be 
> willing to
> share?
>
> The bits I have:
>
>   1. altTable like component with headers
>   2. data model
>   3. bits to read and write to OpenOffice documents
>
> I don't have any GUI or code for viewing, adding and editing formulae, 
> or a
> general way of taking standard formulae and applying them to cells. Any
> ideas?
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>




More information about the use-livecode mailing list