Sharepoint Edit in Datasheet locks or freezes Internet Explorer

MSDN Blog Postings » Edit in Datasheet locks or freezes Internet Explorer

MSDN Blog Postings » Edit in Datasheet locks or freezes Internet Explorer — Tue, 04 Dec 2007 21:28:37 GMT

PingBack from http://msdnrss.thecoderblogs.com/2007/12/04/edit-in-datasheet-locks-or-freezes-internet-explorer/

re: Sharepoint Edit in Datasheet locks or freezes Internet Explorer

GirlGeek101@gmail.com — Mon, 10 Mar 2008 03:51:14 GMT

I find that the datasheet view is probamatic. For instance I have a look up field in a table and it works fine in the normal NEW, EDIT and DISPLAY forms, but in datasheet view it gives that custom lookup field a prefix of string;# . No one including guys I know at Microsoft know what causes this. My team just puts up with it hoping it is a bug.

re: Sharepoint Edit in Datasheet locks or freezes Internet Explorer

shane — Thu, 10 Jul 2008 20:44:21 GMT

Any other Ideas on how to fix this problem? I went through the custom style sheet and removed all margin calls, to no avail. I then set the page to use the default.master and included the custom style sheets on that and it worked fine, so I think it's actually the custom master and not the style sheet. Any thoughts on where to look for the problem? Thanks for your time!!!

re: Sharepoint Edit in Datasheet locks or freezes Internet Explorer

Beatriz — Thu, 14 Aug 2008 19:29:27 GMT

This should be one of the nicest features of SharePoint, it is very frustrating that it doesn't work. Instructions from Microsoft on how to fix this would be greatly appreciated

re: Sharepoint Edit in Datasheet locks or freezes Internet Explorer

thomasagarcia@gmail.com — Wed, 01 Oct 2008 20:21:31 GMT

Margins wasn't the problem for me, it was a Spacer I put in the Footer of my page.

Original code on how to customize my page was off of the net www.msftliveblogs.com "Microsoft Office Sharepoint Server 2007 - Custom Chrome/Branding"

Not Working Code

Working Code

My-Spacer10 Class

.my-spacer10

{

height: 10px;

}

re: Sharepoint Edit in Datasheet locks or freezes Internet Explorer

Ben — Fri, 07 Nov 2008 00:09:28 GMT

Thanks for the suggestion. Why on earth would the margin tag make a difference? And any thoughts on why some might experience this issue and not others?

re: Sharepoint Edit in Datasheet locks or freezes Internet Explorer

Joel Hulen — Wed, 04 Feb 2009 17:21:48 GMT

I found that there is a set of conditions that causes this lock-up:

1. You are using a custom master page and have specified a DOCTYPE

2. You have images or spacing in the footer area (or anywhere underneath the main content area) that specify a height. This also includes class styles with a height setting on any element in this region.

The problem is NOT margin settings in your style sheet or page. Believe me, I have tested this thoroughly. The problem lies within the CORE.js file. I have applied the below fix and placed all my styles (including margin and size settings) back into my style sheets with no issues.

So, what's causing this to happen? There is a javascript function (located in the core.js file) that gets called by the datasheet view control when activated (GCComputeSizing(GCObject)) that sizes the datasheet element according to the current window size. Specifically, the culprit was "var lGCWindowHeight=documentElement.scrollHeight". This caused the scroll height for the page to go out of bounds. In quirks mode, IE includes the top & bottom borders within the padding widths when calculating the offsetHeight. Standards mode only defines the content height as the offsetHeight.

To fix, I replaced the line:

var lGCWindowHeight=document.documentElement.scrollHeight;

with:

var lGCWindowHeight=(document.documentElement.scrollHeight>document.documentElement.clientHeight) ? document.documentElement.clientHeight : document.documentElement.scrollHeight;

This bounds the scroll height to the client height.

I didn't want to modify the CORE.js file, so within my master page, I override the method. To do this, paste the following within your master page (I stuck mine at the bottom of the page):

function GCComputeSizing(GCObject)

{

if (TestGCObject(GCObject))

{

var fBIDI=(document.documentElement.currentStyle.direction=="rtl");

var lGCWindowWidth=document.documentElement.scrollWidth;

var lGCWindowHeight=(document.documentElement.scrollHeight>document.documentElement.clientHeight) ? document.documentElement.clientHeight : document.documentElement.scrollHeight;

var lGCObjectOffsetLeft=0;

var lGCObjectOffsetTop=0;

if (fBIDI)

{

lGCObjectOffsetLeft=-180;

lGCObjectOffsetTop=120;

}

else

{

lGCObjectOffsetLeft=32;

lGCObjectOffsetTop=-2;

}

var lGCObjectWalker=GCObject.parentElement;

while (lGCObjectWalker !=document.body)

{

lGCObjectOffsetLeft+=lGCObjectWalker.offsetLeft;

lGCObjectOffsetTop+=lGCObjectWalker.offsetTop;

lGCObjectWalker=lGCObjectWalker.offsetParent;

if (fBIDI)

if (lGCObjectWalker.offsetLeft > 0)

break;

}

lGCObjectOffsetLeft+=GCObject.parentElement.offsetLeft;

lGCObjectOffsetTop+=GCObject.parentElement.offsetTop;

glGCObjectHeight=lGCWindowHeight - lGCObjectOffsetTop;

if (glGCObjectHeight > lGCWindowHeight)

glGCObjectHeight=lGCWindowHeight

if (glGCObjectHeight < cGCMinimumHeight)

glGCObjectHeight=cGCMinimumHeight;

if (fBIDI)

{

glGCObjectWidth=lGCWindowWidth+lGCObjectOffsetLeft;

}

else

glGCObjectWidth=lGCWindowWidth - lGCObjectOffsetLeft;

if (glGCObjectWidth > lGCWindowWidth)

glGCObjectWidth=lGCWindowWidth;

if (glGCObjectWidth < cGCMinimumWidth)

glGCObjectWidth=cGCMinimumWidth;

}

re: Sharepoint Edit in Datasheet locks or freezes Internet Explorer

Joel Hulen — Wed, 04 Feb 2009 17:25:24 GMT

BTW, I'd like to give credit to this blog post for finding the fix: http://tomblog.insomniacminds.com/2008/07/23/sharepoint-branding-issues-edit-in-datasheet-view/

re: Sharepoint Edit in Datasheet locks or freezes Internet Explorer

frank3nst31n — Thu, 19 Nov 2009 13:21:01 GMT

Thanks for the suggestion, removing the doctype worked like a charm