Error exporting grid data to csv

[Q&A] General
1

One of our users gets a very cryptic error message when exporting grid data to csv.
When I do the same I do not get the error.
What does this error mean ?

image

2

This arithmetic overflow error typically occurs when there is an integer value that exceeds the 32 bit space, so when an integer becomes higher than 2.1 million (signed integers, which can go below zero) or 4.2 million (non-signed).

When it occurs in an export, my suspicions go towards this:

  1. You have a large number of records, more than 10.000, so footers are disabled
  2. Your grid has a footer that makes a sum over an integer column
  3. Your export does try to include the footer, and the sum will be over 2.1 million

Does your grid have such a footer with a sum? If yes, remove the footer and try again.

3

Hi Joost,

Thanks for your answer, our user had 2 footers on the grid. The total amount was €79.290,72 (see screenshot)
After removing both footers it worked.

image

Edit: The problem was not with the total amount, in the first footer aantal and sum were both selected.
After removing sum (which only showed ‘-’) it worked as this would indeed sum up to a very big number for that column.

1 Like