Description
Some formulas seem to be stored in the HF engine as undefined, while returning a proper result. Steps to reproduce are based on the ABS formula, but it looks similar for:
ASINATANCOSCOTCOUNTIFSDEGREESEVENINTISEVENISODDLNLOGLOG10MAXANOTODDROUNDROUNDDOWNROUNDUPSINTANTRUNCXOR
Steps to reproduce
const hf = HyperFormula.HyperFormula.buildEmpty();
hf.addSheet('test');
hf.setCellContent({row: 0, col: 0, sheet: hf.sheetId('test')}, '=ABS(-34)');
console.log(hf.getCellFormula({row: 0, col: 0, sheet: hf.sheetId('test')}));
Result: =undefined(-34)
Your environment
- HyperFormula version:
f4ac5ea342c598ba0388ee3887fe1a1fa7f21e08
Description
Some formulas seem to be stored in the HF engine as
undefined, while returning a proper result. Steps to reproduce are based on theABSformula, but it looks similar for:ASINATANCOSCOTCOUNTIFSDEGREESEVENINTISEVENISODDLNLOGLOG10MAXANOTODDROUNDROUNDDOWNROUNDUPSINTANTRUNCXORSteps to reproduce
Result:
=undefined(-34)Your environment
f4ac5ea342c598ba0388ee3887fe1a1fa7f21e08