[Squirrel-sql-users] numbers change on XLS export

[Pablo M. <PMe...@de...>]

Hello, everyone,

Something odd just happened. A column of numbers changed on export to Excel. All the numbers in that column increased by 1. Other numeric columns in the same spreadsheet were unaffected. This problem did not occur when exporting the same data to a CSV. For both exports, I used the export option on the grid's right-click menu.

This is very disconcerting. Either I encountered a bad interaction between MySQL and Excel, or the client is acting up somehow. Very strange. Very discomfiting.

Any input you might have about such occurrences would be welcome.

Pablo Melendez  |  Data Engineer  |  pme...@de...  |  demandbase  |  415.683.2940