error-literals.spec.ts

import {HyperFormula} from '../../src'
import {ErrorType, simpleCellAddress} from '../../src/Cell'
import {Config} from '../../src/Config'
import {SheetMapping} from '../../src/DependencyGraph'
import {buildTranslationPackage, enGB, plPL} from '../../src/i18n'
import {AstNodeType, ErrorAst, ParserWithCaching, ParsingErrorType} from '../../src/parser'

describe('Parsing error literals', () => {
  it('should parse error literals', () => {
    const parser = new ParserWithCaching(new Config(), new SheetMapping(buildTranslationPackage(enGB)).get)
    const ast = parser.parse('=#VALUE!', simpleCellAddress(0, 0, 0)).ast as ErrorAst
    expect(ast.type).toBe(AstNodeType.ERROR)
    expect(ast.error.type).toEqual(ErrorType.VALUE)
  })

  it('should parse error literals with ?', () => {
    const parser = new ParserWithCaching(new Config(), new SheetMapping(buildTranslationPackage(enGB)).get)
    const ast = parser.parse('=#NAME?', simpleCellAddress(0, 0, 0)).ast as ErrorAst
    expect(ast.type).toBe(AstNodeType.ERROR)
    expect(ast.error.type).toEqual(ErrorType.NAME)
  })

  it('should parse error literals with slashes', () => {
    const parser = new ParserWithCaching(new Config(), new SheetMapping(buildTranslationPackage(enGB)).get)
    const ast = parser.parse('=#N/A', simpleCellAddress(0, 0, 0)).ast as ErrorAst
    expect(ast.type).toBe(AstNodeType.ERROR)
    expect(ast.error.type).toEqual(ErrorType.NA)
  })

  it('should parse error in other languages', () => {
    HyperFormula.registerLanguage('plPL', plPL)
    const parser = new ParserWithCaching(new Config({language: 'plPL'}), new SheetMapping(buildTranslationPackage(plPL)).get)
    const ast = parser.parse('=#ARG!', simpleCellAddress(0, 0, 0)).ast as ErrorAst
    expect(ast.type).toBe(AstNodeType.ERROR)
    expect(ast.error.type).toEqual(ErrorType.VALUE)
  })

  it('should parse #DIV/0!', () => {
    const parser = new ParserWithCaching(new Config({language: 'enGB'}), new SheetMapping(buildTranslationPackage(enGB)).get)
    const ast = parser.parse('=#DIV/0!', simpleCellAddress(0, 0, 0)).ast as ErrorAst
    expect(ast.type).toBe(AstNodeType.ERROR)
    expect(ast.error.type).toEqual(ErrorType.DIV_BY_ZERO)
  })

  it('should return parser error', () => {
    const parser = new ParserWithCaching(new Config({language: 'enGB'}), new SheetMapping(buildTranslationPackage(enGB)).get)
    const { ast, errors } = parser.parse('=#UNKNOWN!', simpleCellAddress(0, 0, 0))
    expect(ast.type).toBe(AstNodeType.ERROR)
    expect(errors[0].type).toBe(ParsingErrorType.ParserError)
    expect(errors[0].message).toBe('Unknown error literal')
  })
})