Change Cell Appearance

3 posts, 0 answers
  1. John
    John avatar
    8 posts
    Member since:
    Feb 2012

    Posted 09 Mar 2015 Link to this post

    I am using the spreadsheet to gather input from my users. We do the validation, however, to really make this program pop it would be great if there is a way to change the cell border color to a red boarder with a gradient starting from the cell boundary and moving inward so looking at the program it would be easy to find which values are out of range.  I have tried using the brush and gradient but I can only do it for the whole page.  I would settle for just changing the background of an out of range cell to red.  Are there any samples you can point me to?

    Thanks, great control by the way.

  2. Nikolay Demirev
    Nikolay Demirev avatar
    136 posts

    Posted 11 Mar 2015 Link to this post

    Hello John,

    If you are using data validation for validating the user input you could use Circle Invalid Data which is part of the Data Validation feature. Here you can read more about how to Circle Invalid Data.

    If you want to set background on a cell you could set the Fill of this cell to red. Please note that if you set the fill of the cell this change will be included in your document on export. Here you can find how to set Fill to a cell.

    If you do not want to use Circle Invalid Data and you do not want to change the document but simply show a colored rectangle behind the cell values, you could implement custom UI layer. This forum post shows how to implement a custom UI layer.

    Nikolay Demirev

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

  3. John
    John avatar
    8 posts
    Member since:
    Feb 2012

    Posted 11 Mar 2015 in reply to Nikolay Demirev Link to this post

    Thank you for the answers, I will read the posts.  I do not have the current version of Spreadsheet, so I am doing the validation with a work around I found on this sight, so these two posts should help.

Back to Top