Hi

We just tried to use Apsose.Cells to convert a Excel 2003 spreadsheet to 2007 .xslx format.
It worked but all references to a chart were lost.

Is this a known issue?

Attaxched a zip wioth xls input file and xlsx file created by your solution

Colin

---

This message was posted using Page2Forum (attachment) from Aspose.Cells for .NET and Java - Documentation

Hi Colin,

Thanks for providing us the template files,

We will figure out your issue soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Colin,

Well, I'm afraid the feature (exporting charts in .xlsx files) is not available yet, we are working on it and will support it in our future versions.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Do you have any timescales on this?

I was very interested in the product to upgrade Excel files to lates version (in order to then run them through some exsiting code that is only 2007 compatable) but without support for charts it is not a solution.

Hi,

We will get back to you soon if we can give you an eta for the feature.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

  Hope we can support Charts and Shapes for Excel 2007 xlsx format at Oct. Thank you.

---

Johnson Shi
Developer
Aspose Nanjing Team
About Us
Contact Us

Hi

Thats good news.

I was als oreading in http://www.aspose.com/community/forums/115537/get-excel-chart-as-image-in-java/showthread.aspx that

a) you cannot save an Excel chart (any format of Excel) to an image using Java
b) user could not get text to come out on chart

I also read in your documentatio naht many chart types (specifcally 3D charts) are not supported even in the .Net version

Can you please tell me if any of the above three issues will be fixed for Java in october or later in yuor Roadmap?

Thanks

Hi,

We will get back to you to provide an eta for a) and b) soon.

I also read in your documentatio naht many chart types (specifcally 3D charts) are not supported even in the .Net version

Do you mean chart2image feature for 3D charts in .NET version, well, we are working on it and will support 3D charts 2 image soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Thnaks I look forward to your reply

and yes I did mean Chart2image (which as Is tated in earlier question) I  really also need in 3D

Hi,

  We are working on supporting reading existed Charts now, and it should be supported not later than supporting Charts related feature for Excel2007. For your question b), if you mean reading properties of existed Charts from template file, we can supported it in october. if you mean other things, please describe it with more detail. Thank you.

  At the same time, we are working on the chart2image feature too, hopfully we can support it together with supporting other Chart related features in october.

---

Johnson Shi
Developer
Aspose Nanjing Team
About Us
Contact Us

Hi,

  For chart2image feature, we can only support following chart types at first in our ETA:

   Line
   Pie
   Clustered Column
   Clustered Bar

---

Johnson Shi
Developer
Aspose Nanjing Team
About Us
Contact Us

Hi

thanks for the quick reply, as suggested in previous reply let me outline my requirements and you can tell me if it will be possible in next planned release or later or if there is another technique that could be used, thanks..

Overview : get data from Excel submitted by users to a Java sever based code and extract information for publishing to print and web including extarcting charts and generating images for them (as the publishing process does not support EMF/WMF file formats - does support SVG or JPEG or PDF etc etc).
Note - we will also look to do the same sort of thing for charts/Microsoft images using Apsose.Words if possible.

All the following relate to Aspose.Cells For JAVA..

1/ open an Excel 2003 file and save as valid Excel 2007 .xlsx without information loss (specifically embedded Charts)

2/ Open an Excel 2003 file or Excel 2007 file and, for each contained chart, use chart2image
a) creating quality representaiton of chart (no data lost, no text labels lost)
b) support 3D formats of charts when saving to image
- must support those listed by you in previous reply
- for other chart types, if chart is already in 3D format can we do better than just "erroring/leave blank"? For example can it swap chart type to "non 3D" supported version, then we can save using chart2image

3/ All image formats created from charts should be good enough quality to be printed at 300 dots per inch without excessive pixalisation.
Does the quality of image created within your product depend on the size of the chart in the Excel worksheet?
If the quality of bitmap is affected by size, can we use Aspose.cells to resize image bigger before we use Chart2image, and will this result in the better quality we seek?

Hi,

  In our next planned release, corresponding with your questions:

1/ open an Excel 2003 file and save as valid Excel 2007 .xlsx without information loss (specifically embedded Charts)
  We will support this feature.

2/ Open an Excel 2003 file or Excel 2007 file and, for each contained chart, use chart2image
a) creating quality representaiton of chart (no data lost, no text labels lost)
b) support 3D formats of charts when saving to image
- must support those listed by you in previous reply
- for other chart types, if chart is already in 3D format can we do better than just "erroring/leave blank"? For example can it swap chart type to "non 3D" supported version, then we can save using chart2image

  We will try to provide chart2image feature, but supporting Shapes and Charts for 2007 has priority over it and currently we are evaluating it still, for the quality and supported features about it are some crude maybe in the first released version, any way, we will try to enhance it in our next and later versions. For 3D Charts, if it is not supported at begin, I think you can change it's chart type to non 3D by API by your self and then use chart2image.

3/ All image formats created from charts should be good enough quality to be printed at 300 dots per inch without excessive pixalisation.
Does the quality of image created within your product depend on the size of the chart in the Excel worksheet?
If the quality of bitmap is affected by size, can we use Aspose.cells to resize image bigger before we use Chart2image, and will this result in the better quality we seek?

  For the resolution and quantity of created image, I am afraid this feature can't be supported in our next planned release, we will look into it and suppot it in our later versions.

---

Johnson Shi
Developer
Aspose Nanjing Team
About Us
Contact Us