I have two questions about aspose.grid.web

Aspose.Cells Product Family
1

Hi Admin:

I have two questions:

1. In Excel,whenthe cloumn's width is very narrow,the value of the cell of this cloumn's will become "###";For exampl,"2009/6/15"=>"###"; Does the aspose.grid.web has this function? I don't know how set it. If the aspose.grid.web has not this function, how can I do when I want to achieve this qeuest?

2.When I load some very huge sheets, the Excel math function's count will become very slowly! For example, C1=A1*B1, after I input the value in A1 and B1,some seconds later, the value of the C1 just be show.It is so slowly! Because my user want to get the result in few seconds! The attachment is my test Excel file, you will load it and test this function.

Thank you very much!

2

Hi,

Thanks for providing us the template file with details.

1). We will check your desired feature if we can support it. We will get back to you soon.

2). I have loaded your template file into GridWeb, When I insert values into A2,B2 cells and apply the formula into C2 (i.e.., = A2*B2) of a sheet, e.g "sub part" sheet, it does take 5,6 seconds to calculate the formulas when clicking submit button on the Grid, I think it it normal in a web scenario as your template file is huge with long list of formulas. For your info, when you click submit button on the grid, it calculates/recalculates all the formulas in all the sheets in the workbook. How much time it takes to calculate the formulas and do you calculate the formulas by code e.g WebWorksheets.RunAllFormulas() or click the submit button on the grid? Which version of the GridWeb you are using? Could you give us some more information, we will check your issue soon.

Thank you.

3

Thank you for your reply!

I think my system calulate the formulas by code,but I need conform it with my code designer in tomorrow.In one sheet(e.g "BFT"),it takes almost one minute when the last value is calculated by formulas.
I use the aspose.grid .web 2.0.0.2001. I can't use the aspose.grid.web 2.0.1.2000 because that the cache of system can't be cleared when I have used the 2.0.0.2001.

4

Hi, what about my 1st question?

5

Hi,

Well, I am afraid, we cannot support it.

Sorry for any inconvenience.

6

Hi

I have an urgent issue and need your help:

Issue:

It spends 30 seconds to calculate formula in excel with Aspose.Grid.Web

But the time we can accept is less than 3 seconds

Detail operation steps as below:

  1. The version of Aspose.Grid.Web: V2.0.1.2007

  2. We loaded an excel as file attached. the file, about 1.8M, has a lot formula to be calculated.

  3. We set the attribute as Ajax(EnableAJAX=“True”)

  4. Switch to sheet“PCA_EBT” and enter value in cell B10(e.g: 10)

  5. Base on the formula in excel, cell B15 should come out immediately. But in fact, it should spend about 30 seconds.

The speed is not acceptable, and we expect the calculation time can be reduced to 3 seconds.

Thanks and Best Regards

7

Hi,

Thanks for providing us the template file.

We will look into your issue and get back to you soon.

By the way, do you use MS Ajax extensions, kindly provide complete details about your environment, OS, IIS settings, .NET framework, Browser type etc.

Thank you.

8

OS:Windows Server 2003 IIS: IIS6 Net:Local area network in our company;

I can provide the most information about our system in tomorrow when I come back company and ask my colleague, but I am in China, GMT+8(Time zone). Our work time is 8 hours later, What time you are online? Which way I can contact with you in time? Because this question must be solved in tomorrow. Thank you for your timely support. Thanks！

You can check our issue in usual web server.(e.g cpu:2.4*2 ; Ram:3G). Thanks!

9

I think it is a client event that the aspose.grid.web calculates/recalculates all the formulas in all sheet. It take long time should be have no relationship between the client(IE6.0) and our web server.That’s my point of view.What do you think?

10

Hi,

Well, the best support (Customer support) you can can have is via forum, our forum support is fast, so, kindly check this thread to get replies.

We will get back to you soon.

Thank you.

11

What about this question?

Our environment:

OS:Microsoft Windows Server2003 Enerprise Edition SP2
CUP:Inter Xeon 3.2G
RAM:3.5G
IIS:6.0
.NetFrameWork:2.0.50727.832
Browser:IE6.0
Net:Local area network in our company

If you want get more info?

12

What't about now?

13

Hi,

We are working on the performance issues regarding calculation of formulas, we will fix them in a few days, we will provide a fix here as soon as we complete the task.

Thanks for your understanding and sorry for any inconvenience.

14

What about this question ,now? It is very urgent for me,thank you for your great effort!Thanks!

15

Hi,

Hopefully, you can find the fixed/enhanced version (regarding performance of formula calculation engine) in 1-2 days.

Thanks for being patient!

16

Thank you very much! I will expect the enhance version! Thanks!

17

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 <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" />AJAX mode.

Thank You & Best Regards,

18

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";
}

……

19

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.

20

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!