Posted 5 July 2018, 2:43 am EST
Hi,
I’m getting an unexpected cell display. I formatted the spreadsheet column for a numeric display of a positive number using:
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,
Luis