SoltauFintel

Ok, "8 lac rows" = "800,000 rows". Optimization makes sense for this, of course. I suggest you fork the repo and develop it there. Please don't submit the PR for...

I don't know. But I see that you have 5 extra rows and have a +5 in your formula!?

Because of Corona, we are currently spending significantly less time on JXLS. Therefore an answer or processing can take longer.

You could upload an example template and a piece of source code. But please with no Chinese chars.

Because of Corona, we are currently spending significantly less time on JXLS. Therefore an answer or processing can take longer.

a) I don't know Java higher than version 8. Which JDK are you using? (exact name+version) b) What is the difference between JUnit 4 and JUnit Vintage 5? c) Actually...

see PR #179 and #212

I don't know the Excel feature "data validation (drop down) control". Where can I find it in demo_template.xlsx? (what cell, or add screenshot)

How can I add such a combobox using Excel (365) ? How can I add such a combobox using Apache POI 4.1.0 ? How can I edit the combobox values...

ok Because of Corona, we are currently spending significantly less time on JXLS. Therefore an answer or processing can take longer.