appendRow's input type should be any[] typed in google-apps-script.spreadsheet.d.ts

[enuchi]

appendRow's input type should be any[] typed in google-apps-script.spreadsheet.d.ts

[enuchi]

Hi @ieow @jsbrain I updated this package addressing the issues you mentioned and republished as [email protected].

PR with changes here: enuchi/gas-types-detailed#2

Sorry for taking a while on this one. Please reopen if you find other issues with the package.

[ieow]

same issue for the method getSheetValues. It should be returning any[][] instead of object[][]

https://github.com/DefinitelyTyped/DefinitelyTyped/blob/master/types/google-apps-script/google-apps-script.spreadsheet.d.ts
line 1863 and 1697:
getSheetValues(startRow: Integer, startColumn: Integer, numRows: Integer, numColumns: Integer): any[][];

[enuchi]

Hm thanks for pointing out. I made a fork that has more detailed docs: https://www.npmjs.com/package/gas-types-detailed

But it may have mistakes, as you pointed out. For now you can remove this package and install @types/google-apps-script, and you may be able to get more up-to-date type definitions.

[ieow]

I forgot to mention that I was planning to file the issue at github.com/enuchi/gas-types-detailed
but I got 404. So I can only file it here.
Sorry for the lack of info

[ieow]

additional finding.

in google-apps-script.base.d.ts
line 14

interface Blob need to extend BlobSource

    interface Blob extends BlobSource {

[enuchi]

Sorry, I had it as private. I just made it public -- can you add issues and/or feel free to open a PR there:
https://github.com/enuchi/gas-types-detailed

See this thread and fork on how to generate the docs in case that needs to get updated:
PopGoesTheWza/dts-google-apps-script#2
https://github.com/enuchi/dts-google-apps-script/

[jsbrain]

There's a DefinitelyTyped types package available. So running npm i -D @types/google-apps-script and changing tsconfig.json to

{
  "compilerOptions": {
    "types": ["@types/google-apps-script"],
    "jsx": "react",
    "esModuleInterop": true
  }
}

works just fine. Ideally this might be changed in the repo altogether?

[enuchi]

I created gas-types-detailed to include full descriptions on each class/method from the official Google docs. However it is out of date and probably some of the types are wrong/missing.

DefinitelyTyped's @types/google-apps-script doesn't have descriptions but the types are more likely to be accurate and up to date.

[jsbrain]

Yeah I just realized that even though the name suggests it. My bad but thanks for the heads up!