# Questions tagged [openoffice-calc]

OpenOffice's spreadsheet application. Tag questions about macro programming or formulas with macros or worksheet-function respectively

**0**

**1**answer

### LibreOffice Calc: How to use OFFSET Function when Selection Intervals should increase?

**0**

**1**answer

### Retrieve European Central Bank currency rates XML into LibreOffice Calc cells

**0**

**0**answers

### Libreoffice calc multiple horizontal window splits

**0**

**0**answers

### OpenOffice Calc understanding this user defined cell format

**0**

**0**answers

### How to use multiple if statements in open office calc

**1**

**1**answer

### Calc/Excel aggregating data with same ID

**0**

**0**answers

### In a LibreOffice Calc (or OpenOffice Calc) spreadsheet, how can you maintain multiple groups of columnar data?

**1**

**1**answer

### Conditional formatting in libre office calc

**0**

**1**answer

### In LibreOffice Calc, is it possible to use a complex function and a data range as arguments for a MIN() function?

**0**

**0**answers

### How do I keep just the first row of each unique occurence of a value in a column in LibreOffice Calc?

**0**

**0**answers

### How to set the color of the input bar in LibreOffice Calc spreadsheets (for dark theme/mode)?

**1**

**0**answers

### OpenOffice Calc: Is it possible to create conditional formatting to highlight a row based on checkmarks?

**1**

**1**answer

### Spreadsheet: Find Another Cell With The Same Value

**0**

**0**answers

### Can OpenOffice Calc AutoInput reference data on a different sheet?

**1**

**1**answer

### How can I escape commas in a CSV file?

**0**

**0**answers

### Is it possible to create a run chart (X=date, y=some numeric) in Calc where some specific dates are annotated or called-out in some way?

**0**

**1**answer

### Conditional formatting with Libreoffice Calc activated with a letter and the condition being applied to more than one cell

**0**

**0**answers

### Single Column, 1000's of Rows, Print as 2 Columns on Single Page

**0**

**1**answer

### Every time I open a csv OpenOffice Calc resets cell formating

**2**

**1**answer

### Both '.' and ',' for decimal separator in LibreOffice Calc?

**0**

**1**answer

### Runtime error when iterating over cells in LibreOffice Calc

**-3**

**2**answers

### How to subtract (compute delta) between two sheets?

**1**

**1**answer

### Is it possible to combine two IF(AND functions into one? (OpenOffice Calc 4.1.7)

**1**

**1**answer

### How to copy a new line from libreoffice calc to txt?

**0**

**1**answer

### How can I stop Open Office Calc from changing the data?

**0**

**1**answer

### Displaying values in a spreadsheet up to X days away from current date

**0**

**1**answer

### How to track frequency of multiple randbetween() outcomes in a single cell

**1**

**1**answer

### OpenOffice Calc import special characters in CSV incorrrectly?

**1**

**1**answer

### Is there any formula for OpenCalc which can count rows that contain some values but do not contain other values?

**1**

**2**answers

### Spreadsheet- How to update the value of the same cell

**2**

**1**answer

### OpenOffice Calc: Graph ON/OFF times

**0**

**1**answer

### Calc pie chart for 25000 rows with long tail

**1**

**1**answer

### Is there a way to average data that has a common value in a column?

**0**

**2**answers

### Calc print several sheets in same page

**0**

**1**answer

### Long Calc Sheet - subtotal at bottom of page, transfer to next page?

**0**

**0**answers

### Summing Euro amounts in Libreoffice calc

**1**

**1**answer

### Open Office Calc: How to find a set of values (like any digit) in a string?

**4**

**0**answers

### In LibreOffice Calc, how can I change the cell selection black ring to something lighter for dark backgrounds?

**1**

**1**answer

### How can I add duplicate rows to LibreOffice Calc to make there be one per day?

**-1**

**1**answer

### Is it possible to “countif” cell contain value of specific order?

**1**

**1**answer

### How do I lock some columns and some rows in a Libreoffice Calc worksheet?

**1**

**1**answer

### If cell contains value then 'Column header'

**2**

**0**answers

### Dropdown Lists in both Excel and Open Office

**6**

**2**answers

### Handle pasting of decimal with dot (1.7) when locale is expecting comma (1,7)

**2**

**2**answers

### Adding a percentage to every cell in a column in LibreOffice calc

**-1**

**1**answer

### Matching cell to a range and inputing matched cells corresponding cell

**0**

**1**answer

### Sync sheets in Libreoffice

**1**

**2**answers

### How to just add conditional formatting to a cell without overwriting the cell's direct formatting

**0**

**1**answer

### Match 2 values on excel / calc

**2**

**1**answer