Unkown Function returning #NAME?
- Dominant language
- Python
- Stars
- 7.5k
- Forks
- 979
- PR merge metrics
- No merged PRs in 30d
Description
Hello,
I was just using some lines of code like this one: wks.update_acell('A1', formula), and had worked fine. but now I'm using a different formula =googlefinance("petr3"; "price"; DIATRABALHO(HOJE();-10);HOJE()).
But the Sheet returnin the following error: "unkown function DIATRABALHO", but that function it's correct, even when I put the same formula directly into the sheet, it work fine.
What can I do this work just using update_acell ??
Contributor guide
Research direction
Start with the update_acell entry point and compare how the supplied Google Sheets formula is sent with a formula entered directly in the sheet. Check whether the locale-specific function and separators are preserved, then verify the behavior with a minimal formula reproduction; done means the formula works through update_acell without the unknown-function error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- api
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100