Data Widgets : Data grid2 Export_To_Excel >>> ERROR : Cannot read properties of undefined (reading toNumber)

0
I am using the "Data grid2" widget with the "JS: Export_To_Excel"  from "DataWidgets".   Where Mendix Studio Pro did not throw an error , but at runtime, when I press the "call Nanoflow Button" that calls "Export_To_Excel",   I get the following error: An error occurred while executing an action of Main.CQPDatabase_Overview.actionButton1: Cannot read properties of undefined (reading 'toNumber')   Nanoflow stack:  "Call JavaScript Action: DataWidgets.Export_To_Excel" in nanoflow "Main.ACT_CQPDatabase_toExcel"   at http://localhost:8080/mxclientsystem/mxui/mxui.js?638567435886998972:61:176091   at ye (http://localhost:8080/mxclientsystem/mxui/mxui.js?638567435886998972:19:6830)   at i (http://localhost:8080/mxclientsystem/mxui/mxui.js?638567435886998972:19:6731)  at O (http://localhost:8080/mxclientsystem/mxui/mxui.js?638567435886998972:59:5099)   I am not using any Custom content Columns in the data grid2. How do I fix it?
asked
6 answers
6

We ran into this issue on the latest version of Data Widgets.  We originally did not pass a ChunkSize to Export_To_Excel and left it empty.  This seems to throw this error now and it requires an integer.  This is the number of rows it processes at a time, you will sometimes notice a progress bar when exporting a large amount of rows.  I seem to get the fastest exports using 500 for this number in my testing.

 

You can also downgrade to Data Widgets v2.20.1, which still allows the empty value on ChunkSize.

answered
2

Hi, Example of the parameters, important a number in "Chunk size"

 

image.png

answered
1

I am having exactly the same problem after using chunk size as -1. Any other solutions?

answered
1

Adding 0 in chunk size solved it for me. If you want all rows to be exported add 0 in chunk size. 

answered
0

I have excactly the same problem. Downgrading did not solve the problem. Any solutuons yet?

answered
0

Solved this by upgrading Data Widgets to 2.28.2.

answered