Intersoft Solutions - Community - WebGrid Enterprise - Freeze Column Error

Community / WebGrid

Latest Development Blogs

Retrieving News

ForumPostTopic

WebGrid Enterprise

2138

8348

357

1383

430

1620

63

263

253

944

118

423

89

357

34

134

36

98

42

114

567

1861

305

768

366

1443

Browse By Tag

Freeze Column Error

26 replies. Last post: October 3, 2012 4:07 AM by Hans Kristian

Tags :

(None)

Create New

New Discussion
New Question
New Product Feedback

Post Reply

Ahmed DajaniMember

Posted: August 26, 2012 5:41 PM

Hi,

I saw this error on here before but it doesn't seem it was addressed. I am using WebGrid 7.0.7200.

My scenario:

- I am binding my webgrid to an ObjectDataSource.
- I am creating my columns dynamically in the PrepareDataBinding event. There are 80+ columns. For our scenario, let's assume the following:

visibleCol_Frozen, visibleCol_Frozon, visibleCol, visibleCol, HiddenCol, HiddenCol, visibleCol...etc.

What happens is if I scroll past where the hidden columns would be, the display screws up as you see in the attached images.

I tried the following with these two doc types:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

and

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

The latter doctype screws up my entire display in IE so it is no longer an option.

I also tried my html tag with and without xmlns="http://www.w3.org/1999/xhtml"

I really need this issue fixed please! My delivery date is nearing quickly!

2 attachments

FreezeError2.png

Reply

Quick Reply

Quote

All Replies

Ahmed DajaniMember

Posted: August 26, 2012 10:39 PM in response to Ahmed Dajani

Another question regarding the same thing...I'm having an issue retreiving the ActiveFrozenColumn Property correctly.

I initialize my grid having ActiveFrozenColumns = 2. Later on, I set it to 4 on the client side as:

grid.LayoutSettings.FreezePaneSettings.ActiveFrozenColumns = columnPos;grid.FreezePane(true);

However, later on when I refresh the page, and look on the server side at that property it is still 2. Why is that?

Hans KristianMember

Posted: August 27, 2012 4:42 AM in response to Ahmed Dajani

Hello,

I made two simple sample based on information that you provide.

1) I bind the WebGrid to ObjectDataSource (Northwind database and Customers table).
I set the column’s visibility like your current scenario. And I set the “ActiveFrozenColumns” property to “2”.
But unfortunately, I can’t replicate your issue on my end.

Please have a review on my sample and let me if there are configurations that I have missed.

2) For your second question. Basically that is the WebGrid’s behavior. WebGrid will set the value of ActiveFrozenColumns, based on what you have initialized.
Perhaps you could add some validation in WebGrid’s InitializeDataSource server side event.
Here’s the example snippet validation code:

protected void WebGrid1_InitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e){
    if (IsPostBack)
    {
        WebGrid1.LayoutSettings.FreezePaneSettings.ActiveFrozenColumns = 4;
        WebGrid1.LayoutSettings.FreezePaneSettings.MaxFrozenColumns = 5;
    }
}

Thank you.

Regards,
Hans.

1 attachment

WebGrid_Frozen_HiddenColumn.zip

Ahmed DajaniMember

Posted: August 28, 2012 12:36 PM in response to Hans Kristian

Hans,

Thanks for your answer.

I think the issue was happenign because I was refreshing the grid immediatly after...Now I took out the refresh grid and what happens is attached...

I initially have ActiveFrozenColumns = 2. Then through JS on client side I set it to a different value like this...

grid.LayoutSettings.FreezePaneSettings.ActiveFrozenColumns = columnPos;grid.FreezePane(true);

I do this through a new column context menu item. It calls a function with these two lines of code.

In the image attached, you'll notice there are two lines for the freeze column. Any idea why?

1 attachment

FreezeColumnError.png

Hans KristianMember

Posted: August 29, 2012 12:52 AM in response to Ahmed Dajani

