related to OpenOffice.
In OOCalc I want to use the CONCATENATE function to add quotes to each string in column A. So in …
concatenation openoffice-calcI'm trying to create a formula to calculate the n-th Business Date (only Monday to Friday are business days). For …
excel date openoffice-calc dayofweek weekdayI have two CSV files with a common column and I want to "Join" the tables together on the common …
sql excel openoffice.org openoffice-calcBasically, I want LibreOffice Calc to do what I tell it, not what it wants. For example: when I input 1.1.12, …
openoffice-calcI have two column in open office calc. I want to merge then like following name last name fullname john …
openoffice-calcI'm very new to Calc but a relative veteran with Excel. Unfortunately I don't have the latter available to me. …
openoffice-calcHow can I change the #N/A to the blank cell if nothing in that cell? Eg. =VLOOKUP(B19:B36;$…
openoffice-calc formulasIn OpenOffice.org Calc, I would like to apply a formula to a column that references a cell from the …
openoffice-calcIn Excel, Office 2007, I have the option to highlight duplicate values on the menu. Keep simple! Select the column, select "…
formatting duplicates openoffice-calcI am using OPEN-OFFICE to work and save CSV. I am using the comma delimiter and ' " ' also. However, …
csv numbers delimiter openoffice-calc magmi