Web Grid Loses Some Formatting

Hi,

I am using the Web.Grid control on a website. The grid is initially empty. The user can add data to the grid and the grid data is saved to a database. The next time the user goes to edit the same record, the data is loaded back into the Grid from the database. I am finding that often the formattting like right or left justified is lost on the reload and sometimes if I hit the referesh button on the browser the formatting returns although not always. I am using IE7, .net framework 3.5 sp1, and vs 2008 sp1. Here are the two calls that save and retrieve the data.

// load data to grid from database
byte[] bData = (byte[])row["ReferenceRangeDetails"];
MemoryStream ms = new MemoryStream(bData);
gwReferenceRange.WebWorksheets.ImportExcelFile(ms);

// save data to db from grid
SqlParameter sp = new SqlParameter("@ReferenceRangeDetails", SqlDbType.Image);
e.Command.Parameters["@ReferenceRangeDetails"] = sp;
// get the reference range stream
MemoryStream ms = new MemoryStream();
gwReferenceRange.WebWorksheets.SaveToExcelFile(ms);
sp.Value = ms.GetBuffer();

Can you help?

Hi,

Thank you for considering Aspose.

Well, we are not able to reproduce the issue using VS 2005 and IE7; we will also try to explore your issue by creating the similar environment as yours and see if we can reproduce the mentioned issue. Also, we will appreciate it if you can share your sample application to reproduce the issue, this way it will be a lot easier to figure out the actual issue.

Thank you for understanding,

I thought we had this fixed but our customer is again saying that the formatting is being lost in the grid. Here is a a bit more information that may help. I have the grid in an aspx page that is using AJAX. The symptom is that you can add data to a cell, then format it with justification, new font, bold, etc. When the page gets posted in a partial page update, often the formatting is lost at the end of the post.

Hi,

We appreciate if you could try our latest version of Aspose.Cells.GridWeb from the installer (Aspose.Cells.msi v4.8.0) in the download module: http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry195573.aspx

Note: Just for your knowledge. In the new release of Aspose.Cells for .NET v4.8.0, we have merged Aspose.Grid suite to Aspose.Cells for .NET msi installer as Aspose.Grid would be no longer offered as a separate product now. You need to install the installer (uninstall older one first if you have) and may use Aspose.Cells.GridWeb.dll control library in your project for your need.

Also, please check the document on how to upgrade from Aspose.Grid.Web to Aspose.Cells.GridWeb: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/upgrade-from-aspose-grid-web-to-aspose-cells-gridweb-control.html

If you still find any issue, kindly create a sample application and post it here to reproduce the issue, we will check it soon.


Thank you.


Hi,

Initial tests looks like this has fixed the issue.

I would like to suggest an enhancement for the grid component. While testing, we stage most of our sites to a /new directory (e.g. `www.myapplication.com/new`). The code worked fine in my dev environment but not in the staged environment. I eventually tracked the issue to the following web.config statement.

<add key="aspose.cells.gridweb.acw_client_path" value="/acw_client/" />

Since the name of the directory for the support files had changed, that directory did not exist on the main site and the grid did not work well. I changed it to the following

<add key="aspose.cells.gridweb.acw_client_path" value="/new/acw_client/" />

and it worked fine.

The enhancement I am suggesting is to allow the ~ syntax in that statement as follows..

<add key="aspose.cells.gridweb.acw_client_path" value="~/acw_client/" />

This would anchor the directory relative to the application and not the domain or virtual directory it is deployed to.

Please feel free to contact me if this does not make sense.

Scott

Hi Scott,

Thanks for your suggestion,

We will check it and get back to you soon.

Thank you.