Spread com buggy mask property

Posted by: abrahampetit on 27 January 2021, 7:39 am EST

    • Post Options:
    • Link

    Posted 27 January 2021, 7:39 am EST


    Im using this property in Spread

    .TypePicMask = “99.999.999/9999-99”

    If you enter a number, spread will remove the character “-” and the mask will not work.

    For some reason, this situation happens if the mask has the character “/”

    Seems to me this is a BUG, I don’t see any logic,. or there is any?

    Thank you

  • Posted 1 February 2021, 10:13 pm EST


    Which version of Spread COM are you using at the moment?

    I tried replicating the issue at my end, however it does not. The character - is not removed on entering a number in the cell. Please find the file demonstrating the same attached. You can refer the cell A1 with the TypePicMask property set.

    You are requested to modify the file and share back so that I can reproduce the problem at my end and investigate the issue further.



    Sample Spread.zip

  • Posted 4 February 2021, 7:10 am EST


    Im using the latest version you posted. of spread 8.0.29

    If you try this VB6 code

    fpSpread1.Col = 1

    fpSpread1.Row = 1

    fpSpread1.CellType = CellTypePic

    fpSpread1.TypePicMask = “99.999.999/9999-99”

    And then try to enter a code.

    You will notice that the character “/” gets hidden… Why is it hidden? Thats my question

  • Posted 4 February 2021, 10:38 pm EST


    Thank you for sharing the code.

    “/” is actually used to denote that the following character is a placeholder. When the user types data into the cell, placeholder character is automatically skipped. No entry is permitted in this position, nor is the user able to delete them.

    Please refer the following documentation link for the details on the same: https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#prop932.html


Need extra support?

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

Learn More

Forum Channels