Thursday 9 December 2010

VSTO, Excel and the Designer

So I wanted to add more sheets to my VSTO (Excel 2007 Workbook) C# project. I tried right clicking the xlst, parent of the sheets, but there were no options, I tied to open the xlst but the workbook would flash up in Visual studio but then go away again and excel would open saying something about an error.

Instead I checked out for edit the xlst from source and closed visual studio, I then opened the xlst file in excel and added the sheets, then saved , closed and reopened visual studio and the sheets had appeared. Woo!

Tuesday 23 November 2010

Wrapping using css. Multiplatform.

.wrap

{
word-wrap:break-word;
-ms-word-wrap:break-word;
break-word: break-all;
overflow: hidden;
}


div class="wrap" style="-ms-word-wrap: break-word; width: 100px;"


If you want your text to be inside a table then you need to have a div in the cell and set the width to be the same in both:

div class="wrap" style="-ms-word-wrap: break-word; width: 100px;"


I use a css class to specify these widths so I only have to set the width in one place.