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

Free Support Forum - aspose.com

Multiple smart makers in one cell

I’m trying to apply smart makers for excel. and in specific cases I need to insert static value (header) with some dynamic value (date)
for exmaple:
Cell A1: &=$translation_report_date: &=data.fromDate - &=data.toDate
exmaple output: Report dates: 01/01/2022 - 15/01/2022
there is any way to achieve that?

How to combine the cell to make in the multiple smart makers? is there any method available for it for help?

@zivdaniel, @robertrocks2342,

Adding multiple Smart Markers in single cell is not supported. But you may workaround to merge data as data source. For example, in A1 and B1 cells (for individual headers), you may insert markers like “&=t.header1” and “&=t.header2” respectively. Now in C1 cell (for combined headers), you may insert dynamic marker like “&=&=Concatenate(A{r}, “-”, B{r})”. Alternatively (if you do not want to use dynamic smart markers (formula)), you may merge in code accordingly.

Hope, this helps a bit.

yes, thank you very much, will go via the code :slight_smile:

@zivdaniel,

You are welcome.