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
0 answers

How do i set Google spreadsheets to email each row daily with a specific subject? (Automatically)

I would like to email the Google spreadsheet rows daily, with a specific SUBJECT, without me having to anything. I have 4500 rows, which I would like emailed daily. I have 4500 tweets which i would like tweeted. The plan is to send all those rows…
user3620289
  • 11
  • 2
1
vote
1 answer

Create Spreadsheet in .NET Compact Framework 3.5

I hope this is not a repetitive question; I've searched on the site but I was not able to find anything. As the title say I would like to create/edit spreadsheet on a .NET Compact Framework project. On desktop project with the full size framework I…
user3619752
  • 21
  • 6
1
vote
2 answers

Spreadsheetlight Formula not working

i'm using Spreadsheetlight for creating excel document. I need to use a formula on a specific cell, but it's not working. The code: report.SetCellValue(string.Format("{0}{1}", Report.CELL_MAP.ACTIVITY_CRU_COL, row), string.Format("=IF({0}{1}=0; 0;…
BeardedMan
  • 384
  • 2
  • 12
1
vote
1 answer

How can I import a spreadsheet using Rails?

I am having trouble importing a spreadsheet using Rails and the roo gem and keep getting a bad URI(is not URI?) error. I think this is a simple question that I just can't figure out how to do, but how do I properly upload and access the file. Here…
David Mckee
  • 1,100
  • 3
  • 19
  • 35
1
vote
1 answer

Android form submission directly to google doc

basically i m trying to build an android application which shows schedule of buses for to and from my campus..the problem is i have nowhere to save my data ..can i save my data from my form directly to google doc spreadsheet..if yes then how?? my…
user3570470
  • 11
  • 1
1
vote
1 answer

Data munging in R: Subsetting and arranging vectors of uneven length

I am sorry I could not make a more specific title. I am trying to wean myself off of spreadsheets for the more difficult tasks and this one is giving me particular trouble - I can do it in Excel but I don't really know how to begin in R. It is…
syntonicC
  • 371
  • 3
  • 17
1
vote
1 answer

Highstock charts with Google Spreadsheet JSON

I'm trying to draw a chart with data provided in a Spreadsheet, my first problem is with the JSON feed. If I put the key in the google Json sample it gives me nothing. However I can see clearly the JSON feed if I paste the address in the…
SirPedro
  • 15
  • 3
1
vote
1 answer

Google Spreadsheet to PHP script modification

I've found this useful script to convert Google Spreadsheets into array. https://github.com/VernierSoftwareTechnology/google-spreadsheet-to-php-array/blob/master/google-spreadsheet-to-array.php The resulting array is in the form: Array ( [1] =>…
rjpedrosa
  • 652
  • 2
  • 7
  • 10
1
vote
1 answer

Highmaps add and join data from Google Spreadsheet

I can't get my data from Google Spreadsheet to show up on a map I am making with highmaps. I need to make a simple overlay of US map with 2 data points for each state. Data point #1 - revenue per state This one will be color-coded overlay going from…
user3088202
  • 2,714
  • 5
  • 22
  • 36
1
vote
1 answer

Spreadsheets ruby gem encoding not working

I'm getting a weird problem when I try to write strings (that are UTF-8) in a xls with the Spreadsheets gem. It doesn't give errors, but I get an invalid spreadsheet, with random characters (opened on Excel and Calc, same thing). So I assume it is…
Luan Nico
  • 5,376
  • 2
  • 30
  • 60
1
vote
2 answers

excel, time format result for formula

I will explain this with an example: Let's say I have a flow value, like 2 liter per hour. And let's say I have a container that is 3 liter big. If I use a formula to get how much time I need to fill the container, as result 1.5 that is One hour and…
Terix
  • 1,367
  • 5
  • 25
  • 39
1
vote
2 answers

Javascript calculation library (Excel like web page without the grid)

Is there any Javascript (or other NON-java ) CLIENT SIDE calculation library that will allow a complex excel spreadsheet to be posted online as a web page, and then can calculate directly on the web page when the user changes the values. Like a…
user265505
  • 409
  • 6
  • 21
1
vote
2 answers

Online storage: Google Spreadsheet v.s. GAE Bigtable

As an online storage, two of them can be a choice, with officially supported API. Both of them have its advantage and weakness. Google SpreadSheet supports RSS feed, but has limited no. of rows. GAE Bigtable is more scalable, but harder to be…
developer.cyrus
  • 903
  • 2
  • 7
  • 18
1
vote
1 answer

simple-spreadsheet not properly loading an xls file on ruby, but working properly on irb

I'm currently trying to open and parse this xls file using ruby 2.1.1. The straightforward way would be to use the simple-spreadsheet gem, which doesn't seem to work properly for this particular spreadsheet (and a couple others): require…
ailnlv
  • 1,779
  • 1
  • 15
  • 29
1
vote
1 answer

Get first unique entry

I have the following three columns as data: I am using the formula =IF(COUNTIFS($A:$A;A2;$B:$B;B2;$C:$C;C2)=1;1;0) as my output in the Output column. Basically I am giving a non-unique row a 0 and a unique row a 1. However as you can see I want to…
Carol.Kar
  • 4,581
  • 36
  • 131
  • 264
1 2 3
…
99 100