handsontable / handsontable/hyperformula
FORMULATEXT failing when the argument is not a CellReference type
Open
Nobody has claimed this yet.
Bug
Function
Impact: Low
- Dominant language
- TypeScript
- Stars
- 2.8k
- Forks
- 171
- Avg merge
- 1d 22h
- Merged PRs (30d)
- 7
Description
Description
This works as expected in Google Sheets and Excel
const hyperformulaInstance = HyperFormula.buildEmpty({
licenseKey: 'internal-use-in-handsontable',
});
const containerName = 'example'
var container = document.getElementById('example')
container.hot = new Handsontable(
container,
{
licenseKey: 'non-commercial-and-evaluation',
rowHeaders: false,
colHeaders: false,
height: 'auto',
fillHandle: false,
formulas: {
engine: hyperformulaInstance,
sheetName: containerName
},
data: [
[1, 2, '=SUM(A1:B1)', '=FORMULATEXT(C1)'],
[2, 3, '=SUM(A2:B2)', '=FORMULATEXT(index(C:C,2))'],
[3, 4, '=SUM(A3:B3)', '=FORMULATEXT(index(C:C,ROW()))'],
]
}
)
| Platform | Results |
|---|---|
| HyperFormula |  |
| Google Sheets |  |
| MS Excel |  |
Steps to reproduce
Your environment
- Handsontable: v12.3.2 (22/03/2023 14:43:31)
- HyperFormula: 2.3.1
- Browser Name & OS: Mac + Chrome
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the JSFiddle reproduction and the FORMULATEXT entry point, comparing direct CellReference input with the INDEX-based arguments shown in the example. Verify that the formula text is returned for both indirect references and the ROW-based case, matching the Google Sheets and Excel results.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- typescript
- Domain
- data
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100