Unexpected display

Posted by: Luis.Alvarez on 5 July 2018, 2:43 am EST

  • Posted 5 July 2018, 2:43 am EST


    I'm getting an unexpected cell display. I formatted the spreadsheet column for a numeric display of a positive number using:
    <instance name>Columns(1).Formatter = New GrapeCity.Windows.SpreadSheet.Data.GeneralFormatter(GrapeCity.Windows.SpreadSheet.Data.FormatMode.CustomMode, "[>0]#;[<0]0.#;0;")

    When create a simple project with only the above line I see that when I enter a character the spreadsheet does not display the character and when I enter a positive number the spreadsheet displays it. Simple.

    When I incorporate the formatter line into my project I see that when I enter a character and move to the next cell nothing is displayed. However when I re-select the cell the character that I have previously entered appears and then disappears when I select another cell . When I enter a negative number the cell displays a positive number when I move to another cell but when I re-select the cell the negative number reappears. When I programmatically read the cell contents using GetText() I get an empty string.

    The simple project that I initially created does not display the character or negative number when the cell is re-selected. What could cause this?

    Thank you,
  • Marked as Answer

    Replied 5 July 2018, 5:59 pm EST

    Hi Luis,

    I am able to replicate this issue at my end. I have submitted a bug to the development team for further investigation. The tracking id for this issue is 260416. I will let you know as soon as I get an update on this.

    Deepak Sharma
Need extra support?

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

Learn More

Forum Channels