handsontable / handsontable/hyperformula
Ability to move/modify cells for array values.
Open
@sequba is already working on this.
Since Feb 10, 2022.
Bug
Impact: High
- Dominant language
- TypeScript
- Stars
- 2.8k
- Forks
- 171
- Avg merge
- 1d 22h
- Merged PRs (30d)
- 7
Description
Here's the unit test that specifies this isn't allowed:
it('should not be possible to move cells to area with matrix', () => {
const [engine] = HyperFormula.buildFromArray({ cells: [
[{ cellValue: '1' }, { cellValue: '2' }],
[{ cellValue: '=TRANSPOSE(A1:B1)' }],
]})
expect(() => {
engine.moveCells(AbsoluteCellRange.spanFrom(adr('A1'), 2, 1), adr('A2'))
}).toThrowError('Cannot perform this operation, target location has an array inside.')
})
Google sheets allows this and there's no real reason to not allow it imo so it would be a good feature.
For example when you do a cut/paste it doesn't work on array cells.
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.
Assessment
This issue has not been assessed yet.