Aspose.Cells Embed Smart Marker

Hey,

How can I embed Smart Marker in the middle of the text in a single cell? I currently have the following marker: &=invoiceaddress.einvoiceAddress and using it as the only text in cell works fine. However, when I add for example the text OVT: before it, the tag stops working. Is there a way around it and could you possibly provide example?

Thank you in advance

@Suikero,

You can add/embed constant or string value before or after the marker. But you may workaround to merge data (before or after) by using dynamic formula marker. For example, in A1 cell, you may insert markers like “&=invoiceaddress.einvoiceAddress”. Now in B1 cell, you may insert dynamic marker like “&=&=Concatenate("OVT:", A{r})”. Alternatively (if you do not want to use dynamic smart markers (formula)), you may merge data using your own code via some Excel formula after the markers are processed and filled with data into the cells.