Aspose.cells smartmarker formatting issue

Aspose.Cells Product Family
1

I'm evaluating Aspose.Cells for a project that I have, where one of the requirements is to produce an excel spreadsheet that contains signature blocks.

Example:

Acknolwedged by XYZ Corporation:

John Smith, Vice President

The text above would repeat x number of times.

I setup the smart markers like this:

&=Parties.AboveTheLine(skip:3,noadd)
&=Parties.BelowTheLine(skip:3) <== note this cell has a top border set for the signature line

However when the spreadsheet is opened every row has the cells top border set so I end up with:

Acknolwedged by XYZ Corporation:

John Smith, Vice President

Acknolwedged by WWW Corporation:

Randy Maxwell, President

Is there a way to get this to work?

2

Hi,

I have implemented/tested your scenario a bit. Well, the top border of “&=Parties.BelowTheLine(skip:3)” smart marker is actually the bottom border of “&=Parties.AboveTheLine(skip:3,noadd)” smart marker. So, you end up with this kind of result. Anyways, we need to investigate it if further enhancement (for formatted smart markers) is possible or not. I have logged it into our issue tracking system with an id: CELLSNET-22519 for investigation.

We will get back to you soon.

Thank you.