3 ms·

I feel the same about GDocs. And GSheets is just insane. I have mixed feelings about Google but they knock it out of the park with their drive tools.

LegitShady 4y ago
gsheets is hilariously slow compared to excel, once you start getting into larger files.
- m-p-3 4y ago
  Gsheets offers some formulas I found quite useful and would be a pain to replicate in Excel.
  - goatlover 4y ago
    Excel has lambdas now.
  - usr1106 4y ago
    Excel formulas have a horrible 1970:ish syntax. Reminds me of BASIC programming. But typically I get the job done, sometimes after several awkward intermediate steps. I wasn't aware that Google has a different one. I have never used more than simple sums and differences in Google sheets. Can you give an example where Google offers better, incompatible functionality?
    - m-p-3 4y ago
      For example, QUERY [1], SPLIT [2] and ARRAYFORMULA [3] are the ones that comes to mind. To be fair MS Excel can do arrayformulas, but I prefer GSheet's syntax. Last time I tried Excel, TRANSPOSE wasn't a thing it but it seems to be there now. [1]: https://support.google.com/docs/answer/3093343 https://support.google.com/docs/answer/3093343 [2]: https://support.google.com/docs/answer/3094136 https://support.google.com/docs/answer/3094136 [3]: https://support.google.com/docs/answer/3093275 https://support.google.com/docs/answer/3093275
  - LegitShady 4y ago
    excel is fully programmable with vba.
- randomsearch 4y ago
  Google docs is also reportedly terrible for working with sizeable documents.
- danielvaughn 4y ago
  gsheets lets me collaborate with others in real-time and share with others very easily. When you think about “performance”, you have to consider more than just the immediate steps taken while in the application. If you think about the entire end-to-end experience, gdrive is so much faster and seamless.
  - LegitShady 4y ago
    office 365 offers "co-authoring" and easy sharing as well. You're talking about something excel already has. But working on large files is ridiculously painful. It's just not as as good as a native app. I don't want to give up my ability to work on large files in a performant fashion, which I do all the time, in exchange for collaboration support I do occasionally but a worse overall experience and frustrating lag compared to a native application.

LegitShady 4y ago

gsheets is hilariously slow compared to excel, once you start getting into larger files.

m-p-3 4y ago
Gsheets offers some formulas I found quite useful and would be a pain to replicate in Excel.
- goatlover 4y ago
  Excel has lambdas now.
- usr1106 4y ago
  Excel formulas have a horrible 1970:ish syntax. Reminds me of BASIC programming. But typically I get the job done, sometimes after several awkward intermediate steps. I wasn't aware that Google has a different one. I have never used more than simple sums and differences in Google sheets. Can you give an example where Google offers better, incompatible functionality?
  - m-p-3 4y ago
    For example, QUERY [1], SPLIT [2] and ARRAYFORMULA [3] are the ones that comes to mind. To be fair MS Excel can do arrayformulas, but I prefer GSheet's syntax. Last time I tried Excel, TRANSPOSE wasn't a thing it but it seems to be there now. [1]: https://support.google.com/docs/answer/3093343 https://support.google.com/docs/answer/3093343 [2]: https://support.google.com/docs/answer/3094136 https://support.google.com/docs/answer/3094136 [3]: https://support.google.com/docs/answer/3093275 https://support.google.com/docs/answer/3093275
- LegitShady 4y ago
  excel is fully programmable with vba.
randomsearch 4y ago
Google docs is also reportedly terrible for working with sizeable documents.
danielvaughn 4y ago
gsheets lets me collaborate with others in real-time and share with others very easily. When you think about “performance”, you have to consider more than just the immediate steps taken while in the application. If you think about the entire end-to-end experience, gdrive is so much faster and seamless.
- LegitShady 4y ago
  office 365 offers "co-authoring" and easy sharing as well. You're talking about something excel already has. But working on large files is ridiculously painful. It's just not as as good as a native app. I don't want to give up my ability to work on large files in a performant fashion, which I do all the time, in exchange for collaboration support I do occasionally but a worse overall experience and frustrating lag compared to a native application.