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

Google Scripts fill array of values and their locations from cells

I'm using Google Scripts to manipulate the values in a spreadsheet. Here's what I've got: var Habits = sheet.getRange("C5:D100"); var HABITS = [Habits.getCell(1, 2).getValue(), Habits.getCell(2, 2).getValue(), Habits.getCell(3,…
derekantrican
  • 1,891
  • 3
  • 27
  • 57
1
vote
0 answers

VBA to filter entire Excel workbook by date by way of SQL backend

So I currently have a workbook that has several sheets of pivottables sourced from a SQL database that is updated every hour but has another process that takes a snapshot once per day and date-stamps that snapshot. Every table in SQL has a column…
Joe Hancuff
  • 11
  • 3
1
vote
1 answer

How to make a dates table on excel

I have this spreadsheet in the picture... I want to fill up to 30/ago but the only way I know is to fill by hand... What would be the formula to drag this horizontally and it increment by 1 per column?
nightshade
  • 638
  • 5
  • 15
1
vote
1 answer

Google new spreadsheets return JSON

I am using this link to return JSON data, but it is not working now. It shows a "Invalid query parameter value for grid_id" error. Any ideas?…
Dennis
  • 23
  • 3
1
vote
1 answer

How to add row and column value as a tag of UIButton so that i can get row and column value on button click?

I have a spreadsheet view I added a UIButton in each cell of spreadsheet I want to get the row and column value on click action of that button .
Fortinoh
  • 104
  • 1
  • 7
1
vote
0 answers

Google Refine / Open Refine: Columns to Rows

I'm afraid this might be a somewhat simple question, but I can't seem to figure it out. I have a spreadsheet with many objects, each of which has many attributes (one per column), like this (sorry, I can't post images, so this is the best I can…
miriamkp
  • 13
  • 2
1
vote
1 answer

Excel countA to include multiple columns

I am having problems with the following formula in excel: =counta(iferror(filter('Form Responses'!F:F, 'Form Responses'!F:F =A2))) Basically Form Responses is a separate sheet, all i am trying to do is make this formula look at multiple columns and…
JMoore809
  • 13
  • 3
1
vote
1 answer

Event handling in spreadsheet using spreadjs

I am using spreadjs for manipulting data in the view in which user can change some value,can anyone suggest me that how i can dynamically get that changed value on the fly for updating in to database?
user2407995
  • 31
  • 1
  • 5
1
vote
2 answers

Creating a generic Checkbox_Click VBA Code

I am creating an excel file that is a checklist, currently i have 73 checkboxes in Column D, where in column E it will populate the name of the user based on the username in the options field. Currently i Have code such as: Sub CheckBox1_Click() If…
Max Hanft
  • 15
  • 2
1
vote
1 answer

How to compare rows in excel and carry out if statment

I have a spreadsheet where I need to calculate the number of times something has been done to a particular area, I know that when certain criteria exists a field in another spreadsheet should be incremented. for i to rows.length if Cell(A,i) ==…
vinnie667
  • 109
  • 11
1
vote
2 answers

Automatically combine two tables into one on Google Sheets?

Currently I have: Sheet 2 with a table of people's times running round Track A (names in one column and times in another) and Sheet 3 with a table of people's times running round Track B (same layout). Assuming that both tracks are the same…
Californ1a
  • 31
  • 4
1
vote
3 answers

Make value of input sum of other inputs automatically?

I'm just wondering if this is possible, and if not, the best way to set up event handlers to make this happen... If I have a spreadsheet-like HTML table like so: …
Anthony
  • 36,459
  • 25
  • 97
  • 163
1
vote
0 answers

In Google Spreadsheet API, how to pass equal sign as value?

My goal is to inject the cell with =HYPERLINK("text", "link") So I did this with: row.getCustomElements().setValueLocal("item", "=hyperlink(\""+a.getAttribute("href")+"\",\""+tds.get(1).getText().replace("=","")+"\")"); But I got error, it won't…
Darthvazor
  • 53
  • 1
  • 1
  • 6
1
vote
1 answer

Excel formula to extract a specific record

I have an excel spreadsheet with 250 accounts, each with a bunch of transaction records. I need to extract a date where an interest rate has changed. There are 250000+ records. It looks like this: ACCT CEL-INT-RATE LTD-INT-BILL…
6dev6il6
  • 767
  • 2
  • 15
  • 34
1
vote
0 answers

Google Apps Spreadsheet open specific sheet based on week number

I know the solution "move sheet to the most left" to make it default when opening spreadsheet. Thing is that I got one spreadsheet per week, and it's quite messy to move around like that, plus it will be much more user friendly. Something similar…
user3645455
  • 19
  • 1
  • 3
1 2 3
…
99 100