Smart Markers issue in java

Aspose.Cells Product Family
1

Hi ,

I am using Aspose cells for java and implementing SmartMarkers. I want to create a smart marker which fills information something like this.

"Report Generated at &=$date at &=$timeStamp"

this should translate to

"Report Generated at 07/15/2013 at 12:44:29 PM"

basically I want to add information about date and timestamp.

However, looks like Aspose cells for java is not able to recognize this a Smart Marker. Please let me know if this can be done in any other way.

Regards,

Abhinav

2

Hi,


Well, you have to use dynamic formula feature of Smart Markers accordingly for your needs, see an example below, you need to set your markers in the following way.

Excel Template:
E.g
A B C

&=DataSource.Date &=DataSource.TimeStamp &=&=Concatenate("Report Generated at ", A{r}, " at ", B{r})


You may hide the A and B column if you want.

Thank you.