Hello,

Thank you for your information.

To resolve this two lines issue, please try to modify your code to this code below:

grid.UnfreezePane();grid.LayoutSettings.FreezePaneSettings.MaxFrozenColumns = 4;
window.setTimeout(function () { grid.FreezePane(4); }, 50)

Hope this helps. Thank you.

Regards,
Hans.

Ahmed DajaniMember

Posted: August 30, 2012 2:16 PM in response to Hans Kristian

Thanks Hans. That solved the double line problem.

As for the sample you sent, it's not quite what I have. Can you please try the following:

- Add enough columns so that you will have to scroll to the right to see the rest of them.
- change the doc type to

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

- Hide the first two columns in PrepareDataBinding when adding columns to the grid
- Set ActiveFrozenColumns = 2
- Try in both IE and Firefox.

I attached two images illustrating what happens in my case...

2 attachments

Hans KristianMember

Posted: September 3, 2012 3:21 AM in response to Ahmed Dajani

Hello,

Thank you for your reply.

I am sorry for the late response.

I made a simple sample based on your information.

I try to run in IE 9 and Firefox 15 as well, but unfortunately I can’t reproduce you issue on my end.

Please have review on my sample and let me if there are configurations that I missed.

Thank you.

Regards,
Hans.

1 attachment

WebGrid_DataDummy.zip

Ahmed DajaniMember

Posted: September 4, 2012 2:31 AM in response to Hans Kristian

Thanks Hans. You did not miss anything and the sample works just fine. Still does not resolve my problem.

I was able to recreate the problem with your sample finally. I've attached a screen shot of the error.

Please let me know which feature is causing this error.

2 attachments

scrollError.png

WebForm1.aspx.designer.zip

Ahmed DajaniMember

Posted: September 5, 2012 1:27 AM in response to Ahmed Dajani

Hans,

Upon further testing I've closer to the reason why the error occurs. Notice in my sample the PrepareDataBinding function. Your code calls RetrieveHierarchicalStructure(), where as I am adding the columns manually. If I use your call, everything renders fine. If I add columns manually, I get the error.

Unfortunately due to a requirement, I have to add columns the way I do it in my sample. So, what is the work around?

Thanks!

Hans KristianMember

Posted: September 5, 2012 5:39 AM in response to Ahmed Dajani

Hello,

Thank you for your sample.

I try to modify my sample based on your sample.
But unfortunately I didn’t get any issue like you did.

Could you provide your WebGrid assembly version and your Framework assembly version in your current project?

I attached my sample and video about the result on my sample.

Thank you.

Regards,
Hans.

1 attachment

WebGrid_DataDummy.zip

Ahmed DajaniMember

Posted: September 5, 2012 10:16 AM in response to Hans Kristian

WebGrid Version 7.0.7200.533 Runtime Version v2.0.50727
WebGridResources 7.0.7200.533
ISNet Version 3.0.5000.1
ISNet.WebUI.Resources 3.0.5000.400

I'm using .NET 4.0

Hans,

I just noticed something in my sample. I was adding the columns that you created, but we manually did it, I wasn't adding the col0, col1...etc (they are being added in the InitializeDataSource event). After I added them, the grid straightened out.

I looked at my original code and that's what was happening too. My datasource returned 86 columns while I was adding 87 columns. The 87th column being a custom column I needed to added due to a requirement and I didn't need to store it in the database. When I removed the 87th column, the grid rendered just fine,.

It seems the grid needs to have the exact number of columns added to as the dataasource. I think even though, the grid should render correctly. Is this a bug? I think it should be.

Thanks very much for running through this with me Hans.

Ahmed DajaniMember

Posted: September 5, 2012 2:13 PM in response to Ahmed Dajani

Hans,

Upon further inspection, I found another problem. I reattached my sample.

I set the gender column to width of 25. I also set AutoWidth = false on the grid.

What I noticed was the following:

