burnash / burnash/gspread

Unkown Function returning #NAME?

Open
#504 5 comments 0 reactions 0 assignees View on GitHub
TTL
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.