Datasheet View Errors With Office 2007

We recently started upgrading all of our employees to Office 2007 (from 2003). We’ve seen a lot of different errors but nothing pandemic. One of the errors is related to the datasheet view. I started doing some research and this blog has everything you need…

Advertisements

Add a Document Icon to the CBQ

When you want to change the look of the results in a Content By Query web part you modify the ItemStyle.xsl file in the Style Library of your site. You can find more information here.

I created a custom style to display links to documents. If you are pulling documents directly from a document library, you can make the modifications to the XSL that are documented in this posting.

My custom style is pulling links and titles from a custom list so I needed to get the file extension to generate the icon. Luckily there’s a function in the ddwrt namespace for doing this. It’s documented here.
ddwrt:GetFileExtension(@URL)

So now you just need to build the link to the image and link it to the document URL. My variable with the document URL is @DocURL. You should substitute your own doc URL variable. Just add this to your style where you want the icon to appear.
<A TABINDEX=-1 href={@DocURL} target=_blank>
<img border=0 src=/_layouts/images/ic{ddwrt:GetFileExtension(@DocURL)}.gif alt={@DocIcon} style=vertical-align: middle;margin-right:4px />
</
A>

Using Silverlight in SharePoint

Hopefully more on this soon, with examples. Check out this site with sample web parts. The site includes all of the code and walk throughs.

http://www.ssblueprints.net/sharepoint/