Announcements
No record found.
here in second column value is coming zero , how to set it using x++ so it shows only non zero values
cell = null;cell = cells.get_Item(currentRow, 11);cell.set_Value(-1*vendSettlement.SettleAmountMST); its the code for column cells
Hello,
SettleAmountMST field is of type real, the default value when empty is 0.
You cannot show null values altogether for an int or real type field. If value is null as Komi suggested, it will be 0 or 0.0 based on the type. If it is a string, then null means empty string can be shown.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 509 Super User 2026 Season 1
Giorgio Bonacorsi 375
Adis 268 Super User 2026 Season 1