koala icon indicating copy to clipboard operation
koala copied to clipboard
verified publisher icon vallettea

Percentage token has .tvalue as float

Open jnwltr opened this issue 6 years ago • 2 comments

  • str was expected
  • e.g. =IF(RANGE>75%; 1; 0) fails since 75% is translated to 0.75
  • while =IF(RANGE>.75; 1; 0) would translate to '0.75'

jnwltr avatar Sep 17 '19 21:09 jnwltr

This really requires tests... Also if the code was rebased/merged with master, the CI tests should now pass.

brianmay avatar Jan 14 '20 21:01 brianmay

I'll gladly write a test. So create tests/files/IfPercent.xlsx and add the test to tests/excel/test_excel.py?

jnwltr avatar Mar 05 '20 11:03 jnwltr