Multi-grid sheets ?

[fadi]

This is a major feature suggestion but can sheets be made to support more than one grid. Each grid should have its name and can support its own filtering and sorting operations . This is similar to mac numbers and rows.com . Grids could be resized to fit the table you are creating and when printing you can select which grid could be included in the print. Grids do not need to be movable like the case with mac numbers, rather listed above each other. Currently all spreadsheet apps follow the excel model, one endless grid that can be used unfortunately for only one table. One way to achieve this is by creating a parallel experimental version. The idea is that grids could complement each other in terms of information . One can grow endlessly while the other could provide analytics.

[fadi]

Another idea that would complement the first one is that a workbook should be able to contain hundreds of sheets but they are not all loaded into the ram when you open the workbook, unless you designate a certain sheet to be loaded on startup. Instead it should load a sheet browser that functions like a file manager with each sheet having its own icon. You should be able to group them by letter or create groups and subgroups and direct your sheets to them . When you open a sheet , it is loaded into the ram and its tab is shown, but when all sheets are closed only the sheet browser is shown . This would allow a better ram consumption.To achieve this I believe the plus sign next to sheet tabs would be replaced by an icon to the sheet browser, and sheet tabs would include close buttons

[fadi]

Also you may have to introduce more relative cell reference ,next to the current method of course , such as B-first, B-last , an B@row. Last in particular would be very useful for mult-grid design since users would continually add more rows to grids. For analytics in the second grid, for example, you will have to put something like : secondgrid.B4=sum(firstgrid.B3:firstgrid.B-last) for calculating sum, and for average it would be : secondgrid.B6=average(firstgrid.B3:firstgrid.B-last) , and so on.

[raitis.veksejs]

Thank you for your feature requests! I forwarded them to our Product Management...