We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Smart Markers issue in java

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

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.