Title: Division by zero error in wpdatatables plugin admin Last modified: February 14, 2020 --- # Division by zero error in wpdatatables plugin admin * Resolved [Souscaf](https://wordpress.org/support/users/souscaf/) * (@souscaf) * [6 years, 2 months ago](https://wordpress.org/support/topic/division-by-zero-error-in-wpdatatables-plugin-admin/) * Hi, * when I finally succeeded in importing my excel file in the admin of wpdatatables and I want to edit the table I then have a circle (loader) which turns in vain for hours and after a while I have dozens of lines appearing: “Warning: Division by zero in /home/eoselec/www/dev/wp-content/plugins/wpdatatables/lib/phpExcel/ PHPExcel/Style/NumberFormat.php on line 518 Warning: Division by zero in /home/ eoselec/www/dev/wp-content/plugins/wpdatatables/lib/phpExcel/PHPExcel/Style/NumberFormat. php on line 519 ” * thanks for your help * informations : WordPress 5.3.2 avec le thème Twenty Nineteen. no other plugin Viewing 9 replies - 1 through 9 (of 9 total) * Thread Starter [Souscaf](https://wordpress.org/support/users/souscaf/) * (@souscaf) * [6 years, 2 months ago](https://wordpress.org/support/topic/division-by-zero-error-in-wpdatatables-plugin-admin/#post-12439889) * having no answer I tried again after reinstalling wordpress with a blank database and nothing helps this plugin does not work … there when I want to import a file( either and xls, an xlsx or a csv) I have the hourglass for tens of minutes then a message which tells me that the page does not respond … I of course modified the wp-config with this value define `('WP_MAX_MEMORY_LIMIT', ' 512M ');` * I tested a lot of plugins on this server and a priori everything works well… but i really need to run wpdatatables … thanks for your help * Thread Starter [Souscaf](https://wordpress.org/support/users/souscaf/) * (@souscaf) * [6 years, 2 months ago](https://wordpress.org/support/topic/division-by-zero-error-in-wpdatatables-plugin-admin/#post-12450283) * nobody can help me? please * Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/) * (@wpdatatables) * [6 years, 2 months ago](https://wordpress.org/support/topic/division-by-zero-error-in-wpdatatables-plugin-admin/#post-12451408) * Hi Souscaf, Sorry for inconvenience, * We have some National holiday in our country which cause not working days from 14feb-18feb. * Can you please provide us that Excel file, so we can investigate the issue? If you have sensitive data then please provide us file with some dummy data with which you have this issue, so we can test it? * Best regards. * Thread Starter [Souscaf](https://wordpress.org/support/users/souscaf/) * (@souscaf) * [6 years, 2 months ago](https://wordpress.org/support/topic/division-by-zero-error-in-wpdatatables-plugin-admin/#post-12451441) * Hi, * no problem * [the xls file](https://www.eos-electronic.com/dev/wp-content/uploads/2020/02/ref-sous-cafeine-ok-2.xls) * thank * Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/) * (@wpdatatables) * [6 years, 2 months ago](https://wordpress.org/support/topic/division-by-zero-error-in-wpdatatables-plugin-admin/#post-12454485) * Hi Souscaf, * We check your file, and we notice that you have over 65 thousands rows which is overwhelmed for creating tables from Excel file. This table will not be stable with this option. You are getting errors because your first columns starts with numbers and then after some thousands rows there are only strings and wpdatatables try to assume what your column have based on first entries and because of that all strings which will be treated as null. When you have Excel file larger than 5000 rows, the page load and generation time will be slow and even it will break the page. * There is a solution for you but with our premium version with which you will use third option in table wizard and import that Excel file from which will be created table in database. Like this you will have server-side tables and loading of the table will be very fast. Please note that even with the premium version you will not be able to show all data on the page at once. * Best regards. * Thread Starter [Souscaf](https://wordpress.org/support/users/souscaf/) * (@souscaf) * [6 years, 2 months ago](https://wordpress.org/support/topic/division-by-zero-error-in-wpdatatables-plugin-admin/#post-12454520) * Hi, * thank a lot four your replie * I will therefore install the premium version and go through mysql … however I did not understand the last sentence of your answer: “Please note that even with the premium version you will not be able to show all data on the page at once.”( my level of English is pitiful) can you explain it to me? * thank * Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/) * (@wpdatatables) * [6 years, 2 months ago](https://wordpress.org/support/topic/division-by-zero-error-in-wpdatatables-plugin-admin/#post-12455382) * Hi Souscaf, * You are welcome. * In wpDataTables you have option how many rows you will show on table load and rest of it users will access over pagination buttons. By default, this option is set to 10, but you also have option to set to ALL which means that all your data(all 65000 rows of data) will be loaded on page which can cause breaking your page. * Best regards. * Thread Starter [Souscaf](https://wordpress.org/support/users/souscaf/) * (@souscaf) * [6 years, 2 months ago](https://wordpress.org/support/topic/division-by-zero-error-in-wpdatatables-plugin-admin/#post-12455439) * ha ok thank you it’s clearer but I was planning to use pagination and not “all”;) * Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/) * (@wpdatatables) * [6 years, 2 months ago](https://wordpress.org/support/topic/division-by-zero-error-in-wpdatatables-plugin-admin/#post-12456129) * Hi Souscaf, * You are welcome, * Then it will be all fine. Viewing 9 replies - 1 through 9 (of 9 total) The topic ‘Division by zero error in wpdatatables plugin admin’ is closed to new replies. * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404) * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/) * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq) * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/) * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/) * 9 replies * 2 participants * Last reply from: [wpDataTables](https://wordpress.org/support/users/wpdatatables/) * Last activity: [6 years, 2 months ago](https://wordpress.org/support/topic/division-by-zero-error-in-wpdatatables-plugin-admin/#post-12456129) * Status: resolved