Dear all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Again a new problem with tickllabels. Please consider the attached files. The file reportAspose.xls shows the generated xls file (based on the provided sourcecode and example excel file) The file reportAspose.pdf shows the report after saving the file in pdf format. As you can see, there is a difference between the representation of the ticklables in both files where the value consists of a calendar week and a year.
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Thank you for considering Aspose.
I tested your template file with the latest version of Aspose.Cells and it works fine (resultant file attached).Please download and try the latest version of Aspose.Cells from the following location and see if it works fine for you.
Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
I have downloaded the latest Aspose.Cells version. Unfortunately I’m also with this version unable to create the correct pdf output.
I also noticed two other issues with the new version (compared to version 4.8.1.10):
In the old version I was able to run the following code:
for (int i = 1; i < wb.Worksheets.Count; i++)
{
wb.Worksheets[i].IsVisible = false;
}
My intention is to hide first of all worksheets of the workbook. Then, during the report generation process, all needed worksheets are set visible again. If I run the shown code with the latest aspose version, I get an exception that the workbook should contain at least one visible worksheet.
The new version shows bad results if you convert a chart with an image to pdf (
I have used the new version v4.8.2.0 and it works fine. Please find attached the generated pdf file here. So, kindly make sure that you have used the latest version v4.8.2 in your project.
My sample code: Workbook excelWorkbook0 = new Workbook(); excelWorkbook0.Open(@“e:\test\ticks\Report.xls”);
foreach (Worksheet ws in excelWorkbook0.Worksheets) {
In the old version I was able to run the following code:
for (int i = 1; i < wb.Worksheets.Count; i++)
{
wb.Worksheets[i].IsVisible = false;
}
My intention is to hide first of all worksheets of the workbook. Then, during the report generation process, all needed worksheets are set visible again. If I run the shown code with the latest aspose version, I get an exception that the workbook should contain at least one visible worksheet.
The new version v4.8.2 works similar to MS Excel. If you could conduct a test manually in MS Excel 2007, you just try to hide all the worksheets in a workbook, you will find the similar error message (generated by MS Excel this time). We follow the MS Excel standards, so there should be at least one visible worksheet in the workbook.
Hi ,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Thank you for the provided fix. It works but it also generates a new problem. If I set the TickLabelSpacing property to 5 or any other value, most of my textboxes in the chart are lost (it seems that they are located at the right chart border). You can reproduce the issue with the files provided there.
Hi ,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Thank you for the provided fix. It works but it also generates a new problem. If I set the TickLabelSpacing property to 5 or any other value, most of my textboxes in the chart are lost (it seems that they are located at the right chart border). You can reproduce the issue with the files provided there (you have to add a line to set the ticklabelspacing property).
eoe: