Decimal parsing inconsistency

[wojciechczerniak]

Description

Javascript allows omitting leading zero in decimals. If we add [".1"] as a const, the engine will parse it to a number. But when we use it inside a formula ["=0.1"] an error will occur.

Either we support this or not. We have to choose.

Steps to reproduce

    it('can or cant parse a decimal without leading zero', () => {
      const engine = createEngine([
        ['.1', '=.1']
      ]);

      expect(engine.getCellValue('A1')).toBe(0.1);
      expect(engine.getCellValue('B1')).toBe(0.1);
    });

Links

https://github.com/handsontable/formula-parser/issues/91

[wojciechczerniak]

A user mentioned https://github.com/handsontable/formula-parser/issues/91#issuecomment-578122077 that it is supported in Excel Online and Libre Office. We should check that

[izulin]

solved #166