Watermark in Aspose Cell XLSX

Aspose.Cells Product Family
1

Hi,

I am using Aspose Cell licence version. In my application, I need the watermark as "Confidential" in the exported excel file 2007 format.

Does the XLSX version supports Watermark ?

Early response will be highly appreciated.

Regards,

Saroj Nanda

2

Hi,

I am afraid not, the feature is currently available for XLS format. We will support it for XLSX format soon.

If you want to set watermark for XLS format, see the following sample code for your reference:

Sample code:


// Add Watermark
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];

Aspose.Cells.Drawing.Shape wordart = sheet.Shapes.AddTextEffect(MsoPresetTextEffect.TextEffect1,
“CONFIDENTIAL”, “Arial Black”,50,false,true
,18, 8, 1, 1, 130, 800);

MsoFillFormat wordArtFormat = wordart.FillFormat;
wordArtFormat.ForeColor = System.Drawing.Color.Black;
wordArtFormat.Transparency = 0.9;
MsoLineFormat lineFormat = wordart.LineFormat;
lineFormat.IsVisible = false;

workbook.Save(“e:\test2\TestWatermark.xls”);

As a workaround, I think alternatively you may try to create a background
picture(similar to formatted “CONFIDENTIAL” word) and set the background
picture to your background sheet.
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/set-background-picture-for-a-worksheet.html

And, if you want it for chart’s plot area background watermark, you may try to set background picture for the chart’s plot area:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/set-picture-as-background-fill-in-the-chart.html


We have already logged the feature for the XLSX format for ShapeCollection.AddTextEffect() method. The id of the issue is logged as: CELLSNET-22897.

Thank you.

3

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan