New issue
Advanced search Search tips
Note: Color blocks (like █ or █) mean that a user may not be available. Tooltip shows the reason.

Issue 770426 link

Starred by 1 user
Status: WontFix
Owner: ----
Closed: Oct 2017
Cc:
mastiz@chromium.org
█ tschumann@chromium.org
Components:
EstimatedDays: ----
NextAction: ----
OS: Windows
Pri: 2
Type: Bug-Regression



Sign in to add a comment

Spreadsheet INDIRECT/Named Ranges stop function

Reported by jgonzal...@asci-automation.com.mx, Sep 30 2017 
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36

Steps to reproduce the problem:
1. In spreadsheet name a range
2. Use that NamedRange in a INDIRECT() function example [=INDIRECT("Range_01")]
3. 

What is the expected behavior?
Get the value of the referenced range

What went wrong?
#!REF! Error

The parameter 1 value of indirect function is "Range_01". It is not a Cell/range valid reference.

Did this work before? Yes 60.0.3112.113

Chrome version: 61.0.3163.100  Channel: stable
OS Version: 10.0
Flash Version:
indirectError.png
4.7 KB View Download

Comment 1 by pav...@chromium.org, Oct 3 2017

Status: WontFix (was: Unconfirmed)
This issue is related to Google Sheets, please report it in Sheets through "Help" => "Report a problem" menu.
Additionally you can check if this issue is already discussed on product forums (https://productforums.google.com/forum/#!topicsearchin/docs/Named$20range)
►

Sign in to add a comment