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

Importing Excel spreadsheet data into another Excel spreadsheet containing VBA

We need to write an Excel spreadsheet with VBA code in it; the code reads and performs operations on the data in the first worksheet. The user will be receiving spreadsheets containing data but that do not contain the VBA code. We need to be able…
Anthony
  • 692
  • 3
  • 9
  • 23
13
votes
3 answers

How to generate an Excel file with Rails?

I was searching Ruby toolbox for a popular, well-supported tool to generate XSLX (Excel 2007 and on) document, but I didn't manage to find anything. I also spent a good amount of time searching on Google, but most of the answers I found seem…
Yuval Karmi
  • 26,277
  • 39
  • 124
  • 175
13
votes
3 answers

Open Office Spreadsheet (Calc) - Concatenate text cells with delimiters

I am using Open Office's spreadsheet program and am trying to concatenate several text cells together with delimeters. For example, suppose I have the cells below: +--------+ | cell 1 | +--------+ | cell 2 | +--------+ | cell 3 | +--------+ | cell…
Markus O'Reilly
  • 811
  • 3
  • 9
  • 15
12
votes
5 answers

Data structure used for implementing spreadsheets

What is the data structure used by spreadsheets program like ms-excel?
Prahlad
12
votes
2 answers

Excel - Match substring from list of choices - INDEX, MATCH, and FIND used together

I'd like to search for a specific movie title within a list of video titles, search for MATCH, and use Index to return its description. I know this can be done with a text search in a filter via Column A, but I'd like to do it with a…
James
  • 209
  • 3
  • 13
12
votes
3 answers

Spreadsheet calculations with (at least) the accuracy of a C double

I was doing some calculations for planning an improved implementation of my prime sieve when I noticed that the Libre Office spreadsheet was showing the wrong values for numbers far below 2^53, which is the limit for precise integer calculations in…
DarthGizka
  • 4,347
  • 1
  • 24
  • 36
12
votes
7 answers

How to set background color for a row based on current date in Google Docs Spreadsheet?

I have a Google Docs SpreadSheet, where in the column A are dates (A1: 2013-11-22, A2: 2013-11-23, A3: 2013-11-24 etc). I would like to automatically highlight - set a background color for a row, where in the column A is today's date. To have every…
machj
  • 341
  • 1
  • 3
  • 8
12
votes
1 answer

Google Spreadsheet Check From What Cell VLOOKUP() Returns

Is there a way to return the cell from which VLOOKUP() gets its value? For instance: ________A_____|__B__| 1 | Mouse | 1 | 2 | Keyboard | 2 | 3 | Headset | 3 | 4 | HDD | 4 | =VLOOKUP("Mouse",A1:B4,2,FALSE) --would return…
user2706406
  • 123
  • 1
  • 1
  • 4
12
votes
3 answers

How to rotate text in a spreadsheet cell using Apache POI?

How can I rotate the text within an HSSFCell class of Apache POI?
Garudadwajan
  • 689
  • 4
  • 11
  • 24
11
votes
4 answers

Writing to excel files in ruby using roo gem

I am parsing Excel and Excelx file using Roo gem. But I am not sure how to write in those files. set_value(row, column, text) method is not working. Code @oo = Excelx.new('tes.xlsx') @oo.default_sheet = @oo.sheets.first def return_column …
Bhushan Lodha
  • 6,824
  • 7
  • 62
  • 100
11
votes
2 answers

How to insert line break within OPENXML spreadsheet cell?

I'm currently using something like this to insert inline string in a cell : new Cell() { CellReference = "E2", StyleIndex = (UInt32Value)4U, DataType = CellValues.InlineString, InlineString = new InlineString(new Text( "some…
belaz
  • 1,486
  • 5
  • 18
  • 33
11
votes
3 answers

How can I access spreadsheets in the open document format (.ods) with Java?

I want to read, write and create Spreadsheets in the Open Document Format with Java. And I want the resulting Java-program running on a computer without OpenOffice.org or other ODS-capable programs installed. Exists a library to access this format?
Mnementh
  • 50,487
  • 48
  • 148
  • 202
11
votes
8 answers

Getting an array of column names at SheetJS

I'm trying to parse an Excel spreadsheet (.xlsx) into JSON. I'm using the SheetJS node package for it. However I can't realize such a simple thing as - how do I get a column name in the same format as it is stored internally? Below is my…
Vytalyi
  • 1,637
  • 3
  • 20
  • 33
11
votes
10 answers

How to get excel to display a certain number of significant figures?

I am using excel and i want to display a value to a certain number of significant figures. I tried using the following equation =ROUND(value,sigfigs-1-INT(LOG10(ABS(value)))) with value replaced by the number I am using and sigfigs replaced with…
Veridian
  • 3,531
  • 12
  • 46
  • 80
11
votes
1 answer

Calculating Duration in org mode table

I'm trying to figure out how to to use org-mode to calculate the duration between two time points, however, whilst I figured out how to do it for two separate dates, when I add in the time component, it gives an answer, but I'd rather have the…
Nathaniel Saxe
  • 1,527
  • 2
  • 15
  • 25
1 2
3
…
99 100