Completed
Last Updated: 15 Dec 2023 13:12 by ADMIN
Release 2019.R1
Abhinav
Created on: 19 Nov 2018 14:07
Category: Spreadsheet
Type: Bug Report
3
Cell fore color is not picking up from excel sheet

1. Open "Sample Kendo UI SpreadSheet Example.html" attached html file in the chrome browser.

2. Click on open button in the Toolbar of the spreadsheet.

3. Select "Sample Excel with Font Colors.xlsx" attached excel file. This excel file contains headers with background color and Rows with ForeColors.

4. Now when the file is loaded, you will observe that B2, B3 and B5 should come up in Red fore color but the fore color of these cell in the kendo spread sheet is Black.

5. Similarly C2 to C5 should come in Green color but the fore color in the spreadsheet is black.

 

Query: Kindly let me know how can we achieve the fore color present in the excel sheet show show up in the Kendo UI Spreadsheet?

Attached Files:
3 comments
ADMIN
Ivan Danchev
Posted on: 30 Nov 2018 12:24
Hello Abhinav,

Thank you for providing these additional details.

Regards,
Ivan Danchev
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Abhinav
Posted on: 23 Nov 2018 14:30

Hello Ivan,

If i use the server import using following approaches then also the issue exists:

1. Using html Input control of type=file.

2. Or if we load the excel data by reading the excel file content using xmlhttprequest and use .fromFile() api to load.

 

*The cell fore color is working fine with kendo file upload control only.

Thanks

Abhinav

ADMIN
Ivan Danchev
Posted on: 22 Nov 2018 10:42
Hello Abhinav,

Thank you for reporting this issue. We logged it for fixing. I made this thread public on our Feedback Portal and through it you can track the bug's status.

Until a fix becomes available, we would suggest you to consider using server import instead of opening the file on the client with the Open button in the toolbar. We have a demo showing the Spreadsheet with server import: Server Import/Export.

I updated your Telerik points for reporting this issue.

Regards,
Ivan Danchev
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.