# Questions tagged [spreadsheet]

Questions about spreadsheet software in general and interoperability between spreadsheet programs.

**0**

votes

**3**answers

1k views

### Any examples of a complex, changeable system modelled with a spreadsheet?

When I asked this question using games as the example (hoping it would be more likely to have been done), it was closed as being off topic so let me ask it this way...
Has anyone used a spreadsheet ...

**0**

votes

**2**answers

934 views

### Spreadsheet formula: lowest 100 values in a range

Is there any way I could sum up the lowest 100 values within a range?
I know that min() would give you the lowest value but i need something to return the 100 lowest values.
I just used 100 ...

**1**

vote

**3**answers

1k views

### How can I detect if a range of cells contains only identical values or not in Excel?

I have a range of cells and I want a formula that says if all these contains the same values or not.
Usually for two cells I would use if but I want a solution that would work for ranges. I don't ...

**1**

vote

**1**answer

485 views

### Store Solver's metadata in OpenOffice's SpreadSheet

How can you save the metadata of OpenOffice 3.0's Solver?
I do not want to add the conditions each time I open a file in OO's SpreadSheet.
Excel by contrast saves the Solver's Limiting conditions.

**6**

votes

**2**answers

20k views

### How do I test if a cell in OpenOffice Calc contains #N/A?

I'm using the VLOOKUP function to lookup values in a column based upon a search query. But since it's not a given that a value always exists for my search parameter, sometimes VLOOKUP returns #N/A.
...

**0**

votes

**3**answers

295 views

### Apply a formula to particular cells in Microsoft Excel

Say I have the following sheet:
| A | B | C |
1 | 5 | 1 | 5 |
2 | 8 | 8 | 99 |
3 | 77 | 3 | 3 |
4 | 2 | 7 | 4 |
5 | | | |
6 | Base:| 2 | |
...

**4**

votes

**1**answer

1k views

### Read data from separate CSV file in OpenOffice Calc

I have a very large CSV file (many thousands of rows) that I want to work with. Due to the size of the file, I don't want to import it into openoffice. Rather, I want to create a spreadsheet that ...

**1**

vote

**4**answers

2k views

### How to prevent truncation of 0 in Excel sheet?

