I am using smartmarkers and the WorkbookDesigner to add data into a excel workbook.
when i add a data element with a string property this can contain a leading apostrophe.
like a name in the netherlands could be like… --> 't hart
when this gets injected into excel the leading apostrophe will be used a an indicator that the value should be considered as string.
but in excel the apostrophe will not be visible… even formula’s will ignore this first character.
question can you indicate that the leading apostrophe should be used as a element of the value.
i can iterate over the data and add an additional apostrophe but i don’t want to go in that direction (performance)
is there a solution for this?