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
10
votes
1 answer

Open spreadsheet xml in Excel by default

In a web application, I am generating a spreadsheet XML using an XSL template created from Excel 2010. I want this spreadsheet XML to open in Excel by default. So, I add the below properties to the response Response.ContentType =…
itsbalur
  • 992
  • 3
  • 17
  • 39
10
votes
2 answers

Google Sheets Filter with IN clause

Question: In Google Sheets, using only the built-in functions, how do I write a filter to exclude records based on a column in each row not being present in a list of valid values from another range. Details I am using Google Sheets to write a…
TwitchBronBron
  • 2,783
  • 3
  • 21
  • 45
10
votes
1 answer

java.lang.ClassCastException: com.google.gdata.data.TextContent cannot be cast to com.google.gdata.data.OutOfLineContent

I would slide all cell in a sheetwork , but I don't resolve. My code is: SpreadsheetService service = new SpreadsheetService("MyApp"); try{ URL SPREADSHEET_URL = new…
mc_marad
  • 179
  • 1
  • 1
  • 10
10
votes
3 answers

How can I filter my search in a column on google sheet which collects data from a form?

I would like to perform a multi criteria search of data in a column- contains data of check boxes(more than one option chosen). For a clearer picture of what I am trying to do, screenshot below is a question in a form Data from the form are saved…
lily
  • 385
  • 1
  • 3
  • 21
10
votes
3 answers

How to extract sheet from *.xlsm and save it as *.csv in Python?

I have a *.xlsm file which has 20 sheets in it. I want to save few sheets as *.csv (formatting loss is fine) individually. Already tried xlrd-xlwt and win32com libraries but could not get through. Can anybody please provide a code snippet which…
iPirate
  • 113
  • 1
  • 1
  • 6
10
votes
2 answers

Send Email when value changes in Google Spreadsheet

I am trying to figure out, how do the following in Google Spreadsheet. Send email when a value changes in a cell. (Value = Completed). Compile that rows data into the email. See format in code below. Prompt user for confirmation of info. If YES,…
WallyG
  • 187
  • 1
  • 6
  • 16
10
votes
4 answers

Excel spreadsheet like library in Swing (=improved JTable)

I'm searching for a free, open-source if possible, Java swing library that improves the existent JTable (which is very simple). I want to do an application with a spreadsheet similar to Excel one. Without the formula but with copy/paste…
Damien
  • 583
  • 3
  • 7
  • 18
10
votes
2 answers

Reading time values from spreadsheet using poi api

I am trying to read a date column and a time column from a spreadsheet. I am able to retireve the date column from the sheet, but not the time column. For example, my sheet will have rows of the form: date time 11/2/2012 …
CuriousCoder
  • 1,582
  • 5
  • 28
  • 55
10
votes
2 answers

What difference does it make if one runs a VBA code in "Sheets", in "ThisWorkbook", and in "Modules"?

What difference does it make if one runs a VBA code in "Sheets" ("Sheet1", "Sheet2", etc.), in "ThisWorkbook", and in "Modules" ("Module1" etc.)? In other words, which one should be used in which cases?
Mehper C. Palavuzlar
  • 10,089
  • 23
  • 56
  • 69
9
votes
3 answers

Why doesn't 1="1" in Excel, but "a"="A"?

I was wondering if anyone when why the decision was made in Excel (or maybe it was made before Excel and Excel later adopted it) that strings are compared case-insensitively and strings are always considered different than numbers. For…
David542
  • 104,438
  • 178
  • 489
  • 842
9
votes
1 answer

Keyboard navigation in GWT CellTable

We are attempting to create an editable grid using CellTable. The use case is fairly high volume data entry for accountants who are used to 10-key entry into spreadsheets. We are trying to replicate spreadsheet- style keyboard navigation as closely…
piehole
  • 323
  • 2
  • 7
9
votes
1 answer

Using open XML to create excel file

I am trying to use Open XML to create a file but when trying to add just the first row of headers the file is being corrupted and I am unable to open, can anyone tell me what I am doing wrong here? using (SpreadsheetDocument spreadsheetDocument =…
Jay
  • 3,012
  • 14
  • 48
  • 99
9
votes
4 answers

Excel VBA code to select non empty cells

In Excel, let's I have data in B2 to B7 and C2 to C7 . In VBA I can write a macro to select it: Sub Macro1() Range("B2:C7").Select End Sub How do I rewrite the code so that it chooses automatically the cells that are non-empty? If I delete the…
k.dkhk
  • 481
  • 1
  • 11
  • 24
9
votes
4 answers

How to trim starting spaces of entire column in LibreOffice or Google sheets?

I'm a bit of a newbie at this, so hope to get some help. I have a large spreadsheet where columns C and D each have a blank space before the data in each column. Can some one please explain me how to trim an entire column to remove starting spaces…
Atchyut Nagabhairava
  • 1,295
  • 3
  • 16
  • 23
9
votes
2 answers

cfscript equivalent of cfspreadsheet action="read"

What is the equivalent of this... in cfscript? cfscript has spreadSheetRead(fileName) - but the result is an object with the file metadata, Even if I specify the sheet,…
j-p
  • 3,698
  • 9
  • 50
  • 93
1 2 3
…
99 100