Re: 'Spreadsheet' Woes...
Gary, I think you will have to trap keys and call your various cell handlers yourself. If you store the last known cell coordinates and then check them after each rawKeyDown, you can then perform actions if they change. This may not be exactly what you want but hopefully there is enough of an idea to get you going. Cheers, Sarah [EMAIL PROTECTED] http://www.troz.net/Rev/ On Friday, August 1, 2003, at 02:19 am, Gary Rathbone wrote: I've got my field looking (well nearly) pretty much how I want. It's a field/table with Cell Formatting and Cell Editing. Looks like a spreadsheet... I'm looking for commands such as On EnterCell, On CloseCell, On ExitCell to initiate calculations on other cells And specific cell commands... Eg Assign a script to field "tdata" On CloseCell tcol,trow --the cell has been changed if tcol=7 then --calculate the sales tax put trow*0.175 into Cell(7,trow) end if end Close Cell Also I'd like to format column 7 to rightalign... Eg Set the ColumnAlign of Column 7 of fld "tdata" to right Am I expecting too much of this new feature? If so how do I trap changes in 'Cells' so I can write these procedures myself. Any pointers would be gratefully appreciated. Regards Gary Rathbone ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: 'Spreadsheet' Woes...
The most interesting thing I have found of late regarding tables is that when you edit a cell, a closeField message is sent to the stack script. Note that it is NOT sent to ... the card script to the field script or even to the the frontscrip (although there is a closeField handler in the frontScript ???) Instead this closeField message just goes to the stack script. Very strange but good to know as it allowed me to recalc the table like a spreadsheet does. If anyone can explain that it would be a good lesson for me to learn! ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: 'Spreadsheet' Woes...
>>Any pointers would be gratefully appreciated. >Sorry I can't help, but I too am waiting for a fully worked example >which shows what the 'Table' object can do...but so far the docs >don't reveal much. So this is just an "Amen, brother!" from another >potential user. Thanks Graham. It's highly frustrating knowing that some functionality exists with the only option for results being trial and error. Apart from using my limited Psychic powers to tap into the mindset of the developers I can only rely on this list to ask others who have gone before me. Meanwhile I'll continue to waste countless hours experimenting with commands I think *should* work, and play with syntax that produces various results except those I want... If I find anything useful I'll keep you posted. Regards Gary Rathbone ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: 'Spreadsheet' Woes...
>>I'm looking for commands such as On EnterCell, On CloseCell, On ExitCell to initiate calculations on other cells Tables are a mysterious beast in Rev. There is a lot of power there but you are on your own to figure out how to engage it. Fortunately, this list is a salvation ! I suggest you download the archive and search for my email address. Jan and Sarah answered a number of questions that I posed which were similar to yours and they were very helpful! My latest project which is a replacement for our Excel timecard is posted at ... http://www.christophercomputers.com/rev/ Feel free to contact me off list. Good luck. ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: 'Spreadsheet' Woes...
On Thu, 31 Jul 2003 17:15:25 +0100, "Gary Rathbone" <[EMAIL PROTECTED]> wrote: I've got my field looking (well nearly) pretty much how I want. It's a field/table with Cell Formatting and Cell Editing. Looks like a spreadsheet... I'm looking for commands such as On EnterCell, On CloseCell, On ExitCell to initiate calculations on other cells And specific cell commands... Any pointers would be gratefully appreciated. Sorry I can't help, but I too am waiting for a fully worked example which shows what the 'Table' object can do. I know there is some tricky frontscript code somewhere which controls the beast, but so far the docs don't reveal much. So this is just an "Amen, brother!" from another potential user. I have a feeling we shouldn't hold our breath on those cell-has-changed messages, but I'm still hoping. Otherwise the whole construct seems pretty limited IMHO. Graham --- Graham Samuel / The Living Fossil Co. / UK & France ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
'Spreadsheet' Woes...
I've got my field looking (well nearly) pretty much how I want. It's a field/table with Cell Formatting and Cell Editing. Looks like a spreadsheet... I'm looking for commands such as On EnterCell, On CloseCell, On ExitCell to initiate calculations on other cells And specific cell commands... Eg Assign a script to field "tdata" On CloseCell tcol,trow --the cell has been changed if tcol=7 then --calculate the sales tax put trow*0.175 into Cell(7,trow) end if end Close Cell Also I'd like to format column 7 to rightalign... Eg Set the ColumnAlign of Column 7 of fld "tdata" to right Am I expecting too much of this new feature? If so how do I trap changes in 'Cells' so I can write these procedures myself. Any pointers would be gratefully appreciated. Regards Gary Rathbone ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution