https://bugs.documentfoundation.org/show_bug.cgi?id=168149
Bug ID: 168149
Summary: Want the ability to apply SQL queries to a selected
range
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: needsUXEval
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 108443, 120062
One of the shortcomings which has always bothered me with MS Excel, and then
Calc, is that it puts the ability to apply complex queries to data far away
from the user. While you can kinda, sorta, somehow, make it happen (there is
some sort of embedded DBMS in there after all, right?) - it is certainly not
easily accessible.
It would be quite useful if a user could select a range of cells, and
considering it as a relational table - apply an SQL query to it, with the
results populating a new sheet or someplace else on the same sheet.
There can be a lot of bikeshedding here: How this table should be named,
whether to consider the first row to contain column names, what to do with
repeated records, what dialect of SQL to use, whether the query is remembered
after use or not, whether the results are dynamically linked to the source or
not (maybe both options are interesting) and so on and so forth.
But we could put ourselves squarely ahead of MS Excel for this aspect of data
anlysis if we were to offer this functionality.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108443
[Bug 108443] [META] Database query bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=120062
[Bug 120062] [META] Database related bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
