To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66588
------- Additional comments from [EMAIL PROTECTED] Wed Jun 28 03:47:24 -0700 2006 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]