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

Lookup value - #N/A result

I am using =IF(VLOOKUP(A2;$B$2:$B$11;B2;FALSE); TRUE; FALSE) to lookup a value in the column A. As you can see my formula does not seem valid. Any suggestions why this is the case? I appreciate your answer! UPDATE I am currently getting with…
user2051347
  • 1,609
  • 4
  • 23
  • 34
1
vote
1 answer

Importing data from spreadsheet to Neo4j

I am new to Neo4j.I downloaded the software from www.neo4j.org and I was able to create the Movie graph which came with the download. Now I am trying to export data from spreadsheet into Neo4j.Here is the procedure I am following I was stuck at the…
user3310868
  • 11
  • 1
1
vote
0 answers

Rails send_data for a mobile device

Im trying to generate a *.xls(spreadsheet file) und and make in downloadable for a mobile device. Well this works great for desktop browsers and the iphone, but the android will tell that the file couldnt be downloaded. controller.rb def index …
Alex
  • 327
  • 5
  • 8
1
vote
1 answer

Check for day range and no

I have the following data sheet: As you can see I have a date and a no which is a string. Now I want to filter out all dates which have the same number in a +-20 day intervall around the date. So for example: If the 12.2.2014 has the value a then…
user2051347
  • 1,609
  • 4
  • 23
  • 34
1
vote
1 answer

Replicating Google Sheets like performance (handsontable)

I'm using handsontable + jQuery http://handsontable.com/ to embed a spreadsheet in a webpage. While handsontable does a pretty good job of handling larger data sets, the problem for me is trying to pull in 100,000+ rows of data at once from MongoDB…
bonez
  • 685
  • 1
  • 16
  • 39
1
vote
1 answer

Rails application save CSV files as XLS excel files?

I have a rails application. In my application I am generating various reports in CSV formats. Now due to some issues with header and truncation of data in CSV. I want to save CSV file in to xls format excel files. Which is the best way to achieve…
Sumit Munot
  • 3,748
  • 1
  • 32
  • 51
1
vote
4 answers

string as boolean

I'm making a spreadsheet in Java. I'd like to make a copy of the Microsoft Excel function ISLOGICAL. It checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE. All cells are arrays of string. This is what I have…
user3204281
  • 11
  • 1
1
vote
1 answer

MySQL database efficiency for spreadsheet web app

Background: I am hoping to make a spreadsheet program a bit like Google Docs. I am currently in the planning phase and have realised that if one cell is changed then that could potentially affect 1,000+ other cells in the spreadsheet. I realise…
Brett
  • 3,296
  • 5
  • 29
  • 45
1
vote
1 answer

Assign task using a point system using excel

Assuming I have 10 people and 10 tasks. Everyone can distribute this points to express his personal preference which tasks to take. In the end I need to make an automated decision who gets assigned which task. Is there a fast and simple way to do so…
Chris
  • 89
  • 2
  • 8
1
vote
1 answer

Assigning categories based on cell containing a string

I would like to fill in the category cell of this example Date Description Debit Category 15/07/2011 Farmer Smith 10 based on an other worksheet containing mapping values like this : Farmer | Groceries I think I have to…
Finger twist
  • 3,546
  • 9
  • 42
  • 52
1
vote
1 answer

I need to count values in one column in Excel when they meet criteria in another column

I'm trying to create a statistics report that gets automatically updated as data is put into a corresponding worksheet. So this being said, there's no telling how much data will be put into the database, so I need to reference entire columns (A:H),…
KayleeSeranada
  • 13
  • 1
  • 1
  • 3
1
vote
2 answers

Copy calculated date value as real date

I have calculated date ranges in excel like: for example I have a date in B2 and substract 120 days from that like that: When I copy the date the formula gets copied and not the date. I tried to copy and "only past values" but then I get weird…
Carol.Kar
  • 4,581
  • 36
  • 131
  • 264
1
vote
4 answers

Why do most spreadsheets contain a hard-coded limit on the number of rows and columns?

Why are programs like Microsoft Excel, Gnumeric and OpenOffice.org Calc designed with hard-coded limits on the number of rows and columns? This seems like an archaic programming technique from when spreadsheets were considered a demanding…
dsimcha
  • 67,514
  • 53
  • 213
  • 334
1
vote
1 answer

Importing CSV to Google SpreadSheet but I need an additional column in the middle of the csv array

I have code listed below of reading in a csv file and putting it into an array to be pushed onto the spreadhsheet. However, the csv file that I will be reading in needs an additional column in the middle to match the dataset in the spreadsheet. The…
user3022370
  • 13
  • 2
1
vote
1 answer

get data from an excel and import in access

I'm tring to import some excel rows in a recordset using vba. I use the following connection string "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\vmware-host\Shared Folders\Luca\Desktop\barcode ean.xlsx;" & _ "Extended Properties=""Excel 12.0…
calabreseluca
  • 13
  • 4
1 2 3
…
99
100