In the past the Addin would export the file with the formulas and save the numbers as numbers and not text. Why does this not work anymore?
#12 Formulas and Numbers
Posted in ‘Ian's Excel Add-in’
This is a public ticket
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Latest post by on Saturday, 28 April 2018 03:15 SAST
Wednesday, 28 March 2018 17:33 SAST
Ian
Hi Marc,
The code behind the addin has not been changed in any way to act like this. I have just done an import to confirm its operation.
The first thought that comes to mind is that under certain circumstances Excel may treat cell contents as text rather than values, e.g. if the cell is formatted as text rather than a numeric format. Have you perhaps recently changed computers or otherwise had maintenance done on your installation of Excel which may have changed the default cell formats?
Kind regards,
Ian
The code behind the addin has not been changed in any way to act like this. I have just done an import to confirm its operation.
The first thought that comes to mind is that under certain circumstances Excel may treat cell contents as text rather than values, e.g. if the cell is formatted as text rather than a numeric format. Have you perhaps recently changed computers or otherwise had maintenance done on your installation of Excel which may have changed the default cell formats?
Kind regards,
Ian
Saturday, 28 April 2018 03:15 SAST
System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.