Ask Your Question
1

'Invalid Sheet Reference' when attempting to create advanced filter

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

eggmatters gravatar image

updated 2017-08-11 03:49:32 +0200

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:

Student_id
=C5
    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: 5.1.6.2 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 close merge delete

Comments

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
0

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
0

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

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 24 times

Last updated: Aug 11