- When the grid loads and I scroll right, everything gets misaligned again.
- If I reload the grid, resize the gender column to a bigger size, then scroll right, everything looks fine.

What is the deal? This is a very frustrating error...

I don't know how to mark the above answer as not a proposed answer.

2 attachments

ScrollError.png

WebForm1.aspx.designer.zip

Hans KristianMember

Posted: September 5, 2012 11:31 PM in response to Ahmed Dajani

Hello,

Thank you for your sample.

Now, I can reproduce your issue on my end as well.

It seems this issue appears due to the WebGrid still counting the width of invisible columns.

I will forward this issue to our developer team and I’ll let you know if there are any updates for this issue.

Meanwhile, to resolve this issue you could try to remove the invisible column from your WebGrid’s structure.

Or you could use HTML4 doctype on your page.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

I am sorry for the inconvenience and thank you for your understanding.

Regards,
Hans.

Ahmed DajaniMember

Posted: September 6, 2012 9:53 AM in response to Hans Kristian

Hans,

Changing the DocType did not fix it. I can't get rid of the invisible columns. Unfortunately their usage is rooted in the code. It would take a massive effort to change all of that.

When can we expect an update?

Is there any kind of work around I can do when the page loads at first? A javascript call that would resize a column or something?

Hans KristianMember

Posted: September 7, 2012 4:42 AM in response to Ahmed Dajani

Hello,

I found a solution that you might try.
Please try to add this snippet code in OnAfterInitialize client side event:

function WebGrid1_OnAfterInitialize(controlId) {    var WebGrid1 = ISGetObject(controlId);
    WebGrid1.RootTable.Columns[2].Width = 25;
    WebGrid1.RootTable.Columns[2].Resize(25);
    return true;
}

This solution works for me.

Thank you.

Regards,
Hans.

Ahmed DajaniMember

Posted: September 10, 2012 11:28 AM in response to Hans Kristian

Hans, this is fine for the initial display, but if I then make an update on the grid, it misalsigns again. Please see the attached screen shot.

1 attachment

updateFreezeError.png

Hans KristianMember

Posted: September 11, 2012 2:59 AM in response to Ahmed Dajani

Hello,

I try to make changes (update) the WebGrid in my sample.

However, its works fine on my end.

Could you please help me to modify my sample, so that I can reproduce your issue on my end?

Thank you.

Regards,
Hans.

1 attachment

WebGrid_DataDummy.zip

Ahmed DajaniMember

Posted: September 11, 2012 11:22 AM in response to Hans Kristian

Hans,

Thanks for the sample, but I could not download it. It seemed the cs file and movie were corrupt. They wouldn't unzip.

I've tried to modify one of our old samples. My findings are as follows:

- When attempting to edit a cell, WebGrid, updates the wrong column. Please see attached images. In my sample, the columns are completely misaligned which I still wasn't able to reproduce. However, in the attached sample, the wrong column is updated. Definitely an issue (Please note I use the "structure" parameter in the query string to create the column manually).

- In my project (similar setup), I noticed when the grid posts back to the server after an update that the columns are not returned in the same order when I step through with the debugger. For example:
Grid is initialized as such col0, col1, col2, col3, col4, col5, col6 with the first two columns hidden.
After a postback, the column structure is returned as col2, col3, col4, col5, col0, col1, col6.
I don't understand why that happens, but I bet it is a reason for why my columns get misaligned.

Thank you Hans. Please keep me posted on these fixes as it is important to our project and we are past our deadline. An update date on your part would be really helpful so I may inform my client.

3 attachments

WebGrid_DataDummy.aspx.zip

Hans KristianMember

Posted: September 11, 2012 11:41 PM in response to Ahmed Dajani

Hello,

Thank you for the sample.

I am able to reproduce your issue on my end as well.

I have one solution that you might try.

I removed “ID” column and “Name” column from WebGrid’s PrepareDataBinding.
Then I use HiddenDataMember property in “Gender” column and “Address” column.
In “Gender” column, I set HiddenDataMember to “ID”.
In “Address” column, I set HiddenDataMember to “Gender”.

