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

**0**

votes

**0**answers

5 views

### Google drive spreadsheet is showing black shadow on while typing letters

I mm using Google drive spreadsheet. It is showing a black shadow while typing letters in excel.
How do I resolve this?

**0**

votes

**0**answers

11 views

### Which versions of MSExcel support the 'WEBSERVICE' function?

Pursuant to Excel formula to take out quotations ,
I saw that it's possible to use a form of web-querying in certain versions of MSExcel. Incidentally, what I saw was:
...

**0**

votes

**0**answers

20 views

### Save worksheet as a seperate file [on hold]

I would like to know if there is an option in Excel 2010 where you can save a specific worksheet in an Excel file into another file, without having to open the destination file. Thus without having to ...

**1**

vote

**1**answer

12 views

### Count number of cells that match certain criteria with formulae

Suppose I have column with dates:
2015-01-10
2015-08-12
2014-01-02
2015-01-28
2016-10-14
I want to count how many dates fall to January. I would supopse that formulae is like this ...

**0**

votes

**0**answers

35 views

### Heterogeneous Workbook Consolidation – Need Assistance

I have several Excel workbooks, each containing a couple dozen spreadsheets.
The workbooks have different names and so do the spreadsheets, and simply mass consolidating doesn't help with the issue I ...

**1**

vote

**2**answers

28 views

### openoffice calc: sum of a function of elements of a row

If I want to sum the elements of the first row (from the column a to x) of a calc document I can use =sum(a1:x1).
My question is about the possibility to calculate something like this
...

**0**

votes

**2**answers

28 views

### Prevent formula input in all cells in a column, but allow whole number input

I am in a bit of a sticky situation. There is a public spreadsheet that some of my coworkers are required to use for their job. They all collectively use it during their shifts to track product ...

**1**

vote

**2**answers

29 views

### Counter in Excel

My file has 50 sheet inside, which each sheet is a standard form. Lets name as Form1, Form2, Form3.
I want to create a print sheet, where I select which form I want to see, so that I don't need to ...

**0**

votes

**0**answers

17 views

### Cell formatting in Google Spreadsheets does not get preserved

My Google Spreadsheet does not preserve some formatting. Every time I set, for example, font size to 12 for the whole sheet, newly copied data uses a smaller font size.
This only started being an ...

**0**

votes

**1**answer

16 views

### How to add double quotes around data in tables using Calc

I am trying to load my data into a CRM, but am having a lot of trouble. The data simply wont load at the same time, but all the files work fine individually. Support advised that I make sure I'm using ...

**0**

votes

**1**answer

19 views

### how to highlight the cell with the max value

