Posted 8 September 2017, 1:47 pm EST
In the spread designer, I set "upper" for charactercasing property. It looked changed so I applied it and exited. When I run my application, it is getting lower case. When I go back to the spread designer, the property value was "normal" instead of "Upper". I didn't understand why it was still "Normal" even though I changed it to "upper" and applied it. so I tried do it thru coding and I couldn't make it work. Check the below code and please give me a suggestion.
Dim tcell As New FarPoint.Win.Spread.CellType.TextCellType()
tcell.CharacterCasing = CharacterCasing.Upper
Me.FpSpread1.ActiveSheet.Columns(0).CellType = tcell
1. When user types a letter on cells whether "Caps lock" is turned on his keyboard or not, the letter becomes "upper case"
2. Should I assgin it for each text cell? Can I do it at once?