This is a migrated thread and some comments may be shown as answers.

Reopened Spreadsheet - Overlaying Text when editing

4 Answers 42 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Jannik
Top achievements
Rank 1
Jannik asked on 11 Feb 2015, 01:02 PM
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?

4 Answers, 1 is accepted

Sort by
0
Jannik
Top achievements
Rank 1
answered on 11 Feb 2015, 01:39 PM
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?
0
Svetoslav
Telerik team
answered on 13 Feb 2015, 04:38 PM
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.

 
0
Jannik
Top achievements
Rank 1
answered on 20 Feb 2015, 07:05 AM
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!
0
Svetoslav
Telerik team
answered on 23 Feb 2015, 11:11 AM
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.

 
Tags
Spreadsheet
Asked by
Jannik
Top achievements
Rank 1
Answers by
Jannik
Top achievements
Rank 1
Svetoslav
Telerik team
Share this question
or