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

learn more… | top users | synonyms

0
votes
0answers
38 views

Chart from groupings

Given such a spreadsheet: col1 | col2 | col3 -----+------+---- alfa | foo | 10 beta | foo | 20 gamma| bar | 12 delta| bar | 42 I'd like to generate a chart grouping values from col2 and ...
6
votes
1answer
259 views

Swap rows in gnumeric

Is there any convenient way to swap two rows in gnumeric? Currently I'm doing it the hard way: insert an empty row, move rows, and remove empty row. I hope that there is a better way...
0
votes
1answer
88 views

Add another worksheet in an Excel worksheet

Is it possible to include an additional set of worksheets (i.e. "tabs") into an already existing worksheet in Excel?
3
votes
3answers
3k views

Adding a constant in LibreOffice Calc

How do you add a constant to a group of cells in LibreOffice Calc? For example, here are four cells: 47 28 35 62 Now add 3 to each cell: 50 31 38 65
1
vote
1answer
128 views

Not showing negative results in Numbers.app

How can I make iWork Numbers not show me negative results? For example: The thing is that in A1 I have number 101 and I am doing -A1 from B1. B1 is empty (because I am waiting for the result) so in ...
0
votes
5answers
1k views

Good tools to visualize spreadsheets?

I have a few CSV and XLS files that I would like to analyse or "visualize" online (like in charts etc). I tried Google Fusion Tables, but I want to know if there are any alternatives. Also suggest ...
0
votes
2answers
397 views

Excel Pivot Table or VLOOKUP

Students have an ID, Name, and English Level in one spreadsheet. They have an ID and achievement on a standardized test on another spreadsheet. I need to match the ID's and put the English level ...
1
vote
2answers
568 views

Image file to spreadsheet

I want to take an image file (eg tiff) and convert it to a spreadsheet (csv, or whatever) such that each pixel becomes a cell with a numeric value for that pixel. I have googled it, and everyone is ...
2
votes
1answer
577 views

Copy only cell content in OOCalc

In OOCalc, when I copy a cell with ctrl-c ctrl-v, it copies everything, also the style, from source to destination. However, I want to copy only the content, leaving the formatting of the destination ...
2
votes
1answer
5k views

How to conditionally highlight cells in OpenOffice Calc?

I have a big chunk of data in an OpenOffice spreadsheet. To make real information standout more, I would like cells with an absolute value over a certain threshold to be highlighted in red. Is there ...
0
votes
1answer
182 views

Software to calculate average payments of the house

I want to calculate average payment of the house for every month, the average expense of each month. However, most of the fee is across months, they charge every 3 or 2 months. These are normal bills, ...
5
votes
8answers
3k views

Excel spreadsheet bogged down, Is there an alternative software?

I work for an organization with a yearly budget that is an Excel spreadsheet consisting of about 25 large sheets that are linked to one another. There is a big summary sheet that draws it's numbers ...
0
votes
2answers
1k views

How to add a line between every two rows in a spread sheet?

I was wondering in Openoffice Calc spreadsheet, how to add a line between every two rows? I want to print a spreadsheet, with a line separating every two rows. Thanks and regards!
0
votes
1answer
6k views

Excel formula to find frequency of occurrence of unique words in a column

I have a spreadsheet with a column with repeating number of different kinds of words like A1 A2 A3 A1 AA A2 A7 A8 A1 Now I want to plot a graph showing the frequency of occurrences of a word. The ...
0
votes
3answers
130 views

Re-ordering data in a cell in spreadsheet

I have an Excel spreadsheet where data is time stamped, but the time stamp is as follows (in one cell): Fri Mar 11 If it was 11 Mar Fri, the data would be easier to sort. How do I change the ...
1
vote
3answers
188 views

Excel plot chart from data as given in the example

I have a huge spreadsheet with simple data as follows 13:04:28 A 13:04:37 A 13:06:56 B 13:07:03 B 13:07:10 C 13:07:18 C 13:07:23 C 13:07:28 C 13:07:33 C Basically ...
3
votes
2answers
417 views

How do I access the search functionality in Open Office?

