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

"OLE2 signature is invalid" when trying to parse XLS file

I'm trying to upload and parse an .XLS file. I've tried with roo-xls and Spreadsheet, but with both, I'm getting this error: Ole::Storage::FormatError in UploadController#upload OLE2 signature is invalid I found a few resources about this error,…
Joe Morano
  • 1,715
  • 10
  • 50
  • 114
6
votes
4 answers

Are there any open-source spreadsheet implementations in Smalltalk which are used for production level work?

If nothing exists matching this description, what's the closest I can get?
blueberryfields
  • 45,910
  • 28
  • 89
  • 168
6
votes
1 answer

Referencing a sheet by index number

I've got a LibreOffice Calc spreadsheet that I use to keep track of my accounts receivable at work. Each sheet lists invoices and their status (paid, unpaid, etc) as well as info about each invoice. I'm trying to create a Summary sheet that lists…
Lee Blake
  • 341
  • 1
  • 2
  • 15
6
votes
2 answers

iterate row by row COUNTIF using ArrayFormula on Google Sheets

I am trying to iterate a COUNTIF formula that counts the number of cells in each row containing numbers greater than 4. I am trying to use ArrayFormula to do this but it isn't working. Unfortunately it counts ALL the cells matching the condition…
herteladrian
  • 381
  • 1
  • 6
  • 18
6
votes
1 answer

I got this message (CANNOT_GROUP_WITHOUT_AGG) from a simple query

I how to fix this error message? Unable to parse query string for Function QUERY parameter 2: CANNOT_GROUP_WITHOUT_AGG I got that error message just from a simple query formula, I already tried to search about it and try with the curly bracket {…
Khrisna Gunanasurya
  • 71
  • 1
  • 1
  • 3
6
votes
0 answers

Possible to populate a Google Form's Questions with a Spreadsheet / CSV?

I have scoured the internet, and although I am fairly sure this just isn't possible yet due to the design of forms by google, but if anyone has a way to do it, be it through running a script or just a clever work around, it would help me so…
Dan
  • 792
  • 1
  • 7
  • 17
6
votes
3 answers

Google spreadsheet, comparing durations

I calculated a duration between two times, e.g. between 9:00 am and 11:00 am. So far so good. Now I need to decide if this duration is less 6 hours. I do remember that this was pain in the s in excel but nevertheless I tried it the simple…
herrwolken
  • 389
  • 1
  • 4
  • 12
6
votes
2 answers

How to Append and Format Row at same time Google sheet API

I want to appended in google sheet. i write a code and it successfully worked in JavaScript. function appendMajor() { var responseJson ='{values : [["3/2/2017 13:38:32","3/2/2017","12:33:00 PM","ABC","xyz","pqr","bca"]] }'; …
janisunny
  • 61
  • 4
6
votes
3 answers

How to tell if a cell exists on another Google Sheet

I have 12 sheets in one Google Sheets document labeled for each month (January - December). On each sheet column A contains a project number, e.g. "6091". I'm trying to find a function that will check all of the other sheets to see if there are…
Michael
  • 79
  • 1
  • 2
  • 3
6
votes
5 answers

How to make cells read-only in spreadsheets?

I'm populating a spreadsheet with Database values. The cells that I fill data with, I want them to be read-only to the users. How can I do this?
gizgok
  • 7,303
  • 21
  • 79
  • 124
6
votes
1 answer

Axlsx merge cells based on row-column number like in Spreadsheet gem

I have been using the Spreadsheet gem to write xls files. With the Spreadsheet gem, merging the cells can be done dynamically based on the row and column number like this merge_cells(start_row, start_col, end_row, end_col) My Code snippet …
Yugendran
  • 172
  • 2
  • 9
6
votes
2 answers

How to format spreadsheet columns using ColdFusion?

I am using SpreadsheetFormatColumns() to format the columns in a spreadsheet to "text", but I don't know how to do this, all the formats in the livedocs are for numbers, currency or dates... is there something…
raulriera
  • 714
  • 10
  • 28
6
votes
1 answer

spreadsheet mode for emacs for tab-delimited text files

what is the correct way to view and edit tab-delimited text files in emacs, as if they were a spreadsheet? if I write tsv files in emacs by using C-q TAB, it has the annoying quirk that tabs are not equispaced. It would be nice to be able to edit…
lgd
  • 1,472
  • 5
  • 17
  • 35
6
votes
2 answers

how to set formula for cell data for (export to .xlsx) SheetJS js-xlsx: https://github.com/SheetJS/js-xlsx

Refering this example https://github.com/SheetJS/js-xlsx/blob/master/tests/write.js , it doesn't have any implementation for cell formula in xlsx spreadsheet I tried using cell.f = "=SUM(A1+B1)" for the cell C1 and cell.v as the summation value…
neeraj
  • 101
  • 1
  • 2
  • 5
6
votes
1 answer

When to switch from Spreadsheet to RDBMS?

I've volunteered with a Non-Governmental Organization to help with their record-keeping at their community centre. At present, there is only one community centre where all their data is stored. However, this is expected to change by the end of the…
Everyone
  • 2,366
  • 2
  • 26
  • 39
1 2 3
…
99 100