Hi,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Grid.Web. We have improved the performance of formula calculation engine in AJAX mode.

Thank You & Best Regards,

Thanks!

But I found another issue.

The "hyperlink",style of the cell is invalid when I use "2.0.1.2007" or "2.0.1.2008" of Asposer.Grid.Web;

If I use "2.0.0.2001"  and set the cell's style is "hyperlink", the mouse cursor will become a finger when user move the mouse cursor on the cell. And if the user press the left button of his mouse,the target sheet will become is an active sheet.

But I user "2.0.1.2007" or "2.0.1.2008",the  mouse cursor can't become a finger when user move the mouse cursor on the cell. Then the user can't change the sheet when he hit the cell;

The following is my code:

……

foreach (DataRowView drv in dv)
        {
            WebCell cell = sheet.Cells[int.Parse(drv["ROW_INDEX"].ToString()), int.Parse(drv["COLUMN_INDEX"].ToString())];

            cell.IsLocked = (drv["ISLOCKED"].ToString() == "1" ? true : false);
            cell.IsReadonly = (drv["ISREADONLY"].ToString() == "1" ? true : false);

            #region Formula
            if (drv["FORMULA"].ToString() != "")
            {
                cell.Formula = drv["FORMULA"].ToString();
                cell.IsLocked = true;
                if (cell.Formula.Contains("!") && (templateSheetIndex == 0 || cell.Row == 0)) SetHyperlinkStyle(cell); 
            }
            #endregion

         ……

}

……

    private static void SetHyperlinkStyle(WebCell cell)
    {
        cell.Style.BackColor = Color.White;
        cell.Style.ForeColor = Color.Blue;
        cell.Style.Font.Underline = true;
        cell.Style.CssClass = "hyperlink";
    }

……

Hi,

Well,  we have tested the hyperlinks style, it works fine, the finger visual icon does appear when moving the mouse cursor onto the hyperlink.

We think the problem is in your css class file. Please check your css if it is fine. If you still find the issue, kindly create a sample project, zip it and post it here with your css file attached to reproduce the issue, we will check it soon.

Thank you.

Well,I am sure there is a error in my code.

But I still found another issue about the version "2.0.1.2008" of aspose.grid.web

If I use "2.0.1.2008",my system will appear following error:

A javascript error and formula belong to other sheet appear in  actively sheet without rhyme or reason.

There are some mention about this issue:

1.Replace "2.0.0.2001" by 2.0.1.2008

2.Load a excel in aspose.grid.web;The attachment is my excel file(ToVendor.xls):the "fixture_list" sheet is our test sheet.the value of some cells in the "PCA_BFT" is from "fixture_list" sheet by formula.(e.g:A22 of "PCA_BFT"=fixture_list!A4 )

3.Set the "fixture_list" is actively;

4.Input some value into A4 of "fixture_list" sheet.

5.Set the A4 of  "fixture_list" sheet lose the focus;

6.Then,a javascript error appeared(please look the picture).And at the same time the valuse of A22 of  "fixture_list" sheet become the same value to A4 of "fixture_list" sheet. However,in my excel file ,the A22 of  "fixture_list" sheet didn't set any formula.After I repetitious try, I found this error formula seems from A22 of "PCA_BFT" sheet,because the position of error cell is same to the  A22 of "PCA_BFT".

7.I ignore this error and input values into others cells.

8.After I change the actively sheet and come back again, the value ,I inputted, has lost but the value of A4;

This issue don't appear when I use "2.0.0.2001".

I don't know if you can know Chinese,the javascript error is:

line:3154

character:4

error: Can't get the content of fontWeight,parameter invalid 

code:0

Please help me to fix this issue,thank you  very much!

Hi.

Thanks for providing us the template file with details.

Well, I have tried and implemented your scenario and performed all your steps using your template file with v2.0.1.2008 version of the GridWeb,  but could not re-produce any issue at all. I have conducted the test 2, 3 times, inserting different sets of values in "fixture_list" cells including A4 and checking other sheet (including "PCA_BFT") cells including A22. Everything  works fine as expected. Which IE browser type you are using, I am testing it on IE6.0 though.

Anyways, we will further check it if we can find any issue on our side.

Thank you.

Hi,

After further investigation, we have tested the ToVendor.xls file on MS Ajax mode and found the issue. We have fixed it in v2.0.1.2009, please try the attached version and let us know if it works fine now.

Thank you.

Thanks!

I hvae try it yesterday and it seems  no issue when I used V2.0.1.2009.

I will try it go on in today. If I find any others issue, I will post in on here.

Thank you for your quickly and efficient support!