ParamQuery grid support forum

General Category => Bug Report => Topic started by: jaapmurre on May 26, 2020, 03:16:24 am

Title: Formula =B8<>"" should give TRUE when B8 contains a 0 character but does not
Post by: jaapmurre on May 26, 2020, 03:16:24 am

See, the subject line. There seem to be many differences between Excel and Paramquery, to the extent that work-arounds are not even possible. We need to distinguish between 'empty cell' and 'cell with 0'. It seems that JavaScript falsy values are used instead of Excel interpretations.

Title: Re: Formula =B8<>"" should give TRUE when B8 contains a 0 character but does not
Post by: paramvir on May 26, 2020, 11:36:18 am

=B8<>0 can be used to distinguish between 'empty cell' and 'cell with 0', it can be verified here: https://paramquery.com/pro/demos/import-xlsx