1. Home
  2. Forum
  3. Angular - EJ 2
  4. Excel Like Filter Bug if value is undefined it breaks the filter

Excel Like Filter Bug if value is undefined it breaks the filter

Step to reproduce the bug:

Add item to a grid and leave one column untouched. 
Save data to firebase 

Refreshing the page and opening the excel like filter on that undefined value column is now broken.
Image_9949_1701886860791

Note there is difference between having something typed and then removed as then it becomes null which works fine. It's only if the value is undefined it does this.

If you hover the text filter row with an arrow you get the following error:

core.mjs:10592 ERROR TypeError: Cannot read properties of undefined (reading 'length')

    at ExcelFilterBase.getCMenuDS (ej2-grids.es5.js:24967:48)

    at ExcelFilterBase.hoverHandler (ej2-grids.es5.js:25117:29)

    at _ZoneDelegate.invokeTask (zone.js:402:31)

    at core.mjs:10735:55

    at AsyncStackTaggingZoneSpec.onInvokeTask (core.mjs:10735:36)

    at _ZoneDelegate.invokeTask (zone.js:401:60)

    at Object.onInvokeTask (core.mjs:11048:33)

    at _ZoneDelegate.invokeTask (zone.js:401:60)

    at Zone.runTask (zone.js:173:47)

    at ZoneTask.invokeTask [as invoke] (zone.js:483:34)

handleError @ core.mjs:10592

next @ core.mjs:28276

next @ Subscriber.js:91

_next @ Subscriber.js:60

next @ Subscriber.js:31

(anonymous) @ Subject.js:34

errorContext @ errorContext.js:19

next @ Subject.js:27

emit @ core.mjs:10648

(anonymous) @ core.mjs:11087

invoke @ zone.js:368

run @ zone.js:129

runOutsideAngular @ core.mjs:10957

onHandleError @ core.mjs:11087

handleError @ zone.js:372

runTask @ zone.js:176

invokeTask @ zone.js:483

invokeTask @ zone.js:1631

globalCallback @ zone.js:1662

globalZoneAwareCallback @ zone.js:1695

Show 20 more frames

Show less

core.mjs:10592 ERROR TypeError: Cannot read properties of undefined (reading 'length')

    at ExcelFilterBase.getCMenuDS (ej2-grids.es5.js:24967:48)

    at ExcelFilterBase.hoverHandler (ej2-grids.es5.js:25117:29)

    at _ZoneDelegate.invokeTask (zone.js:402:31)

    at core.mjs:10735:55

    at AsyncStackTaggingZoneSpec.onInvokeTask (core.mjs:10735:36)

    at _ZoneDelegate.invokeTask (zone.js:401:60)

    at Object.onInvokeTask (core.mjs:11048:33)

    at _ZoneDelegate.invokeTask (zone.js:401:60)

    at Zone.runTask (zone.js:173:47)

    at ZoneTask.invokeTask [as invoke] (zo


1 Reply
RR Rajapandi Ravi Syncfusion Team December 7, 2023 05:05 AM UTC

Hi Frank,


Greetings from Syncfusion support


Before we start providing solution to your query, we need some more information for our clarification. So please share the below details that would be helpful for us to provide better solution.


1)              Share your complete Grid rendering code( client & server ), we would like to check your implementation.


2)              In your query you have mentioned that “Add item to a grid and leave one column untouched.”, so please share the detailed description about this query.


3)             Share the details about what type of databinding you are using in the Grid (local or remote).


4)             If remote what type of adaptors you are using in your application.


5)           
Share your issue scenario in video demonstration format.


6)             Share your Syncfusion package version.


Regards,

Rajapandi R


Loader.
Up arrow icon