Basic Limits

[wojciechczerniak]

Description

ODFF 1.3 [1] in section 3.7 defines basic limits that Evaluator (HF) shall support to meet the first requirement for Small Group Evaluator (section 2.3.2):

1. formulas up to at least 1024 characters long, as measured when in OpenDocument interchange format not counting the square brackets around cell addresses, or the “.” in a cell address when the sheet name is omitted.
2. at least 30 parameters per function when the function prototype permits a list of parameters.
3. permit strings of ASCII characters of up to 32,767 (2^15-1) characters.
4. support at least 7 nesting levels of functions.

Action

• Add tests so we're sure those requirements are always fulfilled.
  • Formulas up to 1024 characters long
  • at least 30 parameters per function
  • permit strings up to 32,767 characters
  • support at least 7 nesting levels of functions

Reference

[1] https://www.oasis-open.org/committees/documents.php?wg_abbrev=office

[wojciechczerniak]

Done. Tested in:

hyperformula/test/conformance/small-group-evaluator.spec.ts

Lines 41 to 92 in d3e0f0f

	describe('Basic Limits', () => {
	it('support functions with 30 parameters', () => {
	const engine = createEngine([
	['=SUM(B4,B5,B4,B5,B4,B5,B4,B5,B4,B5,B4,B5,B4,B5,B4,B5,B4,B5,B4,B5,B4,B5,B4,B5,B4,B5,B4,B5,B4,B5)'],
	...data,
	])
	expect(engine.getCellValue('A1')).toBe(75)
	})
	it('support formulas up to 1024 characters long', () => {
	const engine = createEngine([
	['=B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+B4+B5+1111'],
	...data,
	])
	expect(engine.getCellValue('A1')).toBe(1961)
	})
	it('can handle strings of ASCII characters can be up to 32767+ characters', () => {
	const str = 'x'.repeat(32767)
	const engine = createEngine([
	['="' + str + '"'],
	])
	expect((engine.getCellValue('A1') as string).length).toBe(32767)
	});
	it('support at least 7 levels of nesting functions', () => {
	const engine = createEngine([
	['=SIN(SIN(SIN(SIN(SIN(SIN(SIN(0)))))))'],
	...data,
	])
	expect(engine.getCellValue('A1')).toBe(0)
	})
	it('support up to 64 levels of nesting functions', () => {
	function generateNestedFunction(depth: number) {
	return (new Array(depth)).fill('0').reduce((val) => `SIN(${val})`, '0')
	}
	const depth = 64
	const engine = createEngine([
	['=' + generateNestedFunction(depth)],
	])
	expect(engine.getCellValue('A1')).toBe(0)
	expect((engine.getCellFormula('A1') as string).length).toBe(depth * 5 + 2)
	})
	})