hello, i know what you say. but you lose my question. In my sample project, if i use AutoFitRows(int), it tooks even more 15 minutes, if i don’t use this function, it tooks 30 seconds.
Hi Lu,
Thank you for writing back.
I have logged an investigative ticket (CELLSNET-42445) in our bug tracking system to look further into the performance related issue of AutoFitRow(int rowIndex) method, as I have noticed that un-commenting the last statement from the below provided code snippet decreases the execution time to a great deal.
C#
DataRow dr;
for (int i = 0; i < 1500; i++)
{
dr = dt.Rows[i];
for (int j = 0; j < 10; j++)
{
cell = ws.Cells[i, j];
cell.PutValue(dr[j]);
cell.SetStyle(wb.Styles[idx]);
}
//Un-commenting below statement increases the execution time
//from 769 to 6682 milliseconds
// ws.AutoFitRow(i);
}
Please spare us little time to properly analyze the cause on our end. In the meanwhile, we will keep you posted with updates in this regard.
Thank you very much. When “.SetStyle()” and “.AutoFitRow()” appear together, then the function “AutoFitRow(int)” take up a lot of time.
If i use “SetStyle” or “AutoFitRow” alone, it’s very fast. So i think there’s somthing wrong with them, “.SetStyle()” and “AutoFitRow(int)” .
Only a few people have this issue.
Only a few people have this issue.
Only a few people have this issue.
Hi Lu,
Thank you for your valuable observation.
I have verified the scenario on my end, and therefore logged your comments to the ticket already attached with this thread for thorough investigation. As soon as some news comes in, we will post here for your kind reference.
Hi,
Yes, they have not enough permissions to access the fonts directory.
Hi,
What should i do?
Hi Lu,
We are looking in the matter to propose a solution but please note that Aspose.Cells for .NET APIs
require Full Trust permissions set in order to access registry entries and font directories. Please check out the below linked technical article for your kind reference.
http://www.aspose.com/docs/display/cellsnet/Declaration
How to get all permissions?
Thank you very much. babar.raza
Hi Lu,
Full trust means that your application needs all rights that the .NET framework provides. Application developers declare which trust level their application needs in order to be able to run, this is known as “Code Access Security”. Code access security is a way of telling the compiler via attributes which kind of operation your code needs in order to succeed. These attributes are set into the application configuration files depending upon the application type. Please read more details about Security in the .NET Framework. If you are developing an ASP.NET application, please also check the technical article for ASP.NET Trust Levels.
Thank you for your write back.
Hi Lu,
All relevant details have already been shared in the previous post. Please go through the reference documents in order to get acquainted with Trust Levels and Code Access Security.
If you find any difficulty, please provide more details about your application, its type, deployment procedure and how it serves your customers.
Hi,
Please download and try our latest fix/version: Aspose.Cells for .NET v7.7.2.5
The issues you have found earlier (filed as CELLSNET-42445) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.