EXCEL 2016: NEW RADIAL GRAPH ISSUES

Aspose.Cells Product Family
1

Hi all,
we have a Excel file created with Excel 2016 with a Radial Graphs as attached in file “RADIAL_GRAPH.xlsx”.
We have some issues exporting in HTML or Excel:

1.Exporting in HTML (or SVG) the graph isn’t correctly exported, the export is different, see ASPOSE_HTML_EXPORT_RADIAL_GRAPH.png

2.Exporting in Excel, before of Enabling Modify of Excel file the graph seems correct, after Enabling modify the labels appears confused, try with file ASPOSE_EXPORT_RADIAL_GRAPH.xlsx.

Look ahead for you feedback.
Best regards.
aspose.zip (135.3 KB)

2

@gmaglie,
We were able to observe the issue where Radial chart is not rendered properly into an HTML file but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-43019 – Radial graph not rendered properly to HTML

Regarding your second issue, I could not reproduce it by using following sample code with latest version Aspose.Cells for .NET 19.9.

Workbook wb = new Workbook(path + "RADIAL_GRAPH.xlsx");
wb.save(path + "output.xlsx",SaveFormat.XLSX);

Could you please share more details about this problem by providing runnable console application to create this file (if created by Aspose.Cells) or exact steps to reproduce this issue here. When I open your “ASPOSE_EXPORT_RADIAL_GRAPH.xlsx” in Excel, it shows incorrect chart labels, however when I try to generate this file locally, no issue is observed. We will analyze this issue more once your feedback is received.

3

Hi,
for the second issue we do a refresh of objects before saving the file with this code:

						sheet = book.getWorksheets().get(1);
						
						ShapeCollection sColl = sheet.getShapes();
						if (sColl!=null){
							for (int nP = 0; nP < sColl.getCount(); nP++) {
								Shape sh = sColl.get(nP);
								sh.updateSelectedValue();
							}
						}
						for (int nP = 0; nP < sheet.getCharts().getCount(); nP++) {
							Chart ch = sheet.getCharts().get(nP);
							ShapeCollection schColl = ch.getShapes();
							if (schColl!=null){
								for (int nP1 = 0; nP1 < schColl.getCount(); nP1++) {
									Shape sh = schColl.get(nP1);
									sh.updateSelectedValue();
								}
							}
							ch.calculate();
						}

Regards.

4

@gmaglie,
Thank you for providing the sample code. We have observed the second issue also and logged it as follows:

CELLSJAVA-43020 - Radial graph distorted after calling Shape.updateSelectedValue()

5

Hi,
any news about the follows open issues ?

CELLSJAVA-43019 ---- Status : Open
CELLSJAVA-43020 ---- Status : Open

6

@gmaglie,
These issues are still not resolved due to their complexity and other high priority tasks in the queue. We will write back here as soon as any update is available in this regard.

7

@gmaglie,

Please try our latest version/fix: Aspose.Cells for Java v19.10.3(attached)

We have made some improvements in the fix regarding issue “CELLSJAVA-43019”.

Let us know your feedback.
Aspose_Cells_Java_v19.10.3.zip (6.6 MB)

8

The issue is Solved.
Thank you,

9

@gmaglie,

Good to know that your issue is sorted out by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

10

Hi, any news about issue CELLSJAVA-43020?

11

@gmaglie,

I am afraid, your issue is still not resolved as it is in process.
We will check if we can provide you an eta on the issue.

Once we have an update on it, we will let you know.

12

The issues you have found earlier (filed as CELLSJAVA-43019) have been fixed in Aspose.Cells for Java v19.11. This message was posted using Bugs notification tool by ahsaniqbalsidiqui

13

@gmaglie,

This is to inform you that we have fixed your issue “CELLSJAVA-43020” now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

14

@gmaglie,

Please try our latest version/fix: Aspose.Cells for Java v19.11.2:

aspose-cells-19.11.2.zip (6.6 MB)

Your issue “CELLSJAVA-43020” should be fixed in it.

Let us know your feedback.

15

Hi, thank you, we tested and we can consider closed the issue.
Best regards.

16

@gmaglie,
Good to know that your issue is sorted out by the suggested version. Feel free to contact us at any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

17

The issues you have found earlier (filed as CELLSJAVA-43020) have been fixed in Aspose.Cells for Java v19.12. This message was posted using Bugs notification tool by ahsaniqbalsidiqui