Google Sheets compatibility also need TRUE / FALSE constants

[oodavid]

Page URL

https://hyperformula.handsontable.com/guide/compatibility-with-google-sheets.html#configure-compatibility-with-google-sheets

Improvement description

I've noticed that Google sheets does have TRUE and FALSE constants, but the documentation does not mention this on the Google Sheets doc. The MS Excel one is fine.

These are the expressions that I used in Google Sheets to test the behaviour

=IF(FALSE, "FALSE does not work", "FALSE works")
=IF(TRUE, "TRUE works", "FALSE does not work")

[BrianHung]

I believe you can used named expressions to hack around this.

[oodavid]

Yes, we've followed the Compatibility with Excel guide to do that.

I think the Google Sheets docs need to reflect the requirement :)

[sequba]

@oodavid Yes, you're right. Google must have changed it since we wrote that guide.