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

Roo spreadsheet uploading OLE2 signature is invalid

Right so I've checked out Roo. Great gem and all and have a really basic application that doesn't have no models. And basic controller, class and view and I can't seem to get a spreadsheet to upload as I am getting OLE2 signature is invalid error. I…
user532339
8
votes
1 answer

Export to excel with React and SheetJS

I am trying to implement export to excel with React and SheetJs library. Looks like I can download it, but the actual output does not look as expected. I receive array of object and use XLSX.utils.json_to_sheet([data]) API to converts an array of…
Palaniichuk Dmytro
  • 2,943
  • 12
  • 36
  • 66
8
votes
0 answers

Insert a image in a excel worksheet using xlsx - Node.js

Good day everyone, I'm looking for anyone that can help me to solve my problem. I am trying to save an chart generated using chart.js into an excel file. Right now, I am able to save it as an png but I have no idea how to insert it in my xlsx…
TheOneWhoMightKnow
  • 83
  • 1
  • 1
  • 5
8
votes
1 answer

Format a text on cell in two color in Coldfusion

Using Coldfusion 10, I need to format a cell contents in two color(Black and Blue). Let a cell on spreadsheet contains a string "Text1: Text2". where color of "Text1" should be black and "Text2" should be blue. I have tried below code, but it…
Prak
  • 815
  • 7
  • 18
8
votes
3 answers

Differences between getRange, getDataRange, and getActiveRange?

If it isn't immediately apparent by the question, I am pretty new to Google Apps Script. I'm trying to write a Spreadsheets function that runs through each row of a form submission sheet in a workbook and update a second sheet/range (in the same…
Maru
  • 91
  • 1
  • 1
  • 5
8
votes
2 answers

Google Sheets Script Parameter for e.g. Button

Is it possible to pass parameters on a signed script? I have a spreadsheet and made a couple of buttons signing functions to each. Sample function: function foo(){ return "bar"; } Calling this function on a cell =foo() returns me bar, signing…
Dwza
  • 6,494
  • 6
  • 41
  • 73
8
votes
3 answers

PaperTrail Manually create version

I have a spreadsheet of items which I convert to CSV and import using a custom import script into my Rails based application. The spreadsheet contains a row for each record but some rows hold different versions of previous rows. When importing the…
rctneil
  • 7,016
  • 10
  • 40
  • 83
8
votes
1 answer

Google Docs Spreadsheet display data from row matching a criteria

Basically, I would like Sheet 1 to pull data FROM Sheet 2, renamed to 'Loot'. However, the data that is pulled from 'Loot' can only be from a specific column, and two other cells in the same row must contain specific data from Sheet 1. Example:…
user2103481
  • 151
  • 1
  • 5
8
votes
4 answers

How can I modify an existing Excel workbook with Perl?

With Spreadsheet::WriteExcel, I can create a new workbook, but what if I want to open an existing book and modify certain columns? How would I accomplish that? I could parse all of the data out of the sheet using Spreadsheet::ParseExcel then write…
user105033
  • 18,800
  • 19
  • 58
  • 69
8
votes
3 answers

Changing cell background color in LibreOffice

I am using LibreOffice 3.5.4.2. I would like to change the background color of cells based on various conditions. As a minimal example, I have the following macro/function defined: function bgcolor() Dim Doc As Object Dim Sheet As Object Dim Cell As…
SabreWolfy
  • 5,392
  • 11
  • 50
  • 73
8
votes
3 answers

PHP - Read-Only spreadsheet filetype?

I'm using a simple web-based PHP application that outputs a table as a spreadsheet header("Content-Disposition: attachment; filename=" . $filename . ".xls"); header("Content-Type: application/vnd.ms-excel"); //inserts tab delimited text But I'm…
jjclarkson
  • 5,890
  • 6
  • 40
  • 62
7
votes
2 answers

currency number format using spreadsheet gem

I 'm using Spreadsheet gem to create excel sheet. how can I apply 'currency' number format to a particular cell ?
Rutvij Pandya
  • 71
  • 1
  • 3
7
votes
3 answers

ruby spreadsheet row background color

I am trying to parse an excel spreadsheet using "spreadsheet". How could I get the background color of each row?
fflyer05
  • 873
  • 11
  • 18
7
votes
2 answers

How to stop / freeze / pause volatile RAND / RANDBETWEEN / RANDARRAY?

is there an easy way (workaround) how to disable automatic re-calculations of volatile functions like =RAND() =RANDARRAY() =RANDBETWEEN() in google spreadsheet (?) without scripts without addons without macros in case of building a key generator,…
player0
  • 124,011
  • 12
  • 67
  • 124
7
votes
1 answer

How can I format a specific cell using the Ruby Spreadsheet library?

Formatting a column or row seems to be no problem. I've poked around the documentation a bunch, did some searches, and looked through the "methods" result on some spreadsheet objects and I can't figure out how to format a specific cell. Has anyone…
Tony
  • 18,776
  • 31
  • 129
  • 193
1 2 3
…
99 100