Cells Java - Smart marker issue with HTML

Aspose.Cells Product Family
1

Hi Aspose Cells team,

In our Excel template, we have the following smart marker:

&=$SUBTITLE(html)

Howerver when we provide the following value:

    designer.setDataSource("SUBTITLE", "<b><font color='green'>This cell is a Smart > Marker</font><b>");

Then it renders as:

nok.jpg (2.8 KB)

Could you please have a look?

Note: issue observed in both Aspose Cells Java 18.7 and 18.12

Thanks,
Jean.

2

@jeankst,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-42855 - Html string with '>' character not rendered correctly using SmartMarker
3

@jeankst,

Please encode “>” as “&gt;” , see the updated line of code that works fine as I tested:
e.g
Sample code:

.........
esigner.setDataSource("Subtitle", new String[] { "<b><font color='green'>This cell is a Smart &gt; Marker</font><b>" });

Hope, this helps a bit.

4

Thanks Amjad.
Yes, we have tested this workaround OK.
But we will wait for an official response about this issue before going into the huge code rework this workaround is requiring.
Regards,
Jean.

5

@jeankst,

I am afraid, this issue won’t be fixed as you have to parse/encode the HTML tags by yourselves.