Wednesday, January 24, 2007 - Posts
Excel 2007 increases the grid from 65,536 rows and 256 columnns to over 1 million rows and 16,384 columns - whether this will create even worse monster spreadsheets is a different question - as well as memory, multithreading, XLL improvements.
Also good whitepaper on Improving Performance in Excel 2007.
SharePoint 2007 has a nice feature where they do a red squiggle validation for data entry controls, similar to spell checking in Word.
It's done by some clever div / span with contenteditable dhtml as uncovered by fooshen.
It's good to see that these SharePoint querystring tricks work on Microsoft Office Server 2007.
Add ?contents=1 to the url which will take you to the web part maintenance page when you need to close a misbehaving webpart on page.
Add ?ToolPaneView=2 which shows the Add Web Parts toolpane, handy if want to add say a content editor webpart to a item edit page.