Questions tagged [spreadsheet]

Use this tag for questions about spreadsheet apps, plug-ins, libraries, etc., where no more specific tag exists. A spreadsheet presents tabular data sets arranged in rows and columns, typically with tools for capturing, analyzing, and collaborating on that data. Each cell may contain alphanumeric text, numeric values, or formulas.

Note: The spreadsheet tag should only be used if a more specific tag does not apply to the question.

A spreadsheet presents tabular data sets arranged in rows and columns, typically with tools for capturing, analyzing, and collaborating on that data. Each cell may contain alphanumeric text, numeric values, or formulas.

Related Tags:

Don't tag your question with spreadsheet if a more specific spreadsheet tag is appropriate. Common spreadsheet software and their more specific tags include:

Microsoft Excel, specific tags: excel, commonly paired withvba
Google Sheets, specific tags: google-sheets, commonly paired with google-sheets-api, or Google Doc's google-apps-script
OpenOffice Calc, specific tags: openoffice-calc, openoffice-basic, spreadsheetml
LibreOffice Calc, specific tags: libreoffice-calc, libreoffice-basic
Apple's Numbers, specific tags: apple-numbers, applescript, applescript-numbers
Gnumeric, specific tag: gnumeric

If there is no more specific tag than spreadsheet for your question, use one or more of the following related tags to enlarge the audience for your question:

Relevant programming language, e.g. javascript, c#, php, c++, asp.net, silverlight etc.
Add-in or framework, e.g. jxl, opencsv, fgetcsv, fputcsv, spreadsheetgear, fastercsv, supercsv, csvhelper, cfspreadsheet, applescript-excel, gembox-spreadsheet, spreadsheet-excel-writer, jquery-csv, spreadsheetlight, spark-csv, smartercsv, xml-spreadsheet, linqtocsv, load-csv, apache-commons-csv, spreadsheet-gem, spreadjs, csvjdbc, csvkit, jcsv
Related protocols, standards, and file formats, e.g. xls, csv
Specific tasks, e.g. export-to-excel, export-to-csv, import-from-csv (instead of csv-import), csvtoarray, read.csv (r specific)

References

Spreadsheet on Wikipedia
Spreadsheet concepts, also on Wikipedia, provides an excellent overview of the terminology common to all spreadsheet software.

4421 questions

vote

1 answer

Use unique user number in Google Forms

I want to send my clients in my database an e-mail with a request to fill in a Google form to research their needs for our service in the future. Every client has an unique ID already (for example EX0258, EA1405, EZ2815). I need a way how I can add…

forms url unique spreadsheet

asked Mar 15 '15 at 13:17

Sami Chouchane

vote

1 answer

Google Sheets, using Countifs to count number of values in a range, and match another cell's value

Working on a Google Spreadsheet, seems to be behaving differently from excel. This spreadsheet is integrated from a Google form, responses have a date, and a username. What I am trying to do is count the number of entries between two dates, and…

google-sheets spreadsheet

asked Mar 04 '15 at 19:49

Todd Kenna

vote

1 answer

Google Appscript: Custom function to concatenate only the initials from multiple rows based on a criteria

Apologies if I can't explain it very well but I have a spreadsheet that I want to use to create usernames based on a naming convention criteria (e.g. Type 1 = given name 1st & 2nd initials + middle name initial + lastname). I managed to achieve that…

google-apps-script concatenation customization spreadsheet simplify

asked Mar 04 '15 at 10:48

tai

vote

1 answer

Handle dependency resolution functionally in Haskell

I'm implementing something similar to a Spreadsheet engine in Haskell. There are ETables, which have rows of cells containing expressions in the form of ASTs (e.g. BinOp + 2 2), which can contain references to other cells of ETables. The main…

haskell design-patterns dependencies spreadsheet

asked Feb 18 '15 at 18:50

BruceBerry

1,166
1
9
21

vote

1 answer

Copy columns and paste values (not formulas)

