Free Support Forum - aspose.com

Embedded file ... not really embedded

#1

Hello, do you know the possible reason why an aspose embedded pdf file in an excel sheet is considered a simple picture (when I click on it no action), and the same embedded pdf file is considered a real embedded file in another sheet (when I click on it, pdf is opened). Aspose code java to embed the 2 files is the same, and embedded pdf files are the same. No aspose error in java code.

Embedded file does not work only for a specific sheet and work for the others in the excel file. Perhaps something in the sheet features that prevents aspose from embed files ?

The problem is the same as the type of file to embed.
We use aspose-cells-17.1.0 (we can’t change version) in java env.

Best regards

Best regards

#2

@joelle.auffret,

Thanks for the details.

Since you are using some older version of the product, I am afraid, we cannot evaluate your issue using older version. Neither we can include fix in older versions, the fixes are based on latest APIs set only. It might be an issue in the version you are using and we got to look into your template file. So, you should upgrade to latest version (e.g Aspose.Cells for .NET v19.1.x) of the product. Or at least you may try the scenario/ case in a separate test project if it works with v19.1.x or not. If you still find any issue with latest version of the product, kindly do create a sample console Java program (runnable) and post us with the template file and output file, we will check it soon.

#3

I have reproduced it in a console java program.

In this program, I embed a simple pdf (the same ) in F11 and F14 sheets and generate a result file => ONE_RESULT.xlsx
In F11 it is really an embedded file (I can click and open the pdf)

In F14, it is only a picture => bug.

And my tests show that if I change the previous sheets (delete picture, add drawing), the result can change…

Best regards

#4

@joelle.auffret,

As we asked your earlier, did you try using our latest version/fix(e.g Aspose.Cells for .NET v19.1.x) in a separate test project if it works or not . If you still find any issue with latest version/fix, kindly do provide us sample console Java program (runnable) and post us the template file (if any) and output file, we will check it soon.

We appreciate your help in this regard.

#5

Hello,
Yes, I try and reproduce it with the New version of Aspose.Cells for java.
But I am not able to send you the .zip example : upload does not work.
I have sent it to you directly by e-mail reply (2/07/2019).

Regards

#6

@joelle.auffret,

I did not receive your zipped example yet. We recommend you to kindly upload to some file sharing service (e.g dropbox, Google drive, etc.) and share the Download link here, we will check it soon.

#7

Please find the corresponding zip example.
Regards

#8

Here a google drive link to access to the example

https://drive.google.com/file/d/1hHybRZr8tfTIzfjbk-g5HWbOjUa7oUYT/view

#9

@joelle.auffret,

We were able to observe the issue 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-42833 - Issue while embedding same pdf file in multiple sheets in a workbook
#10

@joelle.auffret,

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

#11

Hello,
Our problem is that we can not change Aspose version (our client has a license for an old version of Aspose), and we would like to know if there is a workaround in ‘fileInput’ content (use in wb = new Workbook (fileInput):wink: to avoid the problem (eg no drawing in the tabs …)

If we know the reason why there is this bug, we can inform our client to change their files ‘fileInput’ content.

Best regards

#12

@joelle.auffret,

I am afraid there is not any workaround available for this issue. It is fixed in latest version so please upgrade and then let us know your feedback.

#13

@joelle.auffret,

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

aspose-cells-19.2.1.zip (6.4 MB)

Your issue should be fixed in it.

Let us know your feedback.

#14

Hello, I have tried the new version. The bug is not the same but it is always present.

In the example, I insert embedded files in F10, F11 and F14 sheets of excel template.
When you execute the java code using Aspose 17.1.0, embedded files in F10 and F11 are correct, but in F14 it is a picture.
When you execute the java code using the new Aspose 19.2.1, embedded files in F11 and F14 are correct, but in F10 it is a picture.

Here the link to access to zip example:
https://drive.google.com/file/d/1dmg-LyH8EXYk0kf0f4w1_MikiRbcvakj/view?usp=drivesdk

Best regards.

#15

@joelle.auffret,

We have observed issue with this template file and logged this information with the ticket which is reopened for further investigation. We will write back here once any update is ready to share.

We are sorry for the inconvenience caused to you in this regard.

#16

@joelle.auffret,

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

#17

@joelle.auffret,

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

aspose-cells-19.2.7.zip (6.4 MB)

Your issues should be fixed in it.

Let us know your feedback.

#18

It works for the java code example I gave you, but in other cases it does not work.

I have already the same problem when I try to insert one embedded file in each tab.
With this new version 19.2.7, embedded files are considered as pictures in F12 and F15 tabs.

#19

BugAsposeTest2.zip (1.3 KB)

#20

@joelle.auffret,
I have tried the latest version but no issue is observed. All the embedded files on each sheet are opened fine without any issue. I am sharing all the sample data and code for your reference again. Please ensure that you are using latest version which is shared with you and also I have made following change in the code according to the available sample XLSX file.

...
for (int k=0; k<=14;k++) { //You mentioned k<=18
...

Please give it a try and provide the feedback.
SampleData.zip (1.5 MB)