Negative value in Currency CellType

Posted by: silkkeng-fp on 8 September 2017, 2:15 pm EST

  • Posted 8 September 2017, 2:15 pm EST

    Hi,

    With currency cell type and if you have negative value, if it possible to put cell in edit mode, and go to the location just after negative sign "-", and press on backspace to delete the sign?

    Is there any settings in cell type can achieve this? 

    Thank you

     

    Kind Regards,

    Daivd

  • Replied 8 September 2017, 2:15 pm EST

    Hi,

    Sorry for the late reply.

    Please see attached sample project.

    To test :

    1. Run project

    2. enter -25.00 into text box

    3. press the button

    4. as you can see the negative sign got truncated.

     

    THanks


    2010/04/SpreadTest200410.rar
  • Replied 8 September 2017, 2:15 pm EST

    Hello,


    While setting the text in Currency CellType you can put a check on the textbox's text before pasting the values. Please have a look at the modified attached sample and let us know your further observations on the same.


    Hope this will help you. Thanks.


    2010/04/Modified-SpreadTest200410.zip
  • Replied 8 September 2017, 2:15 pm EST

    Hi,

    Instead of concate the value with negative sign, .SetValue fix the issue. Is this a problem with .SetText?

     

    Thanks

     

  • Replied 8 September 2017, 2:15 pm EST

    Hello David,


    We have reported this issue as bug #99915826 in Spread 5 with high priority.


    Thanks.

  • Replied 8 September 2017, 2:15 pm EST

    Hello,

    May I know what CurrencyNegativeFormat you have set?

     

    Thanks,

     

  • Replied 8 September 2017, 2:15 pm EST

    Hello David,


    The Spread Win v5.0.XX11.2008 maintenance release is now on our web site: http://www.clubfarpoint.com/FarPointSupportSite/Modules/Download/updates.aspx


    You an download it from this link:- ftp://ftp.fpoint.com/SpreadWinForms5/


    Thanks.

Need extra support?

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

Learn More

Forum Channels