hyperformula icon indicating copy to clipboard operation
hyperformula copied to clipboard

Published 20 hours ago • verified publisher icon handsontable

Support 3D references

Open wojciechczerniak opened this issue 5 years ago • 2 comments

Description

Since we're supporting Worksheets it would be cool to support all features.

=SUM(Sheet1:Sheet4!B3)

obraz

We need to support all CRUD operations on Worksheets:

  • Add sheet
  • Remove sheet
  • Move sheet

Rename should not have an impact on the sheet sequence.

Reference

https://support.office.com/en-us/article/Create-a-3-D-reference-to-the-same-cell-range-on-multiple-worksheets-40ca91ff-9dcb-4ad1-99d2-787d0bc888b6#bmlearn_more_about_a_3_d_refererence

wojciechczerniak avatar Nov 15 '19 13:11 wojciechczerniak

Moved from #29

API Proposal

public moveSheets(sheet: number, ... ? ...): CellValueChange[]
public isItPossibleToMoveSheets(... ? ...): boolean;

wojciechczerniak avatar Jan 07 '20 11:01 wojciechczerniak

Inform ZD

adrianszymanski89 avatar Mar 18 '22 09:03 adrianszymanski89