My scenario is this one :
An SQL query output several columns and a excel formula in the last column (referencing the first columns to compute a result).
If i copy paste the result of my query from MS-SQL to excel, everything works fine, the formula is directly "interpreted" by excel and value displayed in the cell is as expected.
When the same query is run by dspMigrate and the excel file generated, when i open the excel file, the formula is interpreted as text, and i have to "activate" it (selecting the cell + press enter is enough, but unwanted step).
Is it possible to have dspMigrate generating excel in which cells holding formulas are already active ?
Any hints appreciated
Please sign in to leave a comment.