Closed as duplicate. Please, follow the item at https://feedback.telerik.com/Project/184/Feedback/Details/190249 .
The format string for dates should be in lowercase so they can work as expected. Ensure this in the internal logic.
When iterating through the rows and cells of an imported Worksheet in at least one of the rows GetValue().Value.ResultValueType for a number cell is set to GetValue().Value.ResultValueType.Text and the value to "error" or "string". For us this happens in a worksheet with 200 rows max. and columns formated as date, time, time followed by some text and number columns. In our Tests with different excel files it allways happened once (between line 11 and 16) and only for the first two columns. Exporting the worksheet back into a new excel file will show all rows and columns types and values OK.
Introduce support for cell reference ranges which refer to whole columns. For example "=Sheet1$A:$A" refers to the whole column A.
When defaultThemeVersion is missing from the file, some styles are not shown when the document is opened in MS Excel.
When I need to populate a cell that I find using a DefinedName I should parse RefersTo to get Worksheet name. But DefinedName class contains Scope property which has CurrentWorksheet and Workbook properties (internal). It would be very useful if these properties could be public.
The item is closed as duplicated of https://feedback.telerik.com/Project/184/Feedback/Details/190065-spreadprocessing-implement-right-to-left-direction.