AlexP provided the following code to a question about copying columns. It works great for me except that in ws1, the columns have equations that get copied over to ws2. I just want to copy over the values, not the equations. Sub CopyHeaders() …

excel vba spreadsheet

asked Feb 12 '15 at 23:21

EDLB

vote

1 answer

Google Spreadsheets script to delete any rows where a string is found

I need to loop through all rows/columns in a sheet and remove rows contain certain words. Ideally, I would search through the sheet using a regular expression, but just finding a string would help get me moving. I'm seeing a lot of posts on Stack…

javascript google-apps-script google-sheets spreadsheet google-sheets-api

asked Feb 11 '15 at 18:49

Keith

vote

3 answers

Can I import excel file to phpmyadmin?

I have an speadsheet file contains some data such as ID, name, lastname. Can I import excel file to phpmyadmin (SQL)? How to do it?

excel phpmyadmin spreadsheet

asked May 10 '10 at 15:05

Giffary

3,060
12
50
71

vote

1 answer

Google Spreadsheet REGEXREPLACE, get replacement from cell

I am working with google spreadsheet and we will use it creating product data. Have a look at this screen: http://awesomescreenshot.com/07f44br7bc I will have the syntax of the product name in column A. In Column C, D and E I will have the content I…

regex spreadsheet

asked Jan 01 '15 at 20:11

dermold

vote

1 answer

How to get previous versions of a spreadsheet with Google Docs API?

The "previous version" interface on Google Docs is very primitive. It wouldn't even allow you to select two arbitrary versions for comparison (but correct me if I'm wrong.) How can I access the previous versions via the API?

history spreadsheet google-docs google-docs-api

asked Apr 30 '10 at 04:36

netvope

7,647
7
32
42

vote

1 answer

Reference Google Spreadsheet (CSV) in Jekyll Data

I am managing a website displaying a lot of tabular data (language stuff) and running on Jekyll. I really like to display content based on a CSV file stored in the _data folder of Jekyll. I would like to be able to edit / add / remove content from…

csv jekyll spreadsheet google-docs

asked Dec 11 '14 at 10:12

Maikeximu

vote

1 answer

AVERAGEIF Returns #DIV/0

I have looked around for the answer and can't find it (even though lots of people are having problems with this) - if someone's seen the answer somewhere, please let me know. I'm doing a very very basic travel expenses sheet Month by month, I need…

excel google-sheets spreadsheet

asked Dec 09 '14 at 19:07

Gui Seiz

vote

1 answer

Ruby spreadsheet datetime error

I have a row that looks like the following (in a .xls): bob abc 6/14/14 8:23 I want to return the date and time as: 61414823 I tried to get started with: def self.regex_date _test_column = @sheet.row(1)[2].date ... end Which I read about…

ruby regex spreadsheet

asked Dec 07 '14 at 07:12

MMP

vote

1 answer

Text in IF formula

I am trying to develop a spreadsheet pulling data and text from another sheet within the workbook while leaving the cell blank if not populated in the aforementioned sheet. I am trying to develop a materials summary sheet pulling from a stock…

excel excel-formula spreadsheet

asked Nov 14 '14 at 19:45

Rick D

vote

2 answers

I want to set up a day timer that continues to count the days as soon as any data is entered into the row of spreadsheet

Could Someone please help me with the fallowing question? I set up a Spreadsheet that will relate to the question below https://docs.google.com/spreadsheets/d/1sp8j2zNzzr-lnkMPnYt_aukKM7vqf_31Tq71De_xr04/edit?usp=sharing (Im not sure the fallowing…

google-apps-script spreadsheet

asked Nov 06 '14 at 23:49

sunny rai

vote

1 answer

Spreadsheet:: ParseExcel in PERL query

I am writing a PERL code to pick values from specific rows of a particular excel sheet. I am using the Spreadsheet::ParseExcel module for this purpose. I have written this code as of now use Spreadsheet::ParseExcel::FmtDefault; use…

excel perl spreadsheet parseexcel

asked Nov 05 '14 at 06:29

The Last Word

Prev 1 2 3

…

99 100 Next