Hacker News new | ask | show | jobs
by reportgunner 2354 days ago
For me, Google Sheets don't have the signature features of Excel, it's like Excel lite.

No VBA, no keyboard shortcuts, (no cross-workbook references).

Imho two people working inside the same worksheet at the same time was never an Excel's missing feature.

1 comments

> No VBA

FWIW Google Sheets does have the ability to write macros in JavaScript. They even have an npm tool [0] that will let you edit offline via your preferred IDE and then push to your sheet.

[0] https://developers.google.com/apps-script/guides/clasp

I'm not saying JS is better or VBA, but JS is definitely not VBA.
Gsuite uses 'Apps Script'[1], not pure JS, so it is quite similar in function to VBA.

[1]https://developers.google.com/apps-script