Hi,

Is there any way to concatenate 2 smart markers in a single cell?
e.g. something like "&=Person.Name & ' ' & &=Person.Gender".

Thanks
Manu

---

This message was posted using Page2Forum from Smart Markers - Aspose.Cells for .NET and Java

Hi,

Welll, I think you may utilize dynamic formula feature of smart markers for your need. Your smart markers will be placed in a way, see the following:

          A                                      B                                          C                                          

&=Person.Name             &=Person.Gender               &=&=A{r} & " " & B{r}    

 

Alternatively, you may put dynamic formula i.e..,  &=&=Concatenate(A{r}, B{r}) in C column for your need.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Thanks Amjad...

I am already using dynamic formula feature for achieving my purpose. The only thing I need to do additionally is to delete the data in columns 'A' and 'B' after concatenating them into column 'C'. (For my purpose, I can't display the contents in columns 'A' and 'B' separately.)

Is there any way so that I don't need to delete the contents. i.e. the data is placed by smart markers in a concatenated form itself.


Thanks in advance
Manu

Hi Manu,

I think you may hide the source columns for the dynamic formula markers.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us