Some shapes area unaligned when converted by aspose (078514)

Aspose.Cells Product Family
1

Some shapes area unaligned when converted by aspose

KWD.zip (1.0 MB)

KWD.pdf (831.8 KB)

2

@everaldo
We can reproduce the issue by testing it on the latest version v24.5 using the sample file and following code. It was found that some graphics had positional errors when converting sample file to PDF. Please refer to the attachment. out_net.zip (841.9 KB)

The sample code as follows:

Workbook wb = new Workbook(filePath + "KWD-PT-HR-ORG-001 - 18 - KWD-PT-HR-ORG-001-16 - Organograma Business Unit  KWD-08.09.2022 (1) (4).xlsx");
wb.Save(filePath + "out_net.pdf");

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-55785

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

@everaldo
We analyzed the Excel file and found that the “Group” and sub-shape data did not comply with the document rules published by Microsoft. This may be an unpublished processing rule from Microsoft. We haven’t collected enough information to resolve this issue, so this issue may not be resolved soon. We have some temporary solutions that we hope will help your work:

(1) Cancel the group and save again (recommended).
(2) Ungroup, regroup, and save again.
(3) Replace the problematic part with a picture

Details for steps (1) and (2):

  • 1 Open file
  • 2 Click “Page Layout” in the top options
  • 3 Click Selection Pane in the expanded options
    At this time, the names of all shapes in the workbook are listed in the list on the right. Selecting a name in the list automatically selects the corresponding shape/group in the workbook.
  • 4 For your question, you can check “Group 19120” in the list on the left
  • 5 Then find the selected range in the workbook
  • 6 Right-click->Group->Ungroup.
    Choose any of the following methods to do this.
    • Right-click within the selection. It is more difficult to operate when there are many nearby shapes.
    • Hover over the edge of the selected range and right-click when the black cross symbol appears.
    • The selected range usually has a hollow cross symbol, right click on it.
  • 7 After 6 operations, the selected “group” is no longer a whole, but all selected. Follow any of the methods 6-1/2/3 to get the right-click menu->Group->Group.
  • 8 Save document

Steps (1): use 1-6,8
Steps (2): use 1-8

We will work hard to collect relevant information and solve the problem as soon as possible, and will notify you of any progress as soon as possible.

4

Hello,

I tested the first solution and it worked to me.

thanks.

5

@everaldo,

Good to know that the suggested solution works well for your needs. Please feel free to write back to us if you have further queries or comments.