Excel compatibility issues about hyperformula HOT 3 CLOSED

Thank you for bringing this up. That is a valuable feedback.

We will check it out internally and update this thread.

from hyperformula.

Thanks for confirming! I've been using LibreOffice 7.3 to work with this particular xlsx (I don't have access to Excel on Linux), so maybe the differences are actually there. It was quite a convoluted debugging process to figure out which parts of huge formulas was differing, and it's possible I didn't isolate the root causes properly.

from hyperformula.

@dabreegster

• I checked the INDEX issue and it seems to work. Unless I misunderstand your point.

  it('should assume first column if no last argument', () => {
    const engine = HyperFormula.buildFromArray([
      [1, 2],
      [3, 4],
      ['=INDEX(A1:B2, 2)'],
    ])

    expect(engine.getCellValue(adr('A3'))).toEqual(3)
  })

• Excel for Windows (Version 2403, 64-bit) also gives #NUM for formula =(-2)^5.5
• Our naming rules for the named expressions follow the Open Document Standard and are already mentioned in the List of differences with other software

from hyperformula.