4 ms·

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 Exc

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.
      - emeril 3y ago
        I wish you luck, I can definitely appreciate the difficulty in trying to achieving some degree of excel feature parity I had come across this copy to more than one cell issue when I was curious to see the performance myself in making some random numbers and doing some look-ups based on those results which I couldn't do en masse due to this limitation a few other things to think about implementing (1) some more formatting/font/point size options (2) customizable number formatting like excel (3) functions like hlookup, edate, perhaps even array function like functionality (i.e., a relatively powerful and open ended underused feature in excel due to a combination of difficulty in understanding as well as being very slow calculation-wise) (4) some minimal vector drawing abilities (5) it doesn't bother me and it's part of your marketing but starting with "0" may confuse some people (and would break excel compatibility) since excel doesn't do that (though I appreciate indices/etc. do that in "real" programming) (6) filtering data doesn't include a "contain" or "does not contain" option (7) perhaps some limited ability to customize the interface and have user defined keyboard shortcuts triggering formatting/etc. type macros/python (8) some sort of print/formatting to yield output to pdf
        gamegoblin 3y ago

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.
    - emeril 3y ago
      I wish you luck, I can definitely appreciate the difficulty in trying to achieving some degree of excel feature parity I had come across this copy to more than one cell issue when I was curious to see the performance myself in making some random numbers and doing some look-ups based on those results which I couldn't do en masse due to this limitation a few other things to think about implementing (1) some more formatting/font/point size options (2) customizable number formatting like excel (3) functions like hlookup, edate, perhaps even array function like functionality (i.e., a relatively powerful and open ended underused feature in excel due to a combination of difficulty in understanding as well as being very slow calculation-wise) (4) some minimal vector drawing abilities (5) it doesn't bother me and it's part of your marketing but starting with "0" may confuse some people (and would break excel compatibility) since excel doesn't do that (though I appreciate indices/etc. do that in "real" programming) (6) filtering data doesn't include a "contain" or "does not contain" option (7) perhaps some limited ability to customize the interface and have user defined keyboard shortcuts triggering formatting/etc. type macros/python (8) some sort of print/formatting to yield output to pdf
      - gamegoblin 3y ago