I am very new to oo and plodding slowly; never used a spreadsheet, etc.etc. I downloaded a document of botanical names for flowers/herbs, etc. The page was set in 3 columns and was 138 pages long (!) ...
4
votes
1answer
758 views

Edit spreadsheet object in Word document with protection

I am trying to create a template in Word to be used on a SharePoint site. Using Word 2003, is there a way to enable protection on a document that has an Excel Spreadsheet (97-2003) object on it but ...
0
votes
1answer
419 views

Excel filter by range

I am setting up a workout schedule. I have multiple rows with workout times, who is instructing the class, and who the class is suitable for. The suitable is a range, based on the following (anyone ...
0
votes
3answers
839 views

Do multiple e-mail addresses need to be separated by a comma?

In CSV format, in an Excel spreadsheet or in a Word document, both having multiple email addresses with each address being in its own row and in a single column, is a comma REQUIRED after each ...
19
votes
5answers
60k views

How to create a formula for every row in a column in Google SpreadSheet?

I use three columns. A, B and C. In column C I have a formula every row =A1*(1.6*B1) and then for the next row I have =A2*(1.6*B2) in C2. How can I do so I don't have to type in the new formula in ...
1
vote
2answers
1k views

Data validation - populating a drop down menu using a defined name

I am using data validation to create a drop down list on a worksheet. What I'd like to be able to do is set up a list of values as a defined name (Insert > Name > Define...) and then enter that ...
1
vote
1answer
4k views

How do I count the times each number appears in columns of numbers?

I am sure this must be easy, but I am inexperienced. About the best way to think of my problem is to think of it as trying to sort and then count lottery numbers. To stay simple, let's do a Pick 3 ...
2
votes
1answer
1k views

Quick/Small Spreadsheet Software

There is some minimalist spreadsheet (excel-like) software? I imagine something like NotePad (small and quick) just to write some tabular data quickly. No toolbars, no font formatting, not "a lot" of ...
1
vote
2answers
7k views

Big Excel File Freezing/Running Slowly

My co-worker has a very large Excel file (over 7 MB) that suffers from the problems of (A) running slowly (B) taking forever to open/save/close and (C) freezing the computer, requiring a restart. I ...
1
vote
3answers
4k views

Combine 3 columns into one in Excel 2011 for Mac

I am trying to manipulate a bunch of string elements I have put in columns in Excel. I then filled the preceding column with data, and then the following column as well. Now I want to delete the ...
3
votes
1answer
1k views

Open Source Spreadsheet with Sensitivity Analysis

Is there any good Open Source spreadsheet program that has a solver for linear programs (either included or via an extension) that does a proper sensitivity analysis (shadow prices etc)? It seems like ...
4
votes
4answers
891 views

Spreadsheet forumula questions to pick a random DVD

I have a list of my (279) DVD’s in an OpenOffice Spreadsheet (version 3.3.0) on my Windows 7 laptop and I want to create a formula to randomly pick a film to watch (for occasions when I can’t make up ...
4
votes
1answer
796 views

Custom CSV (.csv) filter for OpenOffice.org or LibreOffice?

Is it possible to create a some kind of 'custom CSV filter' for OpenOffice.org or LibreOffice spreadsheet program. What I need is to have the program to use predefined CSV settings for loading and ...
1
vote
6answers
18k views

In Excel, copying cell *values* (not formulas)… yet keeping the cell formats

I have an Excel spreadsheet with multiple worksheet tabs for collecting data... and a final tab with a lot of formulas, to summarize the other tabs for a given date range. The goal is for the ...
2
votes
1answer
2k views

In Excel, doing a “Freeze Panes” on the right-most column instead of the left-most?

My understanding of Excel's "Freeze Panes" feature is that you can only freeze the left-most column(s), or top-most row(s). However, I have a table where a very important column needs to be located ...
0
votes
3answers
4k views

How do I add content to Excel cells?

How can I add a T to the content of each cell in a certain column (that contains 10000 cells) without typing it manually?
1
vote
3answers
3k views

How can I compare columns in Excel?

If I have two columns of data with 10000 cells in each, and only three of the rows are not identical in both columns, how can I locate the different ones (without comparing each pair of cells)?
2
votes
2answers
5k views

Excel - Dynamic row reference based on the row I paste a formula into?

I have a simple, oft-used formula that I paste as plain text into spreadsheets I receive. It looks something like this: =IF(D8="FOO", "BAR", "BAZ") It looks in D8 for the word "FOO". If it finds it ...
2
votes
1answer
778 views

Two Spreadsheets, Merge Data?

I was wondering what is the best way to merge two spreadsheets which have the name id's e.g: One sheet has: apple 5 dog 3 cat 2 Second sheet: dog 4 apple 7 cat 3 I would ...
1
vote
2answers
153 views

Versionable text spreadsheet format, ideally with GUI editor

I'm looking for a spreadsheet format that whose diffs won't look insane if I version it. Ideally this would have a decent editor to go with it (GUI preferably), and should be available ...
1
vote
1answer
104 views

How to visualize historical data

I have inherited a horrible spreadsheet with 4 years of data about when people participated in a given activity, by month. Each person would likely participate once every 18 months or so, but ...
2
votes
1answer
42 views

Rearrange cells in a column to a different column with same heading (Excel 2002)

I need the values in one column to be rearranged for each set into another column. This picture will help explain: Follow the red lines, that is where I want my data to go. This shouldn't be too ...
0
votes
1answer
77 views

How do I select a set of specific cells and then copy their entire row?

Okay this is hard to explain. I have a massive spreadsheet with sets of data in it. Each set has 'type' column (eg: system, memory, video card, etc). I need to be able to search within this column ...
0
votes
1answer
2k views

Microsoft Excel Exercises for learning purposes

I'm not sure if it belongs this here, but if you feel it doesn't just please remove it. I'm looking for a good source of exercises in excel that is good in teaching a friend of mine that wants to ...
0
votes
1answer
1k views

Autosort microsoft excel worksheet

Can I configure (possibly with scripts) Excel to automatically resort a table every time an entry is updated?
0
votes
1answer
426 views

How do I simplify this if statement to just add 1 every time (and possibly go with no limit)?

=if(C24 ='Ability Base'!$A$2;sum('Ability Base'!$B$2); if(C24 ='Ability Base'!$A$3;sum('Ability Base'!$B$3); if(C24 ='Ability Base'!$A$4;sum('Ability Base'!$B$4); if(C24 ='Ability ...
3
votes
1answer
5k views

Excel: #NAME? appearing when linking/referencing other spreadsheets/workbook cells

I'm updating a spreadsheet that refers to data in another worksheet =NameofWorksheet for some reason I get #NAME? in some of the cells, even when the actual path is correct. The only way to overcome ...
2
votes
2answers
4k views

how to find lowest 2 or more values

I have rows of data and would like to sum all but the lowest 2 or 3 or 4 entries. What is the easiest way to do this? Does it involve a macro. I prefer open office spreadsheet, but could also use ...
2
votes
1answer
177 views

Conditional Formatting in Excel

I have a worksheet with a series of rows A1 - H1 etc and a drop down list which lives in H1, I would really like to change the cell styles of all the cells between A1 - H1 based on the value in H1. ...
1
vote
2answers
465 views

Not counting values if strikethrough in iWork- Numbers

I'm building a holiday expense planner and I'm trying to get the sum of a column in a table, however as I pay things off I want to be able to strikethrough the amount and then it minus it from the ...
2
votes
3answers
636 views

Excel data representation: show me all people who did not pass the exam

Background I have an excel spreadsheet with the results of a pass/no-pass exam. Students are allowed to take the exam as often as they want until they either pass, or give up trying. student ...
1
vote
1answer
140 views

Inserting scientific data into open office Calc

i have some scientific data that i want to insert into oo.org calc. when i do this, instead of displaying 0.35678 in a cell it displays 0.35 (only the first 2 digits after the decimal). but on ...
2
votes
3answers
225 views

Spreadsheet RDBMS

I'm looking for a software (or set of software) that will let me combine spreadsheet and database workflows. Data entry in spreadsheet to enable simple entry from clipboard, analysis based on joins, ...
13
votes
2answers
5k views

Excel Conditional Formatting Escaping a Question Mark

I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn ...