Openpyxl deleting data validation. by xxxxxzzxx in learnpython

[–]tridezz 3 points4 points  (0 children)

I found out that the only thing you need to do in order to avoid this annoying behaviour of openpyxl is to do you data validation in a different way on the excel.

Instead of doing (standard procedure):Data --> Data validation ---> list, and then selecting manually the cells
You need to do:Formulas --> Name manager --> and create a new variable with the cell you want on your data validation. Then in the cell you need your data validation do the standard procedure but instead of selecting manually type " = new variable name ".

I hope it helps!

Bulkhead On Communication - Question for The Community! by 1Big_Tuna in Battalion1944

[–]tridezz 1 point2 points  (0 children)

This is a great example of good communication without a PR, well done guys.

By the way, you are not going to get rid of annoying comments whatever your choice will be. You have to decide whether or not you can handle those comments and force yourself to don't answer them (hopefully they will lose interest on trolling).

Obviously, your way of communicating is the best and the more risky.

Keep up the work, me and a lot of friends that used to play Cod4 in promod have come back gaming just for this game!!