August 2006 - Posts

• B2TR Cookie changes in Excel Services EWA

  EWA allows users to work on workbooks in a truly thin manner. One of the things that were important for us to do, was to allow session information to be kept around as the user was navigating around a Sharepoint site. This was doubly important for us Read More... Posted Thursday, August 31, 2006 4:52 PM by Shahar | 1 Comments Filed under: Excel Services

• Posts about B2TR

  Excel Services Beta2 Technical Refresh (b2tr) has a few new features, featurettes and fixes that were not available on B2. In the next week or two I will make a few posts about those – mainly the ones I worked on – for most, I will try and also explain Read More... Posted Thursday, August 31, 2006 4:50 PM by Shahar | 2 Comments

• Making Excel Services UDFs work on Excel 2007 - Part 2

  Second part about how to use Excel Services UDFs inside Excel. This one discusses how to adapt Excel Services UDFs that have object arrays as a parameter. Read More... Posted Wednesday, August 30, 2006 11:54 AM by Shahar | 11 Comments Filed under: Development, Excel Services

• List of supported strings to pass to CodeDomProvider.Create()

  Could not find one on the interweb, so here goes (first part is the name of the provider, the second is a name of a string that will cause it to be created): Microsoft.CSharp.CSharpCodeProvider - c# Microsoft.CSharp.CSharpCodeProvider - cs Microsoft.CSharp.CSharpCodeProvider Read More... Posted Tuesday, August 22, 2006 2:45 PM by Shahar | 0 Comments

• Closing workbooks Asynchronously - VS2003

  I just got asked about this today. If you will recall, in a previous post I explained why the CloseWorkbook() Excel Web Services method is a good candidate for calling in a "Fire and Forget" manner. The explanation in that post was specific for VS2005. Read More... Posted Friday, August 18, 2006 7:38 PM by Shahar | 0 Comments Filed under: Development Related, Development, Excel Services

• Supported workbook files in Excel Services

  Been getting this question on and off now for a couple of weeks, so I thought I would drop a line about it. Excel Services ONLY supports two of Excels file formats - the new XLSX and XLSB ones. Other files will raise an error saying that the file is not Read More... Posted Thursday, August 10, 2006 12:36 AM by Shahar | 7 Comments Filed under: Excel Services

• Censorship fun

  My wife told me this one. She saw a show about plastic surgery and they showed a guy who was going through surgery on the path to being a woman. Throughout the episode, the guy was seen bare breasted. As they were filming the operation they inserted the Read More... Posted Monday, August 07, 2006 11:48 AM by Shahar | 0 Comments

• Making Excel Services UDFs work on Excel 2007 - Part 1

  I have made a few posts about UDFs over the past couple of months. One of the things I neglected to explain is how to make server targeted UDFs work on the client. Among other reasons why one would want that, is the fact that it’s useful to actually see Read More... Posted Thursday, August 03, 2006 2:23 PM by Shahar | 17 Comments Filed under: Development Related, Excel Services

• I hate it when a stupid feature turns out to be useful.

  My new pocket pc has a feature (that most cellphones have these day) that allows you to attach an image to a contact. When that contact then calls, you see the image. I took some pictures of friends and attached them to their contacts, making jokes about Read More... Posted Thursday, August 03, 2006 10:51 AM by Shahar | 0 Comments