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!

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.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

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.

Hi, what about my 1st question?

Hi,

Well, I am afraid, we cannot support it.

Sorry for any inconvenience.

 

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

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.

 

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

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!

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?

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.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

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?

What't about now?

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.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

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

Hi,

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

Thanks for being patient!

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us