Getting cell value type of an existing spreadsheet

juhohe

I have created an Excel spreadsheet using Microsoft Excel 2013. The spreadsheet I created is empty but it has some formatting, e.g. I selected all cells and set text alignment to right. I also selected some of columns and set their type to Number, short date, or general. Is it possible to get these formattings and types from an empty spreadsheet? I already tried this, but it seems that RadHorizontalAlignment is always General, not Right as I would like it to be.

Anna

The scenario you are describing is absolutely valid and you should be able to get both the alignment and the format. Unfortunately I still haven't been able to reproduce the issue you are facing. What I did is I created an Excel file with Excel 2013, set right alignment to the the entire first column and number format to the second column. After importing the file in RadSpreadsheet, I was able to get correct values for both properties using the following code:

Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items

Anna

Thank you for mentioning the version of the library, this really helped. I tested the code with the older version and indeed the behavior with it is just as you said. This is fixed with the latest official release, so downloading it should solve the problem.

I am not sure what has caused the error you are getting. The Part_UnhideThumb is an element which should be found in the control template. Can you please try to update again and let me know if you encounter the same error again?

Regards,
Anna
Telerik

Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.