tags:

views:

183

answers:

0
Q: 

Openoffice Calc Set operations

Let us say that we have two columns in a spreadsheet. Is it possible to perform set operations on the two columns and save the result in a third column?

For eg.

Col1  Col2  Col3
---------------------
A     B     A
C     D     F
F     C
D

Here Col3 = Col1 - Col2 where "-" is a set operation. Is there a way to do this in Openoffice Calc?

related questions

Win32 ShellExecute and a UNC Path
Tool to reformat xml-comments (Visual Studio 2008)
Excel - Macro to conditionally copy rows to another worksheet
Excel Macro Help
MS Word: How do I create a shortcut or toolbar button for the "Paste Special..Unformatted Text" option?
How can I find last row that contains data in the excel sheet with a macro?
How can I refresh all the pivot tables in my excel workbook with a macro?
Writing a ++ macro in Common Lisp
is there a way to write macros with a variable argument list in visual C++?
My first Lisp macro; is it leaky?
How do I save each sheet in an Excel workbook to separate CSV files with a macro?
How do I keep RecipientTime when executing MailItem.Move in an Outlook macro?
How do I assign a keyboard shortcut to a VBA macro in Outlook 2007?
Modifying a spreadsheet using a VB macro
How to disable Visual Studio macro "tip" balloon?
What are the best keyboard macros for programming in windows?
good directory picker for visual basic macros in MS Outlook (2007)
VS2008/TFS: Get Latest of solution from command line or macro
Helpful snippits?
How to enable the TRACE macro in Release mode?
How do you create a debug only function that takes a variable argument list? Like printf()
Do you have any recommended macros for Microsoft Visual Studio?
[ADO.NET] What's the deal with |Pipe-delimited| variables in connection strings?
Visual Studio 2005 Macros stop working when Visual Studio 2008 is installed
How far can LISP macros go?