By doing this, I still can get the value from “ID” column and “Name” column.
And to get the value, I use this javascript:

WebGrid1.GetSelectedObject().GetRowObject().GetCells().GetNamedItem("Gender").GetElement().attributes["ID"].value;WebGrid1.GetSelectedObject().GetRowObject().GetCells().GetNamedItem("Address").GetElement().attributes["Name"].value;

This solution will resolve the “Update Wrong Column” issue and “Misaligned” issue as well.

Please have review on my sample to see how it works.

Thank you.

Regards,

Hans.

1 attachment

WebGrid_DataDummy.zip

Ahmed DajaniMember

Posted: September 13, 2012 6:02 PM in response to Hans Kristian

Hans,

I made the change as suggested but the problem still persists. The columns are misaligned. See attached image. I determined the cause of this was due to adding the first empty column. I need that column due to requirements.

I still give the user the option to hide columns. So this bug will still occur. That's a problem for us. I tried removing the extra first column I was adding and doing some more updates on the grid. Over all it seemed to work fine, but then the misalignment came up again. See the other attached image.

I can continiously recreate this problem on my end. I don't need a work around anymore. I just need this bug fixed. Can you please inform when it is possible to receive a hotfix so I can inform my customer?

2 attachments

FreezeError.png

FreezeError2.png

Hans KristianMember

Posted: September 14, 2012 3:31 AM in response to Ahmed Dajani

Hello,

Thank you for your reply.

Please correct me, if I wrong.
So you have tried my sample and it works fine (resolve your problem)?
And when you try to apply the work around to your project, the problem still persists?

If yes, perhaps there is configuration in your project, that make the problem still persists.

Would you mind to provide me the simple sample that replicates your issue?
Or could you help me to modify my sample? So I can help you to investigate your problem.

I have been following up your issue to the development team. I’ll let you know if there are any updates for your problem.

Thank you for your understanding and patience

Regards,
Hans.

Ahmed DajaniMember

Posted: September 14, 2012 12:30 PM in response to Hans Kristian

Hans,

I was not able to unzip your sample. It seems some of the files were corrupt. Can you please resend.

Hans KristianMember

Posted: September 17, 2012 12:02 AM in response to Ahmed Dajani

Hello,

Here the sample.

Regards,
Hans.

1 attachment

WebGrid_DataDummy.zip

Ahmed DajaniMember

Posted: September 17, 2012 11:13 AM in response to Hans Kristian

Still unable to open. See attached imaged.

1 attachment

Hans KristianMember

Posted: September 17, 2012 9:51 PM in response to Ahmed Dajani

Hello,

I’m sorry. I re-attach the sample.
However, if still can’t get sample. Please try to download the sample from this link

Regards,
Hans.

1 attachment

WebGrid_DataDummy.zip

Ahmed DajaniMember

Posted: October 2, 2012 1:33 PM in response to Hans Kristian

Still haven't resolved this error...

Hans KristianMember

Posted: October 3, 2012 4:07 AM in response to Ahmed Dajani

Hello,

So you have tried to run my sample on your end but the result is the issue still persists?

I attached a video about the result of my sample, on my end. Please kindly have review on my video and let me know if there are steps that I missed.
However, if can’t get the video. Please try to download the video from this link .

For your information, I use ISNet.WebUI.WebGrid.dll version 8.0.7200.201 and ISNet.WebUI.Resources.dll version 3.0.5000.850.
And if there is an update / hotfix for this issue, the hotfix will only available in WebGrid 8 not WebGrid 7.

I am really sorry for not telling this earlier.
However my work around should resolve this issue.

Thank you for your understanding.

Regards,
Hans.

1 attachment

WebGrid_DataDummy_Video.zip

How do i Add a drop down list to a Web Pane Header...

error on WebTab component

All times are GMT -5. The time now is 4:41 PM.

Previous Next