given a range of non adjacent columns (not sure if it matters if they're adjacent) i.e
F1:F100,J1:J100,N1:N100
for each row i'd like to highlight the cell with the maximum value.
i tried ...

**0**

votes

**2**answers

36 views

### need help in editing data in csv file

I am in need of editing the date data in csv.
I will explain with an example.
I am using WPS presentation software for reading and editing csv files. If the above is not possible in that, i can ...

**0**

votes

**0**answers

24 views

### Histogram of dates in Google Sheets or OpenOffice

I have a list of dates that I would like create a histogram of.
date
5/21/2014
5/20/2014
9/16/2014
5/28/2014
6/8/2014
6/8/2014
5/28/2014
5/20/2014
8/11/2014
7/19/2014
8/11/2014
The chart's x-axis ...

**0**

votes

**0**answers

10 views

### Apache OpenOffice 4.1.1 OSX 10.8.5

After losing an extensive spreadsheet last night, I started all over today. Got it completed. Had saved (as .xls) manually using save/save all in the dropdown menu periodically throughout. Closed. ...

**0**

votes

**0**answers

16 views

### Lost file Apache Open Office

I'm using Apache OpenOffice. Lost an extensive spreadsheet when OO crashed. Is there a possibility it's still on my OSX 10.8.5 system somewhere? Can't find it. Document was saved numerous times. ...

**0**

votes

**0**answers

15 views

### Kingsoft Spreadsheets = “Free” version of Excel…won't Sort by column Headers any more

I've had this happen even in Excel, but it's always annoying. I'll be sorting just fine, no worries, then boom, it will refuse to sort by the column Header and will only look at the first cell of data ...

**1**

vote

**0**answers

20 views

### Where does the calculation take place? [closed]

In Google spreadsheets, I have quite a big amount of relatively complex array formulas in many cells. That takes ages to complete calculating.
Does the speed of calculation depend on my PC ...

**0**

votes

**1**answer

57 views

### add prefix to a cell in a spreadsheet

I have a cell in a (google)spreadsheet document (let's say L7) where I usually put a numeric value (like, say: "28", "12", "87"...).
I'm trying to make a formula that adds a letter in front (or ...

**0**

votes

**0**answers

19 views

### How can I Collate and create totals of a range of transactions in iwork Numbers

ColumnA ColumnB
Dave 10
Dave 10
Peter 5
Susan 5
Dave 5
Peter 5
I would like to create new table to read down ColumnA, create a new list with no Duplicates and Total up the Values ...

**0**

votes

**1**answer

25 views

### How to return the name of uniquely named sheet

So I've searched high and low and cannot seem to find an answer to this question. Spent almost two days trying every thing I could find on line, but none were specific enough to my situation. Without ...

**0**

votes

**1**answer

17 views

### OpenOffice Calc - 11 Pages in spreadsheet, but print interface only shows 2

I am working on a spreadsheet using OpenOffice and need the pages to be printable.
You can print the first two, but thats it. If in the print interface I select all sheets it only shows 1 and 2 with ...

**1**

vote

**2**answers

216 views

### Excel Opening as a blank spreadsheet, but with values

When we open an Excel spreadsheet that is populated it will open with all of the cells appearing blank. However, if you click on any of the cells you can see in the formula bar at the top that they ...

**0**

votes

**2**answers

98 views

### Is there a tool to put a phone number into E.164 format?

I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example:
(123)456-7890 fred ...

**0**

votes

**1**answer

69 views

### Excel: Converting two lists into a matrix

I have two lists in my workbook currently
Name | System 1 | System 2 | System 3 |
John | x | x | |
James| | x | x |
Peter| | x | ...

**0**

votes

**0**answers

26 views

### Microsoft Excel 2013 Formatting When Importing Data

I am importing data from Quickbooks into an Excel 2013 spreadsheet and this will take place on a weekly basis with updated information being added to this report. The report is an Open Estimates ...

**0**

votes

**1**answer

41 views

### How to make a custom selection on excel?

Is it possible to make a custom selection on a spreadsheet and in particular on excel ?
If yes, how to do it ?
(for example, I would like to select one cell on 3 among a column
or select only the ...

**0**

votes

**2**answers

49 views

### How to remove rows that match?

I have a csv file with list of people (first name, last name, email) and then later on I will get a list of people in another csv file that unsubscribed ( only one column with email).
Q: How can I ...

**2**

votes

**2**answers

605 views

### How can I combine two lists into one long list?

I have two lists in coloumns 1 and 2. I need coloumn 3 to be of the format one dash two.
For example:
Column C will need to repeat all values of A and B.
I would prefer a formula for this is ...

**0**

votes

**0**answers

21 views

### LibreOffice SpreadSheet Conditionally copy value from one cell into a second cell?

I'd like to have the calculated value of a cell be carried over to another cell if the result is less than a given value.
For instance, cell A2 is defined as =A1*.75
If the result is less than x, I'd ...

**0**

votes

**1**answer

57 views

### Spreadsheet finding and sorting most frequent appearance of names

I have a spreadsheet that looks like the following:
https://docs.google.com/spreadsheets/d/1BN3GNRFCsBeHu9gQaKzIo7bfFRkcDqMJ6VMtidEwPD4/edit?usp=sharing
There is a set list of names in Column A. ...

**0**

votes

**0**answers

21 views

### How do I add a number to an input cell?

The scenario is that cell A1 is an input cell, and I want to add another cell's value to what is entered in the A1 cell.
For example, A1 is the input cell. A2 is the output of some independent ...

**0**

votes

**2**answers

25 views

### Can I have multiple views of spreadsheet data which extract and sort from a larger set?

Supposing I have a spreadsheet (Libreoffice ideally but Excel is ok) which has data like this
______| Age | Height | Shoe Size | etc...
Adam | 14 | 180 | 11 | ...
Beth | 21 | 205 | ...

**2**

votes

**1**answer

80 views

### Excel: how to illustrate a budget constraint that depends on more than two factors in a table? Calculate how much of a house you can afford

Imagine that you want to make calculation of how expensive flat/house you can afford to buy. You know how much you can spend on housing per month (100). You also know that there are three factors that ...

**1**

vote

**2**answers

44 views

### Spreadsheets for Matlab

I was wondering if there was a way to directly write a spreadsheets in Matlab, or if someone had published a Matlab add-on that specifically introduced spreadsheets?

**0**

votes

**0**answers

93 views

### LibreOffice calc; is it possible to automatically make cells coloured according to the HTML code entered into them?

I am creating a LibreOffice calc spreadsheet designed to be basically be a customized version of the table entitled "Default element colors, by atomic number:" on this page ...

**0**

votes

**1**answer

23 views

### Importing numbers with leading zeros as text strings in gnumeric

I have a csv file with numbers, some that start with zeros. Those zeros are somewhat important to me. All the entries in the file are encapsulated with double quotes. Gnumeric's import dialogue ...

**0**

votes

**2**answers

121 views

### How do i split a single row of columns into multiple rows and columns?

I've looked all over and either I am not sure how to word this for searching, or there just isn't anything out there. Originally, the information in my excel sheet was pulled from a text file. I had ...

**0**

votes

**4**answers

50 views

### Inserting specific number of rows in Excel

I, for the life of me, can not figure out why M$ has not provided this feature. If I want to insert 597, for the sake of argument lets say blank, new rows, all available information tells me to either
...

**1**

vote

**2**answers

42 views

### How to export a table from inside a PDF into a spreadsheet?

I want to convert this PDF which contains a table, into an Excel-compatible spreadsheet for the purposes of making flash cards.
Does anyone know of an automatic way to do this without manually ...

**0**

votes

**0**answers

38 views

### Formatting a chart with many data points for a small display area

In Excel 2013, I need to display a chart with dates on the X axis and errors (already computed) on the Y axis. The problem is that I have 916 data points taken every six hours spanning approximately ...

**0**

votes

**1**answer

45 views

### Identify in what of the given ranges is a random number

I have this table with the first column being just an Identifier Code and the second one being the ranges.
So for example if a number is between 0 and 1134, it corresponds to the first row ...

**0**

votes

**1**answer

30 views

### organizing columns in excel into standard format

I have data in a excel spreadsheet in a regular pattern that needs to be organized in a format friendly to statistical analysis.
Here is the format:
Clinton 29.30% 22
Edwards ...

**1**

vote

**4**answers

1k views

### Count the number of rows with equal values in two specified columns

I have two columns in MS Excel/LibreOffice Calc/Google Spreadsheets with numbers. I would like to count the number of rows which have identical values in both columns.
In the following example:
...

**0**

votes

**0**answers

27 views

### Spreadsheet Function Help - From A Table Of Names And Birth Dates Pull A List Of Names As Of A Reference Date And There About

I have posted this question before, and got half-solution. Pls have a look at this link to get an idea.
http://yogi--anand-consulting.blogspot.in/2014/11/yogifrom-table-of-names-and-birth-dates.html
...

**1**

vote

**2**answers

208 views

### Parsing dates in LibreOffice Calc - is there a better/easier way?

I have a string of this particular format:
DD/MMM/YY HH:MM AM/PM
e.g.
03/Nov/14 9:00 AM
I could not find figure out how to make Calc recognize it as a date so I had to do the following for a ...

**0**

votes

**1**answer

105 views

### Can I separate email id in spreadsheet based on domain in columns? [duplicate]

I have a list of 20000 email id which have emails from domains like gmail, ymail, gmx, hotmail, custom domains etc I have those list in a spreadsheet Column A. Can you help me separate them according ...

**0**

votes

**0**answers

76 views

### Label distribution and scaling in Numbers

I'm currently working in OS X Numbers on a document with two columns and 1078 rows.
Using this data, I have constructed a simple 2D line graph which I am fairly happy with.
The issue that I'm having ...

**2**

votes

**1**answer

3k views

### Import one cell of data from one spreadsheet to another

I have one spreadsheet that is for global use in which I would like to incorporate one cell of data from various other spreadsheets to refresh anytime there is a change to the source. So for example:
...

**0**

votes

**2**answers

54 views

### How to add up hours

I have a spreadsheet to track my hours at work and I was wondering how I would go about adding up my total hours. I'm not fussed what format it be in, whether it be HH:MM or as a decimal.
...

**0**

votes

**0**answers

19 views

### Prepend text for spreadsheet

I want to have a string value prepended to a XL-style formating in a spreadsheet program (gnumeric). The current formatting is [$-f4f2]hh:mm which should take 1:00 PM as input and convert/display it ...