Take one cup Google Docs, one cup Microsoft Excel and add a dash of programming. Observe .
Read More...
Question: When does 850 * 77.1 not equal 65,535? Answer: When you're using Excel 2007. A bug in Excel 2007 (and Excel Services) is causing issues around calculated values of 65,535 and 65,536. Calculations that evaluate to the values may incorrectly display
Read More...
I was more than a little bummed yesterday (annoyed is more like it) when I found out why I was missing the Excel Services option on the Publish menu in Excel. Excel 2007 Enterprise Publish Menu Little did I realize that all of the work I’ve been doing
Read More...
I spent Thursday, April 26th in New York attending the 5th Annual Financial Services Developer Conference . I was on hand to assist with one of the VSTO demonstrations. The demo used an application that OZ developed last year for the Office System Developers
Read More...
I've always found Excel's Find/FindNext methods awkward to use. It just seemed to require so many lines of code versus other common operations. I guess I've always wanted a simple FindAll() method that would find everything at once and give me a range
Read More...