Input only Upper Case on cells

Posted by: cvetx on 8 September 2017, 1:47 pm EST

  • 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

    (My Goal)

    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?



  • Replied 8 September 2017, 1:47 pm EST


    Regarding the said issue, I created a sample project and sending it for your review. In the sample project I have set the Character casing of Column1, Column2 and Coulmn3 to be of Normal, Upper and Lower type using the SpreadDesigner. I have also used the code (provided by you) to set the Character casing to be of Upper case in code(which is commented out, but working fine).

    Upon running the attached project, you may try entering text values in 3 columns in different cases and see it is working fine. Please note that all the Columns are set up of Text cell type using SpreadDesigner.Following steps were performed to set the cell type and character case

    SpreadDesigner-->Select a Column-->Set the cell type of the column to Text type--> Provide the character casing information for the column-->Apply-->Ok--Apply & Exit Spread Designer.

    Hope this helps.Thanks,


  • Replied 8 September 2017, 1:47 pm EST

    Thanks for the file and it worked out well.

    I tried it after I bound DB and same problem happend to your sample too. Is it becuase of Data bound? The value was changed back to "Normal" from "Upper" when I opened the spraed design again  even though I saved it and exited.

    Let me know.


  • Replied 8 September 2017, 1:47 pm EST

    There is a <span id="pagetitle">DataAutoCellTypes Property (or set at design time), that you probably need to set to false or set your celltype properties after you bind the control.
  • Replied 8 September 2017, 1:47 pm EST

    Gina and sureshD

     Thnaks. It works well.

     I just wonder.........

    What would you recommend to know all the functions of fpspread? I don' think I can find this information from "Resource Portal" and this forum. I can't find a book from too.

    Any suggestion?


  • Replied 8 September 2017, 1:47 pm EST


    I tested the described behavior at my side with version 4.0.2009.2005 of the control, and it appears to be working fine. I have tested setting the CharacterCasing property using both the SPreadDesigner and code and it is working as expected for me.Please verify that you are using the latest maintenance release of the control.



  • Replied 8 September 2017, 1:47 pm EST

    I do have a same version of Fpspared on my VS2005 as a refeenece.

     This is the step that I follwed.

    Spread Designer -->  Click "departent_id" Columhead --> "Selected Item" --> celltype --> Charactercasing --> "Normal" to "Upper" --> Apply

    That is changed to "Upper and close out the Spread Designer  and open it again. Then the property is "Normal" again. That happen to all "CellType" Properties. But I can change other properties without problem.

     Do you have any idea for this?

  • Replied 8 September 2017, 1:47 pm EST


    We do not have any books, unfortunately, to help you learn the Spread control. However, we do have a trainer that we recomend to people who are interested in Spread for Windows Forms or Spread for ASP.NET training. You can find information on this here.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels