Top "Openoffice-calc" questions

related to OpenOffice.

How to quote a quote with the CONCATENATE function in OOCalc

In OOCalc I want to use the CONCATENATE function to add quotes to each string in column A. So in …

concatenation openoffice-calc
How to add number of days to a date, consider only business days (i.e. ignore weekends)?

I'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 weekday
Join two spreadsheets on a common column in Excel or OpenOffice

I have two CSV files with a common column and I want to "Join" the tables together on the common …

sql excel openoffice.org openoffice-calc
How to prevent OpenOffice/LibreOffice Calc from changing what you input (data, numbers,...)

Basically, I want LibreOffice Calc to do what I tell it, not what it wants. For example: when I input 1.1.12, …

openoffice-calc
How to merge two columns in open office calc

I have two column in open office calc. I want to merge then like following name last name fullname john …

openoffice-calc
How do I concatenate cells and add extra text?

I'm very new to Calc but a relative veteran with Excel. Unfortunately I don't have the latter available to me. …

openoffice-calc
Change #N/A to Blank cell

How can I change the #N/A to the blank cell if nothing in that cell? Eg. =VLOOKUP(B19:B36;$…

openoffice-calc formulas
Applying a formula to all cells in a column, not just one at a time?

In OpenOffice.org Calc, I would like to apply a formula to a column that references a cell from the …

openoffice-calc
Highlight duplicate values

In Excel, Office 2007, I have the option to highlight duplicate values on the menu. Keep simple! Select the column, select "…

formatting duplicates openoffice-calc
Exporting CSV properly open Office (save numbers as TEXT)

I am using OPEN-OFFICE to work and save CSV. I am using the comma delimiter and ' " ' also. However, …

csv numbers delimiter openoffice-calc magmi