1. Feedback
  2. Angular
  3. 22267

Welcome to the Angular feedback portal. We’re happy you’re here! If you have feedback on how to improve the Angular, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Dragging field with numeric data with blanks throws error when dragging to empty row or column axes

Reproduced here: 

https://stackblitz.com/edit/angular-zftczf-qwyrhd?file=app.component.ts

If you have data assigned to a pivot grid which is created from a dynamic data set, and one column has only numeric values as well as blank/empty data, the grid (correctly) interprets the column as being a numeric data type.

However, if you try to drag that column onto the Columns or Rows axes, and the axis it is dragged to does not already have a field in it, the control throws an error, the column is not placed on the axis, and the spinner continues to spin indefinitely.

Please see the example linked above. Dragging the "order" field onto the Rows or Columns axis when it is empty causes the problem. You can click the Refresh button to change the dataset which gets the field list out of its locked up state.

The error shown in the console is:

Going into the code further, it appears the problem is related to attempting to sort the column, and when the blank data is used, the regular expression returns null:

                                (alphaNumbervalue.sort((a, b) => (Number(a.actualText.toString().match(/\d+/)[0]) > Number(b.actualText.toString().match(/\d+/)[0])) ? 1 : ((Number(b.actualText.toString().match(/\d+/)[0]) > Number(a.actualText.toString().match(/\d+/)[0])) ? -1 : 0))) :


I verified this in the latest patch released today (18.4.0.42) and it is also present in the previous version.


Thanks,

Michael