Missing or incorrect SmartArt inner shape properties

Aspose.Cells Product Family
1

Hi Team!

I am facing an issue regarding SmartArt shapes in Excel files. The SmartArt shape I have has 2 inner shapes in it, both include a title and a body part which means 4 inner shapes in total. I have set different texts, alternative texts and hyperlink addresses for every inner shape. My problem is that the bodies’ properties (except for text) are lost; they are either empty (e.g: when title is not filled) or the same as the title’s ones (e.g: when title is filled).

I am attaching a demo project with a test file to demonstrate the issue.
excel_smartart.zip (21.4 KB)

Here is its actual output:

---> Sheet1
Main shape properties:
        alttext title: mainalttexttitle
        alttext desc: mainalttextdesc
        link: mainlink
Inner shape1 properties:
        text: text2
        alttext title: 
        alttext desc: 
Inner shape2 properties:
        text: title2
        alttext title: 
        alttext desc: 
Inner shape3 properties:
        text: text1
        alttext title: titlealttexttitle1
        alttext desc: titlealttextdesc1
        link: titlelink1
Inner shape4 properties:
        text: title1
        alttext title: titlealttexttitle1
        alttext desc: titlealttextdesc1
        link: titlelink1

And here is the expected one:

---> Sheet1
Main shape properties:
        alttext title: mainalttexttitle
        alttext desc: mainalttextdesc
        link: mainlink
Inner shape1 properties:
        text: text2
        alttext title: textalttexttitle2
        alttext desc: textalttextdesc2
        link: textlink2
Inner shape2 properties:
        text: title2
        alttext title: 
        alttext desc: 
Inner shape3 properties:
        text: text1
        alttext title: textalttexttitle1
        alttext desc: textalttextdesc1
        link: textlink1
Inner shape4 properties:
        text: title1
        alttext title: titlealttexttitle1
        alttext desc: titlealttextdesc1
        link: titlelink1

I would be grateful if you could assist me.

Thank you,
Tamas Boldizsar

2

@tamas.boldizsar,

Thanks for the template XLSX file.

After an initial testing, I was able to reproduce the issue as you mentioned by using your sample file and code segment. I found some missing or incorrect SmartArt inner shape properties retrieved.

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): CELLSNET-55454

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.

3

@amjad.sahi Thank you!

4

@tamas.boldizsar
You are welcome. If you have any questions, please feel free to contact us.

5

@tamas.boldizsar
Hi,
Your issue(CELLSNET-55454) has been resolved and the fixed functionality will be released with version 24.5.

1 Like
6

The issues you have found earlier (filed as CELLSNET-55454) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

7

@John.He
I have tried the fix you provided and it works. However, I still have a question regarding this topic actually.

I am attaching another sample project that edits the hyperlinks in the SmartArt. The SmartArt in the input file (test.xlsx) contains 2 links (original_link1, original_link2) that are being modified by the app. Opening the output file (output.xlsx) in MS Office only the edited content can be seen, but searching in the extracted content of the output file, original_link2 can still be observed in some files (e.g: in xl/diagrams/_rels/data1.xml.rels, xl/diagrams/_rels/drawing1.xml.rels) which I would not expect.

I am using Aspose.Cells 24.6.0.

Could you please help with this?

excel_smartart2.zip (43.8 KB)

8

@tamas.boldizsar
By using sample file and code for testing on the latest version v24.6, we can reproduce the issue. Discovered that the result file contains extra data after resetting the hyperlink address. Please refer to the attachment. result.zip (212.7 KB)

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): CELLSNET-56009

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.

1 Like
9

@John.He
Thank you for your effort!

10

@tamas.boldizsar,

You are welcome. We will keep you posted with updates once they are available.

1 Like
11

@tamas.boldizsar

We are pleased to inform you that your issue (“CELLSNET-56009”) has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.7) . You will be notified when the next version is released.
Please check the attached result:
24.6.1.zip (22.5 KB)

1 Like
12

The issues you have found earlier (filed as CELLSNET-56009) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

13

@simon.zhao

I’ve checked the newer version of Aspose.Cells you mentioned, and the issue seems to be fixed. Thank you for your support!

14

@psimon
Thank you for your feedback. You are welcome. If you have any questions, please feel free to contact us at any time.