The spreadsheet tag has no wiki summary.
1
vote
1answer
29 views
LibreOffice Calc prompting to update “links to other files”. Why?
I have a spread sheet that recently started asking "This file contains links to other files, should they be updated". I have been using this file for a while and don't know why it started, what it ...
0
votes
0answers
28 views
How can I calculate how often one string appears in a column compared to another string? [migrated]
I have a column in my Google Docs spreadsheet which contains either "OK" or "NOK" (acceptance testing).
How can I calculate the percentage for how often "OK" appears compared to "NOK".
1
vote
4answers
45 views
How to view a delimiter-separated-value file in Emacs with highlighting helpful for reading?
How to view a delimiter-separated-value file in Emacs with highlighting helpful for reading?
Ideally the delimiter character/string should be customizable.
If Emacs can't do, any other tool ...
1
vote
3answers
52 views
Excel: Multiple =IF calculations within one cell
I need to do some text comparisons in excel, about 20-50 of them. I would like the result of these if statements to be within a single cell. Here is how I WISHED it would work:
...
0
votes
0answers
21 views
In a Google spreadsheet, how can I refer to two different columns in a COUNTIF function? [migrated]
I'll try my best to explain. Say I've got a sheet that looks like this (in this contrived example, let's say I'm sending marketing emails to various people, I know their ages and zip codes, and I ...
1
vote
2answers
69 views
Alternatives to Excel
Is there some WYSIWYG utility that allows one to create simple spreadsheets? Something like standalone Google Docs. Excel is definetely an overkill for someone who doesn't want to create exotic ...
1
vote
2answers
68 views
How can I enable the creation and editing of hyperlinks in shared Excel worksheets?
I have hyperlinks in some Excel 2010 (both .xlsx and .xls formats) worksheets. If I enable sharing of the workbook I can no longer edit or create hyperlinks - the options no longer exist on the menu ...
0
votes
0answers
7 views
Multilingual spreadsheet
I need to make a spreadsheet template that needs to be support both English and Spanish.
I know Office 2010 has an option to translate content into desired language but its a manual process.
Is there ...
0
votes
0answers
205 views
Macro Code for LibreOffice Calc
I have been working on a invoice spreadsheet in Libre Office Calc. Im almost done but I have a few tasks left to complete before its where I want it. I have used the Macro recorder to get most of ...
2
votes
2answers
119 views
How to break a spreadsheet containing CSV into multiple columns?
I'm working on preparing data for export, and the client has put all of the data into a spreadsheet. Each field of data should be its own column. The problem is that the client erroneously put ...
5
votes
2answers
69 views
How to sum cells depending on the content of a neighbor cell
I have an Excel document with the following columns;
Date | Reference | Amount
23/01/11 | 111111111 | £20.00
25/09/11 | 222222222 | £30.00
11/11/11 | 111111111 | ...
0
votes
0answers
31 views
In spreadsheets, do dates belong in rows or columns [closed]
I have some time data, about 30 tuples, each with about 30 attributes. Do the dates belong in the rows (with column headings being the attributes) or in the columns (with the rows being the ...
1
vote
2answers
48 views
How to filter a spreadsheet on multiple filter values
I've got a spreadsheet of addresses with the following columns: First Name, Last Name, Street Address, City, State, and zip code. I'd like to be able to filter or otherwise extract a subset of these ...
2
votes
1answer
158 views
Can you use infinity in a cell reference in LibreOffice (or any other spreadsheat)? [closed]
Possible Duplicate:
Can you reference an entire column in OpenOffice Calc (like A:A in Excel)?
I'm using a Sum of a column, and it keeps growing, so I have to update the reference to which ...
0
votes
2answers
26 views
copy worksheet to several workbook
I created a worksheet/spreadsheet with functions and references to cells in other worksheets/spreadsheets within same workbook to create a report of other worksheets within the same workbook.
I have ...
0
votes
1answer
152 views
OpenOffice Calc - how to insert BLANK in a formula?
In Calc, as in most spreadsheet applications, an IF() function exists that can be used to control behaviour, for example inserting this formula in cell C1.
=IF(A1>B1;"A";"B")
will display A in ...
1
vote
2answers
98 views
Multicolumn spreadsheet: extract unique values in Column 1, given same values in Columns 3 and 4?
Here's a problem: given a (large) spreadsheet with userIDs in Column 1, a time/date pair in Column 2, a course code in Column 3, and a course title in Column 4: I want to produce a report showing how ...
1
vote
2answers
322 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 ...
0
votes
1answer
34 views
Creating a chart with two date columns
I have some data from Google Analytics relating to traffic to one of my websites.
I would like to compare the traffic from now to the same time one year ago. However, to be difficult I do not simply ...
4
votes
2answers
181 views
How do I delete excess cells in Excel 2007?
I am not the original creator of the spreadsheet so I am not sure how the person caused this. The issue is basically the excel spreadsheet has an excess amount of empty cells that won't delete and ...
1
vote
0answers
48 views
Searching a CSV or Excel file for terms from one column of another Excel file [closed]
I have a column of data in an Excel file. I want to use it to search the contents of another CSV or Excel file and return / highlight all of the matches. How can I do that using Google Docs, Open ...
0
votes
2answers
85 views
Software for quickly tagging photo catalogue and export to spreadsheet?
We have 3000 photos that we want to quickly flip through and tag into different categories, and export that information into a spreadsheet. The software can be very simple (I am not doing any editing, ...
1
vote
2answers
72 views
Advanced spreadsheet auto-formatting
Is it possible to autoformat spreadsheet like this
IF A1 = C1 then A1:E1 cells background becomes light gray
I use OO Calc, but it's ok if you know how to do it in MS Excel or Google spreadsheet
3
votes
1answer
124 views
How do I make a random selection in a spreadsheet using more than one criteria
I have a spreadsheet created in OpenOffice (V3.3.0 in Windows 7 32 bit) that I use as a database of my DVD collection. After asking a question in SuperUser, I have it so it can pop up a random title ...
1
vote
1answer
292 views
How do I use conditional formatting in a spreadsheet based on dates?
I have a spreadsheet in OpenOffice V3.3.0 (used in Windows 7 32 bit). One column contains dates (in the format: 14 August 2011 ) and I want to use conditional formatting on those cells depending on ...
2
votes
5answers
97 views
How do I transpose and combine cells in Excel?
Do you know how to generate the following?
Excel table:
+-----------------------+
| A | 1 | 2 | 3 | 4 | 5 |
+-----------------------+
| B | 1 | 2 | 3 | 4 | 5 |
+-----------------------+
I want to ...
5
votes
5answers
192 views
Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm
I'm trying to develop an Excel formula that would calculate the actual time duration for a string of a time range of the following format: 1:00am – 3:00am
According to this article it seems it should ...
1
vote
2answers
68 views
Is importing one Excel spreadsheet into another Excel spreadsheet possible?
Can I import an Excel spreadsheet into another spreadsheet (two separate files) by linking in certain cells from one to show in other cells in a different file?
I'm not sure if I can do this or where ...
7
votes
1answer
95 views
How to sort an Excel spreadsheet columns by row contents?
How do I sort the columns of an Excel spreadsheet? The Sort command from the Data menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents ...
0
votes
1answer
61 views
Make a differentiated barchart using numbers
I have a question about Numbers.
I want to make a bar chart that shows the membership of my organisation.
I want to divide between unitary organisations and membership organisations, so i want ...
1
vote
1answer
64 views
How to sum the multiplications of rows, being the multiplier variable in a spreadsheet
I have this spreadsheet:
I want to calculate the total income, but since the different rows are in different currencies the conversion must be done first. The currency values are mapped to codes in ...
0
votes
0answers
21 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 ...
0
votes
0answers
38 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
53 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?
2
votes
2answers
324 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
49 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
4answers
188 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
90 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
50 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
79 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 ...
1
vote
1answer
397 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 ...
4
votes
8answers
353 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 ...
1
vote
0answers
78 views
Spreadsheet formula to count consecutive values in a column
I have a column with "Y" and "N" values, and need a formula to count the last consecutive occurrences of "Y". So if I the column looks like this:
Y
Y
Y
N
Y
N
Y
Y
the desired result would be 2
Y
Y
...
0
votes
1answer
100 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
448 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
52 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
84 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
72 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
105 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
75 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 ...
