Excel - Get Value with ####

Follow

Andrius Sirtautas

January 20, 2020 10:05

Hi 

Is it intentional that when you have an Excel cell with a format 'Number' and the number doesn't fit, foxtrot reads it as '#####' (the way it is displayed in excel), and not the actual number?

 

I tried also setting foxtrot to use Value instead of Text but this only works if the Value of the cell is the number, but if it is a formula then ir just reads the formula and not what is displayed, which is the correct way, however it would be nice that there would be an option to read the actual number even if it doesn't fit in the cell.

0

• 

  Mathias Balsløw January 20, 2020 10:23

  Hi Andrius Sirtautas,

  This is how the developers of Foxtrot decided that the action should work. So it is on purpose. The solution/workaround is to implement a "Set Column Width" action to make sure that you avoid the "####".

  0

  Comment actions Permalink

Please sign in to leave a comment.