5 ms·

I just tested in Excel and Google Sheets and our behavior matches them here, unless I am misunderstanding the repro steps. For me, A3 becomes =SUM(A1:A2)+A1+A2

I just tested in Excel and Google Sheets and our behavior matches them here, unless I am misunderstanding the repro steps. For me, A3 becomes =SUM(A1:A2)+A1+A2 and remains 4 as it should be. The action I am taking: A0=1 A1=1 A2=SUM(A0:A1)+A0+A1 (evaluates to 4) Right click A0 and click "insert row above" Now I have: A0=empty A1=1 A2=1 A3=SUM(A1:A2)+A1+A2 (evaluates to 4) Thank you for trying to find edge cases! I have put literally hundreds of hours into stuff like this. Let me know if you have different repro steps.

jkaptur 3y ago
> Right click A0 and click "insert row above" Instead, right click A1 and click "insert row above". Google Sheets (and, I'm 99.99% sure, Excel) adjust the range inside the SUM to be three rows high. I've put quite some time into this sort of thing too :)
- gamegoblin 3y ago
  Didn't know who I was talking to, looked you up now, amazing ;) Thanks a lot for the bug report. We actually used to implement the range-extension logic in Excel/Sheets but removed it during a cut-paste refactor due to the complexity (I'm sure you know...) and resolved to add it back when someone asked for it. I actually found edge cases where Sheets and Excel don't do range extension logic the same way. So we don't do the range extension for now, but the 4 not getting recomputed to 3 is definitely a bug, will fix!
  - emeril 3y ago
    I can't copy and paste formulas to more than one cell at a time? if I highlight a range of cells to copy something to, only the last cell will be populated?
    - gamegoblin 3y ago
      We didn't know about this formula-paste-to-range functionality, we will add it in the next few days as we grind down this post-launch backlog. Let us know any other stuff we are missing please! In the mean time you can still paste the formula to the top cell then drag it down or ctrl+D as a workaround, but we want to support the full experience, so check back in a few days and it should be there :)
      - emeril 3y ago
        I've been the excel/vba resource at various consulting firms for 20+ years... I strongly recommend you enlist some people like me to kick the tires on your product before a more wide roll-out among other things, I'd make an effort to implement as many standard excel functions as possible --> I would LOVE a highly performant version of google sheets (though ideally as a desktop style app) so I can use keyboard shortcuts among other reasons --> one thing I like about google sheets that you don't have is that it has excel style short-cuts like alt+d+f+f for autofilter... (though I really only use google sheets as a grocery list so I can walk through my house and do an inventory using my phone)
        gamegoblin 3y ago
        We have a super fast iteration cycle, so most times a user asks us for a feature parity thing like this, we can ship it within 24 hours. This particular one might be slow for us, a few days :) If we waited until we had full Excel parity, we would never ship. Google Sheets has been around for 17 years and still doesn't have full Excel parity on features or functions, and that's with dozens of engineers working on it full time. Luckily now that we are launched we have a bunch of very knowledgable people like you requesting all these features, and this gives us a really good signal for prioritization. E.g. a bunch of other people also requested the alt-shortcuts, so they are pretty high priority Highest priority are the bugs like jkaptur pointed out above, and some other people had some crazy CSV files that we couldn't parse. So I'll fix those today and get to the copy-paste-formula-to-range thing in the next day or two. Alt shortcuts is very high on our frontend guy's list.
        3y ago

jkaptur 3y ago

> Right click A0 and click "insert row above" Instead, right click A1 and click "insert row above". Google Sheets (and, I'm 99.99% sure, Excel) adjust the range inside the SUM to be three rows high. I've put quite some time into this sort of thing too :)

gamegoblin 3y ago
Didn't know who I was talking to, looked you up now, amazing ;) Thanks a lot for the bug report. We actually used to implement the range-extension logic in Excel/Sheets but removed it during a cut-paste refactor due to the complexity (I'm sure you know...) and resolved to add it back when someone asked for it. I actually found edge cases where Sheets and Excel don't do range extension logic the same way. So we don't do the range extension for now, but the 4 not getting recomputed to 3 is definitely a bug, will fix!
- emeril 3y ago
  I can't copy and paste formulas to more than one cell at a time? if I highlight a range of cells to copy something to, only the last cell will be populated?
  - gamegoblin 3y ago
    We didn't know about this formula-paste-to-range functionality, we will add it in the next few days as we grind down this post-launch backlog. Let us know any other stuff we are missing please! In the mean time you can still paste the formula to the top cell then drag it down or ctrl+D as a workaround, but we want to support the full experience, so check back in a few days and it should be there :)
    - emeril 3y ago
      I've been the excel/vba resource at various consulting firms for 20+ years... I strongly recommend you enlist some people like me to kick the tires on your product before a more wide roll-out among other things, I'd make an effort to implement as many standard excel functions as possible --> I would LOVE a highly performant version of google sheets (though ideally as a desktop style app) so I can use keyboard shortcuts among other reasons --> one thing I like about google sheets that you don't have is that it has excel style short-cuts like alt+d+f+f for autofilter... (though I really only use google sheets as a grocery list so I can walk through my house and do an inventory using my phone)
      - gamegoblin 3y ago
        We have a super fast iteration cycle, so most times a user asks us for a feature parity thing like this, we can ship it within 24 hours. This particular one might be slow for us, a few days :) If we waited until we had full Excel parity, we would never ship. Google Sheets has been around for 17 years and still doesn't have full Excel parity on features or functions, and that's with dozens of engineers working on it full time. Luckily now that we are launched we have a bunch of very knowledgable people like you requesting all these features, and this gives us a really good signal for prioritization. E.g. a bunch of other people also requested the alt-shortcuts, so they are pretty high priority Highest priority are the bugs like jkaptur pointed out above, and some other people had some crazy CSV files that we couldn't parse. So I'll fix those today and get to the copy-paste-formula-to-range thing in the next day or two. Alt shortcuts is very high on our frontend guy's list.
        3y ago