Top "Openoffice-calc" questions

related to OpenOffice.

Python, OpenOffice: Programmatically Manipulating spreadsheets

I have an spreadsheet-based automated report that needs to be created daily, with some charts, aggregating functions (e.g. SUM …

python excel openoffice-calc
Row numbering selection auto-fill till the end

I have a table with thousands of lines. I want to number rows by adding 1 2 3 next to first rows, then …

excel libreoffice openoffice-calc
Search and replace regular expression in Open Office calc

I've got something like this (in Open Office Calc): Streetname. Number Streetname. Number a etc. Now I want to delete …

regex openoffice.org expression openoffice-calc
How to set cell-color according to cell-value on ooo-calc?

I can change the style of a cell using conditional formatting. But there I would be limited to a maximum …

visualization data-visualization openoffice-calc
Reading Openoffice Calc (.ods) programmatically using c#?

I want to know if it is possible to read OpenOffice Calc spreadsheet programatically with c#, I can do this …

c# xml openoffice.org openoffice-calc uno
How to keep leading zero and add comma in openoffice calc formula?

I have 6 fields in a row in open office, the 1st is a word, the 2nd, 3rd, and 4th are …

openoffice-calc openoffice-basic
How Compare two sheet in open office and mark different value with color

In first sheet original data and in second modify data so i want to compare both sheet data and mark …

openoffice-calc
Merging data in Open/LibreOffice Calc

I have two sets of data in .csv format which share a field called sku. The second one has additional …

csv openoffice-calc
Finding the mean and standard deviation of a data column in OpenOffice Calc

I have several data columns with 400 to 500 entries in each in a Calc spreadsheet. For each of these columns, I …

openoffice-calc mean standard-deviation
How can I get a random cell in OpenOffice Calc?

I've perused the Stack Exchange list of sites, and I can only think that SO is the right place to …

formula worksheet-function openoffice-calc