Stack Overflow
Stack Overflow

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 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 if a more specific spreadsheet tag is appropriate. Common spreadsheet software and their more specific tags include:

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

References

4421 questions
1
vote
1 answer

How to hide rows if one of the cells is a duplicate of the one above it

I'm trying to filter a contact list that contains each contact's name, company, email address, etc. As it currently is, the contacts are sorted by their company name and I have various contacts from the same company. I want to be able to have only…
Gabriel Rotman
  • 201
  • 1
  • 2
  • 9
1
vote
1 answer

using date-time in emacs spreadsheets

I'm just starting to use ses-mode in emacs, and I plan to use it with timestamps, but I do not manage to have them parsed in a way that I can then use. I'm taking measurements on three days of the week, so my distances between one measurement and…
mariotomo
  • 9,438
  • 8
  • 47
  • 66
1
vote
0 answers

creating Realm database from user oriented (cough) source

Are there any packages for easily creating a Realm database from something that a user would be able to edit? To be more specific, I'm thinking of a spreadsheet, which the user could export as a CSV, which could then be quickly processed into Realm,…
Original Wombat
  • 107
  • 1
  • 3
  • 5
1
vote
1 answer

Hiding cell Contains in MS Excel using SpreadSheetGear?

Hey any body know how to hide cell contains using spreadsheet gear.
Avinash
  • 173
  • 1
  • 4
  • 17
1
vote
2 answers

Coldfusion spreadsheet setting dataformat(h:mm)

I'm using Coldfusion 10 and I have a test code to create a spreadsheet and format a colum with value "8:30" to format "h:mm". Code as below:
Adrienne
  • 13
  • 2
1
vote
2 answers

Form answer Spreadsheet - onChange trigger

I would like to ask about running onChange trigger after change is made in spreadsheet by Google Form. I have this source code for sending email after change is made: function onChange(e){ var sheet = SpreadsheetApp.getActiveSheet(); var…
Martin Fedy Fedorko
  • 323
  • 5
  • 20
1
vote
3 answers

Perl Spreadsheet::ParseExcel cannot parse and return undef

Just installed Spreadsheet::ParseExcel module, but got problem. See a few related question, but not exact the same. #!/usr/bin/perl -w use strict; use…
Tony Xu
  • 3,031
  • 4
  • 32
  • 43
1
vote
2 answers

How to make lists of tagged data in Google Sheets or Excel

I have created a google spreadsheet of tagged data (see example data below) and I am trying to make different lists based on the tags. For instance I would like to see a list of media, health, and eyes records. From the data below, there should be 4…
eniacAvenger
  • 875
  • 12
  • 17
1
vote
2 answers

case statement in a spreadsheet

So, what i am trying to accomplish here is pretty straight forward, i have a column fare in my spreadsheet and i want to add anew column that would say if the fare is <10 ,10<20,20<30,30+ I came up with this solution but it seems like it is not…
fenec
  • 5,637
  • 10
  • 56
  • 82
1
vote
1 answer

How to remove vlookup function but keep the value in pragmatically from perl spreadsheet

I am generating a xl file using perl spreadsheet, it contains 'vlookup' function for one column, the value which generated from the vlookup function is correct but I want to remove this formula and keep its value only, How to do this? I'm using …
user1573690
  • 361
  • 1
  • 7
  • 21
1
vote
2 answers

Convert Date Value When Using Google Form Date Picker from 5 Digit Format to MM/dd/yyyy format

I selected tomorrow's date (8/21/2014) from the data picker field of a Google Form submission, and the value "41872" is returned in the spreadsheet. What format is this date format? I need to convert this date format to the MM/dd/yyyy format using…
Theo Ramsey
  • 11
  • 2
1
vote
1 answer

SYSTEM_FD_MAX reset to zero when calling close() of Spreadsheet::WriteExcel::Big (Perl v 5.8.0 and WriteExcel v 2.37)

The close() method of Spreadsheet::WriteExcel::Big (v 2.37) package destroys all the standard file descriptor (stdin,stdout and stderr) when run with perl v 5.8.0 i.e. Close() method reset the ^F = 0. But when run with perl 5.8.5 version, ^F is not…
Sumit Kumar
  • 160
  • 1
  • 5
1
vote
1 answer

excel-vba copy cell and paste on diffrent spreadsheets

The question is a little more difficult than the title, just don't know how to ask it. I have a spread sheet that contains 4 columns (Part Number,Qty,Location and Description), is there a way using vba o some excel function that can copy and paste…
MoralesJosue
  • 199
  • 1
  • 4
  • 16
1
vote
0 answers

Issue while reading Spreadsheet from ColdFusion

I am facing an Issue while reading Excel sheet (xls/xlsx) created from Microsoft Office 2013. Here are the…
Sks
  • 612
  • 7
  • 23
1
vote
2 answers

Google Spreadsheet & ArrayFormula - auto-adding formulas

I'm having problems with something that is likey very simple to correct. I have a form that submits data to a Google Spreadsheet, simply a date, name and score. On a separate sheet I am going to have a leaderboard which shows all submissions ranked…
Mark
  • 739
  • 1
  • 9
  • 15
1 2 3
…
99 100