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

Free Support Forum - aspose.com

Smart Markers & Header/Footer

Hello,

I’m experimenting header and footer with smart markers and I have a few questions:
- Is it possible to set custom variables in header/footer section ?
- When I try to set a different footer for the first page (by ticking the checkbox “Different first page”), the content is not rendered.


Another question about smart markers, is it possible to mix variables and constants in the same cell ?

Regards,

Mathieu

Hi,


We recommend you to kindly use and try our latest version/fix:
Aspose.Cells for .NET v7.1.1.2

Also, kindly go through the topic for your reference on what the smart markers can do:
http://docs.aspose.com/display/cellsnet/Smart+Markers

For queries:

1) "- Is it possible to set custom variables in header/footer section ?"
I think you may try to do it.

2) "When I try to set a different footer for the first page (by ticking the checkbox "Different first page"), the content is not rendered. "
It should work fine. If you find any issue, kindly create a sample code and attach the files (input + output) here, we will check it soon.

3) "Another question about smart markers, is it possible to mix variables and constants in the same cell ?".

Yes, you may try to use Smart Markers' dynamic formulas feature for it. e.g
smart marker dynamic formula (mixed) in a cell can be: &=&=TEXT(H{r},"0")&"Y "&TEXT(I{r},"0")&"M". Another example is: &=&=IF(K{r}=0,-1,(L{r}-F{r})/F{r})


Thank you.