search

andmarti1424 / sc-im

sc-im - Spreadsheet Calculator Improvised -- An ncurses spreadsheet program for terminal
Other
4.77k stars 201 forks source link

Referencing ranges from other sheets #850

Open niceiq opened 10 months ago

niceiq commented 10 months ago

I know it is possible to reference a cell from another sheet using {"sheet"}!AO, but can we do the same for ranges? I've been trying to get it working without luck.

Example: =@sum({"sheet"}!A0:A100)

Thank you @andmarti1424 for being so active by the way you're a big help!

andmarti1424 commented 10 months ago

I was expecting something like this: =@sum({"sheet_dos"}!A0:{"sheet_dos"}!A100) to work but it just doesnt. seeing the code of gram.y, may be someone that knows better yacc can chime in and see how to add to gram.y:1533 (var_or_range) the definition of gram.y:1201.. I will try to think about it

niceiq commented 10 months ago

That would be a great addition to the software.