Parametrized excel formulas in conditional formatting rule

[anastasiya-belova]

Hello!

I want to use "Parametrized excel formulas" (as in example http://jxls.sourceforge.net/samples/param_formulas.html) inside the conditional formatting rule (see screenshots 1 and 2).

But after saving rule my formula changes (see screenshot 3). And, of course, after processing this template by jxls, variable "bonus" not substituted in formula.

Is it possible to use variables from java code inside formula on conditional formatting?

[SoltauFintel]

hi

I don't know if JXLS supports JEXL formulas at that place. I guess not.

• Is ${bonus} a fix value for the whole Excel file?
• Why do you write [...] ?? $[ ... ] instead??
• Workaround: write ${bonus} e.g. into cell AA1 and use AA1 in the formula.

You could debug PoiSheetData.java:86 (updateConditionalFormatting). If the formula appears there we could use the JEXL evaluator at that place. For adding a new feature we'll need a PR. See https://github.com/jxlsteam/jxls/blob/master/CONTRIBUTING.md

[anastasiya-belova]

Thank you for answering my question.
Yes, ${bonus} is a fixed value for this Excel file. And yes, I made a typo - [...] instead $[] 😕
Suggested workaround works correctly, it's great!
I'll try to add new future not now, but when I have free time.