Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | SQL-Statements within Calc (not using external data sources) | ||
---|---|---|---|
Product: | Calc | Reporter: | discoleo <discoleo> |
Component: | code | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | ahz001, issues, kami911, kozodaevroman, kyoshida, pagalmes.lists, www.openoffice.org |
Version: | OOo 2.0.2 | Keywords: | oooqa |
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | FEATURE | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
discoleo
2006-06-20 13:05:14 UTC
SQL-Statements in Calc (Additional Comments/Features) ----------------------------------------------------- There is another powerful advantage for such an SQL-statement. It will allow (beyond the offered standardization) for an easy automation of complex processes (this is indeed one of the reasons why SQL has been developed). I also thought about an extension to this SELECT statement: SELECT ... INSERT INTO NEW 'new worksheet name' COPY AS 'value'/ 'original' / 'reference' / 'HARDLINK' - value: evaluate the original cell content (IF it contains a formula) and copy the computed value - original: if the original cell contained a formula, insert this formula into the new cell - reference: insert a reference to the original cell (i.e. ='original worksheet'.'original cell') - HARDLINK: similar to reference, but make a hard link (like in UNIX environments, see also my issue about HARD LINKS http://qa.openoffice.org/issues/show_bug.cgi?id=66817 ); this would copy any changes made in this cell back into the original cell one for requirements This is very welcome RFE indeed. All that pesky filters, advanced filters and data pilot can be easily implemented on top of "build-in SQL" functionality. And 'raw' sql can be extremely useful for advanced users. I would welcome target milestone for this RFE. Good idea! SQL = best platform for data manipulations. And it could be a good bridge from Calc to Base. |