looks like a bug to me...

consider using report builder instead? try it in report builder as-is and if that doesn't work consider changing it into a list and place it report builder instead of a spreadsheet

Hi Ian,

Thank you for your speedy reply. I study your suggestion, but using a list to replace my spreadsheet is a bit complicated. The reason I am using a spreadsheet is because I am using a Bean shell Form Binder to create the contents of this table. And in the Bean shell Form Binder I have several logic in order to handle the discount value and tax value. I am not sure if using a list can handle this logic.

Do you think using list also can apply the same logic? By the way, I am using Joget DX Enterprise 7 (V7.0.44), there are no bean shell option for list, if I am not mistaken.
Seek your advised accordingly.
Thank you.

Have you tried report builder and convert as-is?

There is beanshell formatter on dx7 Bean Shell Formatter - Knowledge Base for DX 7 - Joget | COMMUNITY