Tony Q.

What do you exactly mean 'the cell address in shape'? Can you upload the Excel file?

I'm debugging your case and I figure out the Run list in your word file for one replacement.  As you can see that the second $ and third $...

To work around this, I suggest you change the placeholder texts as below ``` $FINALQUALIFYINGWORK_QUESTION_1_ASKING_SHORT$: #FINALQUALIFYINGWORK_QUESTION_1_QUESTION# $FINALQUALIFYINGWORK_QUESTION_2_ASKING_SHORT$: #FINALQUALIFYINGWORK_QUESTION_2_QUESTION# ``` I've tested on my box and it works perfectly.

Do you still wanna use NPOI or you have switched to another library?

https://poi.apache.org/components/spreadsheet/user-defined-functions.html

Looks you fully understand what's going on. Can you provide a PR?

Do you have openxml document supporting your change?

According to [this document](https://bettersolutions.com/excel/conditional-formatting/index.htm), it's not no limit but 64 as maximum.

Can you provide your original Excel sheets?

Which version of NPOI are you using?