Smart marker concatenated with string

Aspose.Cells Product Family
1
Given that:

&=Item.Title

returns a string, is it possible to construct a SmartMarker that concatenates a string and the content of a smart marker?

Something like:
&="Some text " & Item.Title
or
"Some text &=Item.Title"
or
Some text &=Item.Title

Right now I have a hidden cell with the smart marker, and the string and the field is concatenated in a visible cell:
="Some text " & A2
2

Hi,

We you may use dynamic formula in smart markers. You may place a marker i.e…, Item.Title in A1 cell and hide the column. Now you may place a dynamic smart marker’s formula in the B1 cell e.g:

&=&=Concatenate(A{r}, "Some text ")


Thank you.

3

Yes, if you read my original question, that was exactly the solution we use right now.

My question was if it was possible to do without the hidden row/column.

4

Hi,

Well, I am afraid, the feature is not supported i.e., directly add some text with smart markers.


You need to do what I have suggested or your are doing fine.

Thank you.

5

Is this still an unsupported feature? We’re evaluating Cells.Net, but need to leave the worksheet in an unprotected state while still combining string literals with values resolved from smart markers.

6

@michaelrichards,

The feature is not available and you may adopt the approach which is suggested above.