Hello all,
We are having some odd issues with one of our boxes. We can create smaller type excel files but for some reason after they get to say 60 + meg we are getting Invalid Formula errors it seems only on a certain box. Is there any special permissions etc. considerations we need to be aware of for either saving to dish or using the memory stream to output the excel file?
Hi,
Thank you for Considering Aspose.
Well, There are no limitations from Aspose.Cells to generate any size of file. As you are saying that this problem is occuring in some specific machine, that means there is some problem / issue with that particular machine. This issue may be occuring due to less phsical memory or the less page file size on that particular machine. Please share the details regarding the enviroment on your machine (like OS , Processor Speed , Physical Memory etc) and also can you please create a sample application and upload it here with your template file. Also please provide the complete error message you are getting. This will help us figure out the issue.
Also Please confirm us, whether you have tested this issue on some other machine as well? Does it work fine on that machine?
Thank You & Best Regards,
We are narrowing in on it now, but it for sure something to do with after a specific file size without certain permissions on the app pool or directory it starts throwing invalid formula errors and creates a 0KB file on the save. It is not just one computer either we can recreate it on all of them.
Here is the error but this does not happen everytime it is very intermittent we are seeing it.
----------------------------------------
Timestamp: 12/29/2008 6:05:49 PM
Message: User : Sean Borelli
Message : Invalid formula:
Source : Aspose.Cells
StackTrace : at Aspose.Cells.Cell.܂(Byte[]& և, Int32& ܃, Int32 ֊, ܨ թ)
at Aspose.Cells.Cells.կ(ܨ թ, FileFormatType հ)
at Aspose.Cells.Worksheet.կ(ܨ թ)
at Aspose.Cells.Worksheets.խ(ܨ թ)
at Aspose.Cells.Worksheets.ղ(FileFormatType հ)
at Aspose.Cells.Worksheets.կ(Stream թ, FileFormatType հ)
at Aspose.Cells.Workbook.Save(Stream stream, FileFormatType fileFormatType)
at Aspose.Cells.Workbook.Save(String fileName, FileFormatType fileFormatType)
at Reporting_K1SummaryCheckOut.CreateK1SummaryTemplate() in C:\Projects\trunk\Web\Reporting\K1SummaryCheckOut.aspx.vb:line 727
TargetSite : Void ܂(Byte[] ByRef, Int32 ByRef, Int32, Aspose.Cells.RW.ܨ)
Environment.StackTrace : at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at Utility.ReturnError(Exception ex, String strUserName) in C:\Projects\trunk\Web\App_Code\Utility.vb:line 206
at Reporting_K1SummaryCheckOut.CreateK1SummaryTemplate() in C:\Projects\trunk\Web\Reporting\K1SummaryCheckOut.aspx.vb:line 744
at Reporting_K1SummaryCheckOut.btnCheckOut_Click(Object sender, EventArgs e) in C:\Projects\trunk\Web\Reporting\K1SummaryCheckOut.aspx.vb:line 371
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.reporting_k1summarycheckout_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
at System.Web.HttpApplication.ResumeSteps(Exception error)
at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
at System.Web.HttpRuntime.ProcessRequestNow(HttpWorkerRequest wr)
at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
at System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
at Microsoft.VisualStudio.WebHost.Request.Process()
at Microsoft.VisualStudio.WebHost.Host.ProcessRequest(Connection conn)
Category: General
Priority: -1
EventId: 1
Severity: Information
Title:
Machine: USBOSSBORRELI
Application Domain: 98c9a764-1-128750460382087134
Process Id: 6088
Process Name: C:\Windows\Microsoft.NET\Framework\v2.0.50727\WebDev.WebServer.EXE
Win32 Thread Id: 5312
Thread Name:
Extended Properties:
----------------------------------------
Why would this throw an error we cant understand it after about 30 sheets it starts doing this:
Invalid formula:
=SUM($AI$340:$AJ$340)
Invalid formula: =SUM($AI$340:$AJ$340)
Did this above error message occur on Workbook.Save method or during Cell.Formula property?
Can you verify the version of Aspose.Cells in your machine? Could you uninstall all previous versions of Aspose.Cells and deploy the latest version? Thank you.
Hi,
Thank you for providing the details. We are looking into your issue and we will get back to you soon.
Thank You & Best Regards,
I have uninstalled everything and using the latest 4.603 version you had sent a while ago. These random formula errors happen after larger size files around 30 sheets or more they start appearing for no reason. The smaller files work fine with the same exact formulas going into each sheet.
Hi,
Thank you for considering Aspose.
Well, after further investigating your issue, we think that this exception should be OutOfMemoryException. PLease try the attached latest fix of Aspose.Cells. Now, if the OutOfMemoryException is thrown in the 4.6.0.5 fix, we will directly throw it. If you really get OutOfMemoryException with this fix, Please check how much size of the file you are creating and could you share your projects here? We will check it ASAP.
Thank You & Best Regards,
Yes it is now throwing out of memory exceptions. Once it gets to about 30 sheets at about 50 Meg the API throws the error. However, watching the memory on the server it does not seem to have a problem spiking, it is the API that throws it. We have dedicated 4 gig of memory and it seems fine.
Your application is an aspnet program which running within IIS, isn't it? Please monitor w3wp.exe private bytes. If it > 800mb, there is an increases risk of .net OutOfMemory Exceptions.
To create a 50MB Excel file, Aspose.Cells will take up more than 500MB memory. So please don't concurrently create such files in your application.
If your application is a console application, I think this exception won't be thrown in your case.
Yes unfortunatly this API won’t be able to handle what we are looking for. Is there anything that can be adjusted so it does not chew up so much memory?