Spread com buggy mask property

Spread com buggy mask property

Posted by: abrahampetit on 27 January 2021, 4:39 pm EST

• 

  abrahampetit

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 January 2021, 4:39 pm EST

  Hi,

  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

• 

  Pragati.Kaushik

  

  • Post Options:
  • Link
    Copy

  Posted 2 February 2021, 7:13 am EST

  Hi,

  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.

  Thanks,
  
  Pragati
  
  Sample Spread.zip

• 

  abrahampetit

  • Post Options:
  • Link
    Copy

  Posted 4 February 2021, 4:10 pm EST

  Hi

  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

• 

  Pragati.Kaushik

  

  • Post Options:
  • Link
    Copy

  Posted 5 February 2021, 7:38 am EST

  Hi,

  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

  Thanks.