Get the signature line information from the MS Word and Excel document

Aspose.Total Product Family
1

Hi Aspose Support,


We want to get the signature line information from the MS word and excel document. Signature line information e.g. X,Y,Height,Width,Page#/sheet,SetupID etc.

We need all the information of a signature line see attached image for more details.

Aspose support team said this feature is not currently supported. Can you please log it into your to do list?

Best Regards,




2

Hi Wahaj,

This feature is not supported in Aspose.Cells and a request to support this feature has been logged into our issue tracking system as CELLSNET-43260. We will keep you updated on this issue in this thread.

You can use the following solution with Aspose.Words to get this information until signature line is supported.

Document doc = new Document("Document-With-Signature-Line");

<?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-com:office:office" />

NodeCollection shapes = doc.GetChildNodes(NodeType.Shape, true);

foreach (Aspose.Words.Drawing.Shape shape in shapes)

{

string text = shape.AlternativeText;

if (text.Contains("Microsoft Office Signature Line"))

{

shape.Range.ToDocument().Save("SignatureLine.xml");

}

}

From the XML (which contains the shape with signature line only), you can easily extract signature line ID.

Best Regards,

3

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.3.1.3. We have added Picture.SignatureLine property for your needs.

Please see the following code:

C#


Workbook workbook = new Workbook(@“C:\book1.xlsx”);

Console. WriteLine(workbook.Worksheets[0].Pictures[0].SignatureLine.Signer);

workbook.Worksheets[0].Pictures[1].SignatureLine.Signer = “bbbbb”;

int index = workbook.Worksheets[0].Pictures.Add(0, 0, Constants.sourcePath + “a.emf”);

Picture pic = workbook.Worksheets[0].Pictures[index];

SignatureLine s = new SignatureLine();

s.Signer = “Simon”;

s.Title = “MMMMM”;

s.Email = “Simon.Zhao@aspose.com”;

pic.SignatureLine = s;

workbook.Save(@“c:\book2.xlsx”);


4

The issues you have found earlier (filed as CELLSNET-43260) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
5

Hi Aspose support,


The reported issue is fixed in Aspose Cell library only. Although we reported it for both MS Word and MS Excel document i.e. for both Aspose Word and Aspose Cell library.

Can you prioritize this fix also for Aspose Word? This is showstopper issue for us. Please share the deadline also for the deliverable.

Thanks.
6

Hi Wahaj,

You will be able to get signature line information once the issue mentioned at https://forum.aspose.com/t/14703 is fixed. In the meantime, you can continue using the workaround described in this post https://forum.aspose.com/t/14702

Best Regards,

7
ASA,

Please note that we are getting some pressure from our senior management to get an update on when this issue can be fixed. We appreciate that you guys are addressing the issues in the upcoming months but we need to have a rough understanding on when these can be release e.g. 1st or 2nd Quarter 2015 etc. This way we can schedule corresponding work item at our end as well. Without knowing the information from your side it will be difficult for us to judge when can these features be available in our products.

Note that we are paid customer of Aspose with active support so expecting a much better response than getting the message that this is being fixed in future.

Regards,
Israr Ahmed
8

Hi Israr,

Please follow http://www.aspose.com/community/forums/609761/create-a-signature-line-on-a-specific-location-in-both-ms-word-and-excel-document/showthread.aspx#609761 for further updates as both issues are interrelated.

Best Regards,