Bug Report T318660
Visible to All Users

Charting - DateTime cell values for the category axis are displayed are extrapolated to 1st day of the following month!

created 9 years ago

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

Comments (1)
DevExpress Support Team 9 years ago

    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.

    Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

    Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.