GridWeb.ImportExcelFile throws exception &quot;Object reference not set to an instance of an object&quot;

aspose.notifier · February 21, 2011, 1:46am

The issues you have found earlier (filed as 24155;24155) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.

aspose.notifier · February 21, 2011, 2:38am

The issues you have found earlier (filed as 24155;24155) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.
(1)

wahid.choudhury · February 28, 2011, 5:49am

Hi,
I found an issue with the version 2.5.0.2001 that I’m using right now. If you load the attached excel file “CurrencyFormat.xlsx” with the project that I attached before, you’ll see that for each currency formatted cells the grid shows unnecessary token “_)” at the end of each cell value.

Thanks.
Wahid

amjad.sahi · February 28, 2011, 11:15am

Hi Wahid,

Yes, we noticed the issue you have talked about using your latest file “CurrencyFormat.xlsx”. I have reopened your issue “CELLSNET-24155” again, we will figure it out soon.

Thank you.

amjad.sahi · March 1, 2011, 4:20am

Hi,

Please try Aspose.Cells.GridWeb v2.5.0.2002 (attached). We have fixed the number formatting issue.

Thank you.

wahid.choudhury · March 2, 2011, 10:41pm

Hi,
I found my problem fixed into v2.5.0.2002.

Thank you.

aspose.notifier · March 17, 2011, 6:47am

The issues you have found earlier (filed as 24155) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.

wahid.choudhury · April 27, 2011, 1:41am

Hi,
We’ve successfully integrated the grid component in our application and its already in live. We got an issue from one of our client. He faced problem in loading and working with the attached excel file. The page takes un-acceptable amount of time to load and sometime the browser hangs. Even if the page loaded successfully after several timeouts, user gets very annoying experience while editing cells.

The excel file contains formulae in the hidden sheet ‘ValidationData’.

Can you please investigate the issue ASAP?

Thanks.
Wahid

amjad.sahi · April 27, 2011, 2:59am

Hi,

I have tested to load your file to
GridWeb using our latest version v2.5.2.200x and found the issue as you have mentioned.

I have logged your issue with an id: CELLSNET-26523. We will look into it soon.

Thank you.

shakeel.faiz · April 28, 2011, 9:27pm

Hi,

We have tested “800 Entity.xls” using AutoExtendMaxRowColumn = false. The loading speed is faster.

Please refer to: https://forum.aspose.com/t/131989

Alternatively, you can try to use EnablePaging option.

We are implementing loading gridweb asynchronously. This will enhance the performance much on client side. It will take about 2-3 weeks.

Currently, you can try the options above.

shakeel.faiz · May 20, 2011, 1:20am

Hi,

We have implemented the feature of loading data asynchronously in Aspose.Cells.GridWeb v2.5.3.2001. There is an attribute named “EnableAsync” to specify whether to enable to load data asynchronously.

Note: It is not available when using one of NoScroll, EnablePaging or DataBinding. You can fetch data via scrolling the vertical scroll bar on client side.

Please try the following lines to load your excel file:

C#

if (!IsPostBack)
{
GridWeb1.EnableAsync = true;
GridWeb1.AutoExtendMaxRowColumn = false;

string pathinfo = Request.PathInfo;

if (pathinfo.StartsWith("/"))
pathinfo = pathinfo.Substring(1);

if (pathinfo != “acw_ajax_call”)
{
GridWeb1.WebWorksheets.Clear();
GridWeb1.WebWorksheets.ImportExcelFile(@“c:\excel\800+Entity.xls”);
return;
}
}

Please update the dll and update acwmain.js into /acw_client virtual directory.

wahid.choudhury · June 8, 2011, 1:31am

Hi,
I’ve tested the latest version Aspose.Cells.GridWeb v2.5.3.2001 in the attached project. It works nice now for big files though the CPU/Memory usage goes incredibly high for the W3P process while loading big files. But one burning issue returns which I solved before with the help of GridWeb client side API.

Issue Details: After loading an excel file in the grid, when a user is in editing mode in a cell, user clicks on a postback button, at the button postback event the edited data isn’t available. But after editing if the user press tab to navigate to adjacent cell and then press the button, the data is available.
Button Code:
<asp:Button ID=“btnSave” runat=“server” Text=“Save” OnClientClick=“UpdateGridData();” OnClick=“btnSave_Click” />

