Specific .ODS file to PDF conversion gives evaluation copy watermark

Hi Aspose Team,

While doing our normal release testing we discovered a strange thing.
If we try to convert this specific .ods file, Aspose watermarks it with a evalutation stamp.
We’re using Apose.Cells 24.9.0, but we have reproduced this problem in earlier versions also.

Code:
Aspose.Cells.Workbook excelDoc = new Aspose.Cells.Workbook(filename);

excelDoc.Save(dstFilename, new Aspose.Cells.PdfSaveOptions()
{
OnePagePerSheet = onePagePerSheet,
AllColumnsInOnePagePerSheet = true,
ExportDocumentStructure = true
});

20240222_1.zip (38.3 KB)

But this is not a problem with other .ods files or any normal Excel files.
Can you please check on your side ?

@andersalvsaker,

Thanks for the sample ODS file.

It seems you are not using or setting a valid license of Aspose.Cells in code to convert your ODS file to PDF file format. Please note, if you don’t use and set a valid license in code, an evaluation watermark will always be pasted/stamped into the output documents. See the document on licensing for your reference. I tested your scenario/case using a valid license (I set it in code when the application starts) with your sample code and the output PDF file is fine tuned (no watermark is pasted into the output PDF). Please find attached the output PDF file for your reference.
20240222_1.pdf (253.6 KB)

Let us know if you still have any issue or confusion.

Yeah got you.
And we done all this and the license key is set in app as you say.
But isn’t it strange that our license file works with all other conversions, even other .ods files but this specific file results in a watermarked file?

@andersalvsaker,

It is also possible that your licensing code was not processed at all in your application. You may debug and set breakpoints in your app to check if the licensing code is processed or not. Additionally, please create another test (console) application using your sample code (ensuring to add the license code first) and your sample ODS file (you provided here) using Aspose.Cells for .NET v24.9 if you still find the issue in the output PDF. If true, kindly provide the output PDF file, and we will check your issue further.

We have already debugged the code and can see that it is registered. Again, all other cells files(or words) works perfectly. See the attached PDF for output.
2024022102v3.pdf (865.3 KB)

@andersalvsaker

I checked your PDF file properties in Adobe Reader and it indicated it was saved/updated by Sikri AS, PixEdit server, not generated by Aspose.Cells for .NET v24.9. See the screenshot attached.
sc_shot1.png (97.9 KB)

It seems you have either changed the PDF Producer field or edited the output PDF by Aspose.Cells for .NET v24.9 again by other tool/app. Moreover, I found in your PDF file, page 3 has watermark “Evaluation Only. Created with Aspose.Cells for .NET…”. I guess you are talking about this watermark, is not it? Your source Excel file has this extra watermark sheet, so when you will render the file to PDF by Aspose.Cells for .NET v24.9, surely, this watermark sheet would also be rendered in the output PDF as well. Please check your source Excel file and remove the watermark sheet to re-save the file or use the correct Excel file (which does not have the evaluation watermark sheet) before rendering the spreadsheet to PDF by Aspose.Cells for .NET v24.9. It seems like previously you did not use a valid license to be set when you generated the Excel file which would surely have evaluation watermark sheet in it.

Please do the needful as suggested/discussed above. Let us know if you still find the issue or have other queries.

Can you clarify where in the attached excel file you see the watermark? I can not see this. The file shows PixEdit server because that is our software. We use Aspose.Cells 24.9 for the conversion. Yes, the page 3 watermark is the issue.

@andersalvsaker,

I also don’t see the evaluation watermark in your provided ODS file. It seems you are using some different Excel file (which surely has evaluation watermark sheet) on your end. In the output PDF, I only see page 3 which is evaluation watermark sheet from source Excel file. I will again paste my previous statements.

Your source Excel file has this extra watermark sheet, so when you will render the file to PDF by Aspose.Cells for .NET v24.9, surely, this watermark sheet would also be rendered in the output PDF as well. Please check your source Excel file and remove the watermark sheet to re-save the file or use the correct ODS file (which does not have the evaluation watermark sheet) before rendering the spreadsheet to PDF by Aspose.Cells for .NET v24.9. It seems like previously you did not use a valid license to be set when you generated the Excel file which would surely have evaluation watermark sheet added to the output ODS file.

I am sorry, you are absolutely right. I found the watermark using another editor(not excel). Thank you for the help.

@andersalvsaker,

It’s great that your problem has been resolved. Please don’t hesitate to reach out to us if you have any additional questions or feedback.

1 Like