Can't export more than 5000 rows to Excel?

Question :

I have a problem about export data to xls,

I can't export more then 5000 rows to excel?

Answer :

Well after doing my last testing i found the answer and was very easy.

I was using LINUX UBUNTU 64 bit and it uses OPEN OFFICE (LIBRE CALC) and this program is only showing 5000 rows.

The solution is:

Open the file using Microsoft Excel on Windows.

Thank you.