Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Google sheets with long names cause unpredicted errors #8

Open
lopezvit opened this issue Oct 21, 2024 · 0 comments
Open

Google sheets with long names cause unpredicted errors #8

lopezvit opened this issue Oct 21, 2024 · 0 comments

Comments

@lopezvit
Copy link

I got to your library from one answer in stackoverflow.com.
I was trying your code and it was giving an inexplicable error:

	Error	Error: No sheet name.
    at putError(ExcelApp:519:13)
    at getCommentsAsObject(ExcelApp:447:18)
    at getComments(ExcelApp:67:36)
    at getComments(SpreadsheetAppp:47:85)
    at convertCommentsToNotes(Code:14:23)

So I run the code without specifying the sheet name and tried to found out what the problem was, and I found out that if the Google Sheet spreadsheet name is longer than 31 characters, it will truncate the name to that size, so it won't be able to find the name in the Excel version.
I really think that fixing your code wouldn't be a big problem, but I don't have time atm to do so, so I simply ended up shortening the name of my sheets.

Best regards,
Alejandro

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant