I was checking on the attached file where there are 3 charts in different sheets and content in the 4th Sheet, but i am unable to view in the aspose cells editor. EDA.PC.00000205.zip (19.9 KB)
Attaching the screen shots
MS excel image.png (76.5 KB) image.png (57.4 KB) image.png (88.5 KB)
I understand that you are facing difficulties viewing content and charts in the Aspose.Cells Editor. This issue may arise from various factors, including compatibility with the file format or specific features utilized in your Excel file.
Here are some steps to help you troubleshoot the problem:
Check File Format: Ensure that the file you are trying to open is in a supported format, such as XLSX or XLS. If it is in a different format, consider converting it to a compatible one.
Update Aspose.Cells: Verify that you are using the latest version of Aspose.Cells, as updates often include important bug fixes and enhancements.
Test with a Simple File: Create a new Excel file containing basic charts and content to see if it displays correctly in the Aspose.Cells Editor. This can help identify whether the issue is specific to your original file or a more general problem.
Review Chart Types: Some complex chart types or features may not be fully supported. Check if the charts in your file are of a type that is known to have compatibility issues.
If the problem continues, please consider reaching out to Aspose support with specific details about your file and the issues you are encountering.
Thanks for the template Excel file and screenshots.
It seems like Chart type sheets are not supported in the online editor app and we are unable to view contents and charts in the online editor created by Aspose.Cells.GridJs.
We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSGRIDJS-1949
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
As we have just logged the ticket, we kindly request some time to thoroughly evaluate the issue before we commit a timeline for it. Rest assured, we will provide you with updates as soon as possible.
@Ghani0303
In the sample file, you will find worksheets named chart2, chart3, chart4, and Sheet1. The worksheets chart2, chart3, and chart4 are of the chart type and utilize data from Sheet1. If you wish to display these chart worksheets, kindly ensure that Config.ShowChartSheet is set to true…
Config.ShowChartSheet = true;
//disable lazyloading for worksheet
Config.LazyLoading = false;
then it will be OK to load and display the charts.
In lazy loading way it will fail, the root cause is:
Lazy loading fails to display the chart: The chart’s rendering is performed locally and depends on data from another worksheet. However, lazy loading initially loads only the worksheet containing the chart itself, so the required data cannot be accessed.