# Tagged Questions

**0**

votes

**1**answer

15 views

### how to get cell number as a result of a function

i need to get № of a cell that contains the result of MAX(J4:J24) and write a word from the same row instead of the actual max number
the word can be written i guess via =INDIRECT("A"&formula ...

**0**

votes

**2**answers

33 views

### Convert named months date text to date

I have a date text with named months like this
06:29 Mar. 17 2014
I tried this but obviously I need to convert Mar to a number
=DATEVALUE(RIGHT(G1, 4) & "-" MID(G1,7,3) & "-" MID(G1,12,2))
...

**0**

votes

**0**answers

43 views

### updating links in LibreOffice Calc xlsxfile results in err:509

I have just started to use Libreoffice so I am totally new to the system and immediately encountered a problem with a calc document.
The document has originally been made in Excel (but on a Mac) and ...

**0**

votes

**1**answer

208 views

### How can I use indirect references for a pivot table's data source?

(This question is mostly about Excel, but it's also relevant for LibreOffice Calc, so I welcome answers about either.)
I have this sheet with many rows, some of which only become relevant at certain ...

**2**

votes

**1**answer

198 views

### Excel/Libreoffice returning TRUE for IF() instead of expression

See the following situation:
For some
Here cells A1:E3 have plain text data (no formulas), and C4:E4 have the same formula (i.e. typed in one cell and then autofilled to another ones).
I wanted ...

**2**

votes

**2**answers

52 views

### How to autofilter for given strings in common spreadsheet softwares?

I know I can create an "autofilter" at the top of an XLS table.. But how can I create a filter that filters for given strings?
example TABLE input:
LASFD@FOO.COM
LKXYCVER@FOO.COM
...

**1**

vote

**1**answer

72 views

### How can i reset my Libre Office Calc setting

I am using Libre Office Calc for my Excel work.
Image 1:
Image 2
I can not see the format color in on Libre office installed @My System.
but on my Colleague System who uses the same Libre ...

**0**

votes

**1**answer

1k views

### MS Excel Vba/Macro equivalent in LibreCalc or OpenOfficeCalc

is there an equivalent macro/vba in libre calc that does this routine;
- Read/open xls files in a path and do a batch import/copy of read sheets and merge it with the current open workbook.
Here's the ...

**0**

votes

**1**answer

433 views

### How can I use extremely large numbers in my spreadsheet programs?

If I try to calculate large exponents in LibreOffice Calc or OpenOffice.org Calc, the results come out to be erroneous. See these two examples where I calculate 13^18,
Using LibreOffice Calc
Using ...

**1**

vote

**3**answers

1k views

### What Excel formats are (most) compatible with LibreOffice and Google Docs? [closed]

I use Excel (and occasionally Numbers), but I want to be able to share with users of Google Docs and LibreOffice (and I may want to switch in the future). What's the most compatible format to save my ...

**3**

votes

**3**answers

1k views

### How do you find the maximum value in a column, skipping to every nth value?

Using LibreOffice's Calc program (nearly the same functionality as Microsoft Excel) I have a set of numbers in column T, which represent numbers for the week (with labels in S). Each week's worth of ...

**5**

votes

**5**answers

846 views

### Does any spreadsheet allow you to create your own functions?

I've always been frustrated when using spreadsheets by the inability to define my own functions when there is no existing function to (cleanly) do what I want. Does any spreadsheet offer this ...

**5**

votes

**4**answers

56k views

### How to open ods files in Excel?

What is the best way to open ods files in Excel 2003?
Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)?
The file I ...

**2**

votes

**2**answers

7k views

### How can I print Excel spreadsheet files automatically?

My company has computer-generated reports that come out as Excel spreadsheets which are emailed to the Billing Department. They would like these reports to be automatically printed as they are ...

**2**

votes

**3**answers

1k views

### Excel / open/libre office formulae: number of full months left until date

I need a formula which equates to an integer value for the number months left until a set date (2011-10-16) based on the current date.
e.g.
on 2011-03-13 the answer would equate to 8
on 2011-03-17 ...