Reopened Spreadsheet - Overlaying Text when editing

5 posts, 0 answers
  1. Jannk
    Jannk avatar
    23 posts
    Member since:
    Jul 2014

    Posted 11 Feb 2015 Link to this post

    When I try to edit a cell after I saved it in and opened it from a database my modified and my old values are overlaying each other. (See the attached screenshot)

    Anyone has similar problems?
  2. Jannk
    Jannk avatar
    23 posts
    Member since:
    Jul 2014

    Posted 11 Feb 2015 in reply to Jannk Link to this post

    I have figured out, its not working due to the SetFill. Guess its a bug, isn`t it?

    worksheet.Cells[rowIndex, i].SetFill(PatternFill.CreateSolidFill(schattierungColor));

    Any workaround?
  3. DevCraft banner
  4. Svetoslav
    Admin
    Svetoslav avatar
    55 posts

    Posted 13 Feb 2015 Link to this post

    Hello Jannk,

    Thank you for contacting us.

    Actually this is an expected behavior and it is related to the alpha compositing transparency of the color that is used as a background fill. There are several layers in Spreadsheet which are responsible for visualizing the cells' values (CellValuesLayer) and for editing the value in the cell (CellInputLayer ).When the cell is in edit mode, the CellInputLayer is positioned upon the CellValuesLayer. Since the CellInputLayer is getting the same background as the CellVauesLayer, if the background color is with high transparency, this can cause the old value in the cell to be visible as well.

    To avoid this I would recommend you use a color with low level of transparency.

    schattierungColor = Color.FromArgb(255, schattierungColor.R, schattierungColor.G, schattierungColor.B);
    I hope this information is helpful. Let us know if you need any further assistance.

    Regards,
    Svetoslav
    Telerik
     

    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.

     
  5. Jannk
    Jannk avatar
    23 posts
    Member since:
    Jul 2014

    Posted 20 Feb 2015 in reply to Svetoslav Link to this post

    Good morning Svetoslav,

    thank you for your explanation, I converted my RGBA color to a RGB color and now it's working fine.

    It's bit strange anyway, you shouldnt let users make their backgrounds transparent or hide the normal text, when in edit mode.

    Doesn't matter, my problem is solved, thanks for the help!
  6. Svetoslav
    Admin
    Svetoslav avatar
    55 posts

    Posted 23 Feb 2015 Link to this post

    Hello Jannk,

    I am glad that the provided suggestion helped. 

    We appreciate your feedback, but actually the users are not allowed to use transparent colors through the UI of RadSpreadsheet. It is only possible to be done form code behind as another possibility for developers to customize the behavior of RadSpreadsheet.

    If you have further questions or comments feel free to contact us again.

    Regards,
    Svetoslav
    Telerik
     

    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.

     
Back to Top
DevCraft banner