We're currently migrating from Ask to Discourse, read the details here

Ask Your Question

'Invalid Sheet Reference' when attempting to create advanced filter [closed]

asked 2017-08-11 03:22:38 +0200

eggmatters gravatar image

updated 2020-08-18 13:26:13 +0200

Alex Kemp gravatar image

I keep getting the above error. In order to demonstrate, I created a basic sheet and tried to filter on it:

I've < 3 points so the screenshot I have will have to wait. Once I dismiss the above dialog, I also get a "This range does not contain a valid query" The folowing is my sheet:

    Key Student_id
    IVPW    502694
    IVPW    502011
    IVPW    502010
    IVPW    502695
    IVPW    503335
    IVPW    502697
    IVPW    503336
    IVPW    503714
    \ Sheet2 /

For the filter cell, I've tried basic formatting etc.

Student IDs column range is C5:C12. Filter cell is C3.

image description

Go to Data->More Filters -> Advanced Filter Click on filter cell C3. This populates the "Read Filter Criteria From" field with: $Sheet2.$C$3

Click "OK"

Above errors are thrown.

Trying very basic filter values is not working either (i.e. ='502694', >0 etc.)

The sheet above was pasted in from data in an adjacent sheet. The origin was an Excel document, converted to ODF.

Thank you for your time reviewing this.

The dialog title is "LiberOffice 5.1 About Version info:

Version: Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2 CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; Locale: en-US (en_US.UTF-8); Calc: group

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-18 13:27:20.354833


Hello @eggmatters, i upvoted your question so that you can upload your screenshot.

librebel gravatar imagelibrebel ( 2017-08-11 03:41:22 +0200 )edit

Thank you! Will do presently.

eggmatters gravatar imageeggmatters ( 2017-08-11 03:48:50 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-08-11 04:10:16 +0200

librebel gravatar image

Hello @eggmatters,

Advanced Filter expects a range that contains the filter criteria (including the field name), in your example that would be $Sheet2.$C$2:$C$3. Hope this helps, lib

edit flag offensive delete link more


Hey! That made the error go away. I'm not seeing the filter actually filter anything though. Shouldn't it be only showing me rows that match the filter criteria?

eggmatters gravatar imageeggmatters ( 2017-08-11 07:06:00 +0200 )edit

answered 2017-08-11 10:01:01 +0200

m.a.riosv gravatar image

Looks the data range selection includes the filter. Please select firts the data range and try the filter as commented by @librebel.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-08-11 03:22:38 +0200

Seen: 2,137 times

Last updated: Aug 11 '17