I am copying tabular data from a website: [http://www.infodriveindia.com/TradeResources/STDCode.aspx?STDCode=&City=&State=andaman][1]
But it pastes the numeric value by truncating the ...

**4**

votes

**4**answers

56k views

### How do I open or convert a Microsoft Works .XLR spreadsheet to an Excel compatible format?

I have been sent a Microsoft Works XLR spreadsheet and Excel will not open it.
Is there any way of opening an XLR file directly in Excel?
Can anyone recommend a (free) tool for converting to an ...

**4**

votes

**2**answers

4k views

### Count cells based on text content (Gnumeric)

I have a spreadsheet with columns that are basically booleans, they contain either "Yes" or "No", I want a total count of all the cells in a range that are "Yes".
I imagine this would be done ...

**0**

votes

**1**answer

277 views

### Is there a freely available source for VisiCalc documentation?

I am looking for a freely available online document with instructions on how to use VisiCalc

**1**

vote

**3**answers

1k views

### How do I read old star office 5.x spreadcheet documents today? (*.sdc)

I found a couple of old spreadsheet documents that I created a couple of years ago that I would like to read again.
I think I used the old Star Office 5.2 to create those Spreadsheets.
They all ...

**5**

votes

**4**answers

6k views

### Excel annoyance: How to maintain formulas in a ledger?

A common use of Excel is to create a spreadsheet which functions as a transaction ledger of some kind, where one or more fields in each row is calculated by adding a value or values from the current ...

**7**

votes

**2**answers

12k views

### In Open Office, make 1st row of data “scroll lock” so it is always visible as you scroll down?

In Open Office, how do you make the first row of data "scroll lock" so it is always visible as you scroll down?

**13**

votes

**6**answers

117k views

### Select each nth row in Excel

I have an Excel spreadsheet with thousands of rows. I want to select every 7th row from that spreadsheet. (By "select," I mean delete all of the other rows, or copy the selected rows into a new ...

**0**

votes

**1**answer

457 views

### Using “less than or equal” in IF statement in NeoOffice Calc

How would I call a "less than or equal" function in an if statement in Mac NeoOffice Calc?

**2**

votes

**4**answers

1k views

### AutoComplete interferes with Tab and Enter in the OpenOffice Spreadsheet

When I have a large data-entry task, I like to uses tab to move to the next cell in a row, and enter to move to the beginning of the next row. When I type into a cell and OpenOffice can autocomplete ...

**4**

votes

**1**answer

285 views

### Is it Possible to not copy all 65,537 cells when copying a column in Open Office

I'm using Open Office 3.01 on OS X. When I select an entire column of data by clicking its header, and the copy that to the clipboard, Open Office appears to copy all 65,537 cells to the clipboard. ...

**1**

vote

**4**answers

1k views

### Automate Reading Lotto Numbers

When we buy a large qty of Lotto tickets, is there a way to read all those numbers into a spreadsheet so that they can be checked against the winning numbers thru formulas/macros?
I am looking for an ...

**0**

votes

**1**answer

2k views

### Error 502 in OpenOfficeSpreadsheet formula

The formula failing is the following:
=IF(TIMEVALUE(C2 & ":00") > TIMEVALUE(B2 & ":00"); 0; C2-B2)
I previously tried
=IF(C2 > B2; 0; C2-B2)
but this also gives me "Error 502".
The ...

**5**

votes

**6**answers

28k views

### Where can I find some dummy data to teach my friend how to use a spreadsheet? [closed]

In particular, tabular data that can be graphed. What's your favorite source of interesting data?

**2**

votes

**1**answer

1k views

### In Google Docs, how to create a form that can store the data entered into it in an excel sheet automatically?

The title pretty much says it all.
I need to create a poll wherein I need to ask the users some questions.
How can I do it using Google Docs? How will I access the data entered after that?

**1**

vote

**4**answers

755 views

### Lotus Symphony - Open document in new window

Does anyone know how to open a document in a new window instead of a new tab in Lotus Symphony? I would like to compare two spreadsheets and can not figure out a way to display them side by side. I ...

**4**

votes

**2**answers

29k views

### What's the difference between “vlookup” and “lookup” in Excel?

What is the main basic difference between VLOOKUP and LOOKUP in Excel?
I read the main point is that you can specify a range of columns in VLOOKUP and then pick one to return the value. However, it ...

**16**

votes

**3**answers

26k views

### OpenOffice: Delete rows based on cell value

I've got a rather large spreadsheet that I need to filter some rows out of. In the spreadsheet, all rows whose M-Column doesn't equal "on" must be removed. I applied a filter, and re-saved the ...

**0**

votes

**1**answer

8k views

### Excel - creating a master template?

Sorry for my second Excel question in as many days! Almost there now though :)
I've created a template for an invoice for my mum... is there anyway I can sort of lock the file, and create sub ...

**1**

vote

**3**answers

3k views

### How can I use the Excel PMT function to calculate a mortgage payment?

The formula wizard asks for:
Rate, NPER, PV, and FV.
I have the following info:
I guess the rate would be the annual interest rate (say 5.5%) divided by 12, or 0.48%.
NPER is the number of periods,...

**3**

votes

**4**answers

13k views

### How can I copy a formula multiple times and always refer to the same cell?

I have a number in cell A1 and a column of 20 numbers in the B column.
I'd like to put a formula in each of the cells in the C column next to each number in the B column. Let's say it's =B1-A1, and ...

**5**

votes

**4**answers

12k views

### Make Excel 2003 Open Spreadsheets in new instances

In Excel 2003, It seems to be putting each spreadsheet I open into the existing Excel application as a new window. this makes it very difficult in a dual monitor set up to put one spreadsheet on each ...