Top "Openoffice-calc" questions

related to OpenOffice.

How to save .ods spread sheet (OpenOffice.org) to .xlsx (MS Office Excel 2007)

Recently I switched from MS Office to OpenOffice.org 3.4.1. Here are my questions: I was not able to save .ods …

excel ms-office excel-formula openoffice.org openoffice-calc
Libreoffice/Openoffice Calc - append string to cells

I need to add .jpg at the end of all he cells in one or more columns 9788895249971 into > 9788895249971.jpg 9788867230129 …

append libreoffice openoffice-calc
Applying row based filter instead of column based in LibreOffice or other SpreadSheet tool

We all know the standard filter, where you pick which rows to show depending on values in a particular column (…

excel libreoffice openoffice-calc libreoffice-calc
highlight duplicate Value in Open Office org Calc

I am using OPEN OFFICE ORG CALC. I can't use MSOFFICE How can i highlight Duplicate value in a Column ? …

duplicates openoffice.org openoffice-calc
How to delete duplicates, but keep the first instance and a blank cell for the duplicates in OpenOffice Calc?

If I have data like: A B C 111 asdews iujfhg 111 oikufjf jasddaf 112 eifjfjc olkdkj 112 eiejdj olokjjfki 112 ioeiurjf oleodks 113 oeiekdkd poldkkmd …

duplicates openoffice-calc
How to identify duplicate values in two columns in Openoffice Calc

I have two columns that have numbers in them. The other has the numbers only once, when the other has …

openoffice-calc
Convert spreadsheet decimal number format: period- and comma-separated decimal positions

In OpenOffice Calc, one can change number format between standard United States, with decimal separator being a period ., and the …

google-sheets number-formatting openoffice-calc
How to find duplicates values and keep only those rows?

I am checking an huge Open Office Calc list on multiple values in column C. I have a file like …

duplicates openoffice-calc
How to split a single word separated by space form single column into two columns

I am having the following records in column A Column A 4.0K 0000000.png 4.0K 0004.png 32K 00(1).gif 16K 001.gif My …

openoffice-calc
LibreOffice Calc / OpenOffice Calc: How to filter rows based on their background color?

I'd like to filter out rows with a specific color on a specific column. I tried to search nearly everywhere …

openoffice-calc libreoffice-calc