3 ms·
The worst is google sheets API, which uses Javascript-based 0-indexing for some functions, but Excel-based 1-indexing for other functions. Nightmare!
by oarabbus_ 7y ago
The worst is google sheets API, which uses Javascript-based 0-indexing for some functions, but Excel-based 1-indexing for other functions. Nightmare!
- jandrese 7y agoI always love when you get a database query back into your 0 indexed language and the data is 1 indexed because that's how the database does it.
- mjevans 7y agoIt's trying to replace/inter-operate with Excel, so it has to maintain backwards compatibility; bug for bug, including design bugs. I couldn't tell you offhand if the logic you speak of is distinct to Sheets or if it's Sheets maintaining the same interfaces other spreadsheet software defined for those macro names long ago.