Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [spreadsheet]

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

0
votes
3answers
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
2answers
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
3answers
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
1answer
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
2answers
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
3answers
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
1answer
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
4answers
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
4answers
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
2answers
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
1answer
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
3answers
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
4answers
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
2answers
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
6answers
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
1answer
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
4answers
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
1answer
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
4answers
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
1answer
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
6answers
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
1answer
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
4answers
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
2answers
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
3answers
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
1answer
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
3answers
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
4answers
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
4answers
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 ...