Dear DevExpress Team
presently we are testing the spreadsheet control. We found some problems in the Chart API:
-DateTime cell values for the category axis are extrapolated to the 1st day of the following month. E.g. 12/31/2014 is shown as 1/1/2015, which means that the date axis starts with the wrong year! See attached screenshot.
Excel shows for the same date 12/1/2014 and the Axis Data Type can be changed to"Text". How can we do this in your control?
Here are some other problems:
- Bars are not rendered correctly, OK whenMajorTimeUnit is set explicitly to AxisTimeUnits.Months
- Chart data range not updated when moving cell range.
- Filter selects correct chart-data-range, but does not update chart.
- AutoFilter sort data type is ''Text'' instead of ''Numeric''.
- No Sparklines.
- Grid Lines and Fonts have different color than in Excel.
- Data Labels have a different have a different position than in Excel. If needed we can send an sample project and Excel file.
Thanks in advance and best regards
Henry
Hi,
Our team is dedicated to addressing all your concerns. For quick and efficient responses, we kindly request that future tickets cover one issue at a time. Your time and cooperation are appreciated.
In order to better serve and track multiple questions in your inquiry, we have taken the liberty of separating the issues you addressed. Please refer to these tickets for further correspondence on these items.
- T318927: How to change the type of the Chart axis
- T318928: Bars are not rendered correctly
- T318925: Chart data range not updated when moving cell range
- T318929: Filter selects correct chart-data-range, but does not update chart
- T318930: AutoFilter sort data type is ''Text'' instead of ''Numeric''
- T318926: No Sparklines
- T318924: Grid Lines and Fonts have different color than in Excel
- T318923: Data Labels have a different position than in Excel
As for the first issue, "DateTime cell values for the category axis are extrapolated to the 1st day of the following month", we have successfully reproduced the behavior you described and passed this ticket to our developers for further research.
Please bear with us. We will notify you as soon as we make any progress.