× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2014-04-23T17:58:36Z  · last modified 2014-06-30T18:04:40Z

MS Excel - Result from range of values in Excel is incorrect


Priority Major
Complexity Unknown
Component DB - Excel
Version 15.0
Version: 15.0.0-dev-247
Build #: 37464
Build Date: 2014-Apr-22 07:36:33 AM
 
MS Excel - Result from range of values is incorrect
 
1.  Open attached Excel in a query window and execute the below 3 queries
2.  When user specifies the range exactly according to the Excel $E6:N9 in the from clause, NO results are shown in the grid
3.  When user ignores the black lines and give the range as in $E1:N9, the column names are included in the result.
4.  The one query in which it returns is query#3, but then the range is $E2:N9
 
SELECT * FROM "baseball".TEST$E6:N9
GO
 
SELECT * FROM "baseball".TEST$E1:N9
GO
 
SELECT * FROM "baseball".TEST$E2:N9
GO
 
See attached screenshot
 
 
 
3 attachments

Issue #11929

Closed
Fixed
Resolved 2014-06-27T23:14:02Z
 
 
Completion
No due date
Fixed Build 15.0-dev-351
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017