falco foxburr - Developer IT

How can I determine new & previous cell value on SheetChange event in Excel?

- by Falco Foxburr

I have some special cells in my Excel workbooks which are managed by my Excel Add-in. I want to prevent users from changing content of those cells, but I also want to know, what value users wanted to enter to those cells. On the SheetChange event I can check what users entered to my special cells, but how do I determine the PREVIOUS value in those cells and REVERT user changes? It is not a solution for me. If I lock cell in Excel, it becomes read-only - user can not even try to enter anything to this cell - Excel popups warning dialog in this case. My problem is that I want to catch what user entered to my cell, do something with this value, and then revert cell content to original value.

Read the article

??????????????????????????/????????????????????????·???????????|WebLogic Channel|??????

- by ???02

??????????????????·???????Oracle Coherence??????Java???????????????????????????????????????????????????????????????????Java API??????Oracle Coherence???????????3????????????????????????Coherence???????????????????????????????3???????????(???)???????Coherence???????????????Java??????????　???????????????????????·??????????/????·????Oracle Coherence???????????????????????Java API??????Oracle Coherence????????????????????????????????????????????????????????????????　?????????????Coherence??????????????????????????????/???????????????????????????????????????????3???????(4)????????/????????????　????????????????????????????????????·???/?????????　Oracle Coherence????????????????1?????????????????????????????????????????????????????????????????????????????????????????????????????????????Oracle Coherence?????????????????????????·????????????????????????????????????????In-Place Processing????????Oracle Coherence???In-Place Processing?????????????????????????????????????????　????·???/???????????In-Place Processing??????????????????·??????????????????????????????????????????????????????????????????????????????????????????　???????????????????????????????????????????????????　???In-Place Processing????????·????????????Oracle Coherence 3.6????????????Coherence Query Language(CohQL)??????????????????????????????CohQL???????????????????SQL?????????????????SQL?WHERE?????????????????????????????(5)???????????????　???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????(?????)?????????????????????????????????????????????????????????????????????????????　Oracle Coherence?????????????????????????????????????Oracle Coherence???????????????????????????????????????????????????????????????????????????????????????????????/????????????????????????????????????????????　??????·????????????????????????????????????????????????????Oracle Coherence?????????????????????????????????????????????(??????)?????????????????????????????????????????????????????????　???????·????????????Continuous Query Cache??????????????????????????????????????????????????????????????????????????????????????????????????????????????Continuous Query Cache????????????????????????(6)???????????????????　????Oracle Coherence????????????Invocation Service??????????????????(4)?????In-Place Processing?????????????·?????????????????????????????????????????????????????Java??????????????????????????????·????????????????????????????????????????????????　??????????????????????Oracle Coherence ??????????????????????????????????????????CPU???????????????????????Oracle Coherence???????????????????????????????????Web???????????????????????????Oracle Coherence?????????????????????????????????????????*　　　*　　　*　?????????Java????????????????????Oracle Coherence?6???????????????????????????Oracle Coherence????????????????????????????????????????????????????????Oracle Coherence?????:Aleksandar Seovic?Mark Falco?Patrick Peralta??:????·??????????????·????Oracle Coherence: Share and Manage Data In Clusters?···3????????????·??????????????????????????

Read the article

links for 2010-05-19

- by Bob Rhubart

Presentations from #otnarchday in Dallas now available on Slideshare Includes presentations on IT Optimization, Application Integration Architecture, Application Grid, and Infrastructure Consolidation. More to come. Anthony Shorten: JMX Based Monitoring - Part Four - Business App Server Monitoring Anthony Shorten discuss a new Oracle Utilities Application Framework V4 feature that allows JMX to be used for management and monitoring the Oracle Utilities business application server component. (tags: oracle otn java architect) New book: Oracle Coherence 3.5 An overview of the new book by authors Aleksandar Seovic, Mark Falco, Patrick Peralta. (tags: oracle otn grid architect) Douwe Pieter van den Bos: Next step in Virtualization: VirtualBox 3.2 "For businesses, VirtualBox just might be the answer they where looking for," says Douwe Pieter van den Bos. "A simple and widely supported virtual machine." (tags: oracle otn virtualization architect) Maurice Gamanho: Python and Ruby in Tuxedo Maurice Gamanho's quick overview of new features in Oracle's Service Architecture Leveraging Tuxedo (SALT) 11gR1. (tags: oracle otn soa architect) Live Webcast: Oracle and AmberPoint - May 20, 2010 - 10 a.m. PT/1 p.m. ET Ed Horst and Ashish Mohindroo discuss the advantages of the Oracle and AmberPoint combination. (tags: oracle otn architect soa governance)

Developer IT