This is a feature that excel has needed for a long time. The ability to reference a range that expands as more data is put in. I just added to 3dspread3 a postfix to addresses that results in the current cell and every continuous cell that is in a specified direction.
Addresses in 3dspread3 are three dimentional but the UI is two dimentional because I haven't figured out how to draw a 3d spreadsheet in web browser and I've decided that's not a problem I need to solve. Ranges are just two addresses right next to each other. Addresses are also prefixed by c.
Regular address: c1:2:0
Range: c1:2:0c4:3:0
Auto expanding range: c:1:2:0d where the d means down
To try it out I suggest using the shift-click feature. That auto-pastes whatever cell you click into your formula. So to select a range you just shift-click the top left then the bottom right. The formula system is just javascript. Ranges output an array of the values referenced.
The expansion letters are u,d,l,r.
A link exists in the sidebar.
If adopting it for long term use I do suggest firefox because I was a firefox user back when I made this and some of the ctrl-click features work better in it (selecting a cell rather than editing it, excel uses double click to edit a cell, I use single click, so I had to use something else for selection for copying, filling down and what not, works better in firefox).
I should also say the expandable ranges only work in one dimention at the current moment. I'm going to put it in my list to expand that but it isn't really a priority unless someone else needs it, so it will likely float to the bottom of said list. If I were to do it you could just add additional directions. c:1:2:0dr, or c:1:2:0udr.
This is a feature that excel has needed for a long time. The ability to reference a range that expands as more data is put in. I just added to 3dspread3 a postfix to addresses that results in the current cell and every continuous cell that is in a specified direction.
Addresses in 3dspread3 are three dimentional but the UI is two dimentional because I haven't figured out how to draw a 3d spreadsheet in web browser and I've decided that's not a problem I need to solve. Ranges are just two addresses right next to each other. Addresses are also prefixed by c.
Regular address: c1:2:0
Range: c1:2:0c4:3:0
Auto expanding range: c:1:2:0d where the d means down
To try it out I suggest using the shift-click feature. That auto-pastes whatever cell you click into your formula. So to select a range you just shift-click the top left then the bottom right. The formula system is just javascript. Ranges output an array of the values referenced.
The expansion letters are u,d,l,r.
A link exists in the sidebar.
If adopting it for long term use I do suggest firefox because I was a firefox user back when I made this and some of the ctrl-click features work better in it (selecting a cell rather than editing it, excel uses double click to edit a cell, I use single click, so I had to use something else for selection for copying, filling down and what not, works better in firefox).
I should also say the expandable ranges only work in one dimention at the current moment. I'm going to put it in my list to expand that but it isn't really a priority unless someone else needs it, so it will likely float to the bottom of said list. If I were to do it you could just add additional directions. c:1:2:0dr, or c:1:2:0udr.
(post is archived)