at first I would like to thank you for your big help and willingness. I have many questions and you helped me a lot.
For today I have one more question about unexpected functionality (from my point of view) of changing cell among cell types. Maybe I think as Excel user too.
Please consider this demo at
There are many buttons which can be used for changing cell types for cell at position 1, 1 via
If I use Set Percentage button and then Set Currency and vice versa, it works as I expected, means that number is show in percentage respectively in currency format.
Then I want reset that cell type (formatted as percentage or currency) therefore I used
text cell type but it doesn’t work in my demo.
Also if I want change that cell to date or numeric, it doesn’t work as well.
If I use Set date cell type at first and then to any other cell types, it doesn’t change anything.
If I use Set text cell type at first and then to any other cell types, it doesn’t change anything.
If I use Set numeric cell type at first and then to Set Percentage or Set Currency it works but other cell types don’t change anything.