Thanks for feedback 1. yes, the formula evaluator doesn't check for valid ranges yet, though in this case it could be like recursion calculations but it will end up with infinite recursion - which is not good :) 2. yes, it will be implemented cause i''m pretty tired of entering addresses by hand too :) 3. yes, actually the box below is for this (it displays only current address now, but it's quite easy to implement editing formulas and stuff)
again, thank you for your comments --- In [email protected], "bloodylag" <[EMAIL PROTECTED]> wrote: > > --- In [email protected], "andrii_olefirenko" <andriyo@> > wrote: > > > > Hello guys, > > We started developing a spreadsheet application (not only a component) > > built in Flex. It's in deep Alpha stage but we are going to extend > > functionality so it will be decent and free replacement for desktop > > spreadsheet applications. > > For version 1.0 following will be implemented > > 1. Cell selection - done > > 2. ABC/123 Rules - done > > 3. Content copy/cut/paste - done > > 4. Cell editing - done > > 5. Row/Column/Cell formatting - done > > 6. Cursor browsing (Tab, Enter) - done > > 7. Basic formula evaluation - done > > 8. MS Office format support - work in progress > > 9. Data sorting > > 10. Data search > > 11. File saving on the server, on the client, loading from the server, > > from the client, file revisions > > > > Read more info and watch demo here http://andriyo.kiev.ua/archives/11 > > I'd really appreciate your comments and critics:) > > > > Andrii Olefirenko > > > > Just watched the video, pretty cool looking demo. > > Though I noticed a few things > > 1. The part where he was showing off the SUM. He went from the inital > row to also the row where he was putting the formula (I10 - I14) > though the numbers only went from I10 - I13. > > It gave the result of 20, which I guess is right since he did 1 + 2 + > 3 + 4 = 10 + =SUM(of those 4 numbers) which is 20. Though I pretty > sure normal spreadsheets will error on that, I tried it in google > spreadsheets and it throws a #REF error. > > 2. Will you support when doing an equation cell highlighting to > automatically fill in the equation. IE =SUM( user clicks cells and it > puts it in)? > > 3. Also will you have a textbox which shows the current formula for > the currently selected cell? >
