Hi,
I have a MySQL table that must be updated using a spreadsheet with formulas. I have set up two tables, one for the database data and one for the user data (directly below the database table). The formulas in the database table reference the user data table, where all changes are made.
When I change the user data the database table changes accordingly, and the colors change to show the altered fields but the Commit button remains greyed out.
Can anyone tell me what I am doing wrong? Thanks.
How do I update a MySQL table with user data using excel formulas
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: How do I update a MySQL table with user data using excel formulas
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: How do I update a MySQL table with user data using excel formulas
We have fixed the bug with disabled Commit and Rollback buttons when the imported table has a formula referencing another Excel table after changes in this other table. We will post here when the corresponding build of Excel Add-ins is available for download.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: How do I update a MySQL table with user data using excel formulas
New build of Devart Excel Add-ins 2.0.86 is available for download now!
It can be downloaded from http://www.devart.com/excel-addins/download.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=38410
It can be downloaded from http://www.devart.com/excel-addins/download.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=38410