I solved the above issue by introducing the UpdateGridData() JS function:
function UpdateGridData() {
// get the grid
var grid = GetGrid();
if (grid) {
grid.updateData(false);
grid.validateAll();
}
}

It works fine with the older version Aspose.Cells.GridWeb+v2.5.0.2002. But it doesn’t with the latest version.

Please help urgent.

Thanks.
Wahid

shakeel.faiz · June 8, 2011, 2:00pm

Hi,

Thanks for reporting the problem.

I have logged your problem and comment in our database. We will fix it asap.

This issue has been logged as CELLSNET-28227.

Please also test it on latest version Aspose.Cells.GridWeb v2.5.3.2005 and let us know your feedback.

shakeel.faiz · June 8, 2011, 9:20pm

Hi,

The updateData() updates data asynchronously when using EnableAJAX.

The btnSave_Click postback event is fired early than updateData() on server side. So, we have to invoke updataData() synchronously on client side. The issue is resolved now.

Please modify ‘btnSave’ tag as:

ASP.NET

<!–[if gte mso 9]>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val=“Cambria Math”/>
<m:brkBin m:val=“before”/>
<m:brkBinSub m:val="–"/>
<m:smallFrac m:val=“off”/>
<m:dispDef/>
<m:lMargin m:val=“0”/>
<m:rMargin m:val=“0”/>
<m:defJc m:val=“centerGroup”/>
<m:wrapIndent m:val=“1440”/>
<m:intLim m:val=“subSup”/>
<m:naryLim m:val=“undOvr”/>
</m:mathPr></w:WordDocument>
<![endif]–><!–[if gte mso 10]> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;}

<![endif]–>

<asp:LinkButton runat="server" ID="btnSave" style="display:none;" OnClick="btnSave_Click"></asp:LinkButton>

And modify ‘UpdateGridData’ function as:

function UpdateGridData() {

var grid = GetGrid();

if (grid) {

var acp = grid.ajaxcallpath;

grid.ajaxcallpath = null; // disable EnableAJAX

grid.updateData(false);

grid.validateAll();

var btnSave = document.getElementById(“ctl00_mainContent_btnSave”);

btnSave.click();

grid.ajaxcallpath = acp; // restore EnableAJAX

} //if

}//Update

aspose.notifier · June 16, 2011, 7:55pm

The issues you have found earlier (filed as 26523) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.

wahid.choudhury · May 28, 2012, 1:36am

Hi,
It’s been long time since I post last. I’m currently using aspose.cells.gridweb licensed version 2.5.3.2001. Receiving some constant complains from our client:

The page is too heavy due to the components script files even though the size of the excel is very small.
Doesn’t works well in ajax mode and its buggy.
Selecting one cell and then start editing, it doesn’t take the first key stroke as its for entering the cursor to the cell.

and few others…

I downloaded the latest trial version 2.7.6.2000. Is there any massive improvement on the latest build regarding the point mentioned above? If so I’m planning to buy the license ASAP.

Thanks.

Wahid

shakeel.faiz · May 28, 2012, 1:41am

Hi,

Thanks for your posting.

We have fixed some of reported bugs which we will publish in a release notes when we will release a major version.

However, I will strongly recommend you to download and try the current latest version:
Aspose.Cells
for GridWeb v2.7.6.2003

Let us know your feedback.

shakeel.faiz · June 21, 2012, 6:00am

wahid.choudhury:
Hi,
I'm now testing the new version you suggested. But I've one important query. GridWeb.ModifiedCells contains a collection of WebCell. Is there any way to get the corresponding sheet name of the modified webcell?

Thanks.
Wahid

Hi,

Please download and use the latest version: Aspose.Cells for GridWeb v2.7.7.2002

Please refer to this thread.
Is there any way to get the corresponding sheet name of the modified webcell?

For your newer issues, please create newer thread.

wahid.choudhury · June 25, 2012, 2:14am

Hi,
The latest version doesn’t work as it crashes to load a simple excel file.

For “Sheet Name with modified cell (s)”, I didn’t get any solution following link you provided. I need this urgent. Can you help?

Thanks.
Wahid

shakeel.faiz · June 25, 2012, 3:01am

Hi,

The sheet name should be active sheet name of a gridweb control e.g

GridWeb1.WebWorksheets.ActiveSheet.Name

GridWeb.ImportExcelFile throws exception &amp;quot;Object reference not set to an instance of an object&amp;quot;

GridWeb.ImportExcelFile throws exception "Object reference not set to an instance of an object"