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

Is it possible to write in an existing spreadSheet with PhpSpreadSheet?

I'm currently using PhpSpreadSheet Library and I wanna write into an existing spreadSheet. Is that possible? If yes, how? I didn't see any possibility in the documentation. Thanks!
Alexandre Corvino
  • 199
  • 1
  • 3
  • 16
5
votes
5 answers

Spreadsheet data - linked list or hashmap?

I am looking to implement a spreadsheet in java. Would it be better to use a linked list (rows) of linked list of cells (columns) to store the data or a hashmap (each cell maps to a key e.g. A1 -> 1, A2-> 2 etc.)? Or is there an even better data…
Java User
  • 51
  • 1
  • 2
5
votes
2 answers

Do i need to have office installed to use Microsoft.Office.Interop.Excel.dll

I'm trying to develop a new app to process excel files.As far as i know -in order to use the Built in Excel Manipulation functionality i need to have Microsoft Office installed (i'm i right)? Or can i just download the dll …
techno
  • 6,100
  • 16
  • 86
  • 192
5
votes
4 answers

How can I store a range of cells to an array?

If I have a list of data in cells A1:A150 (but the amount can vary), is there a way to push that into an array without looking at each cell individually to determine if it is empty? I exceed my execution time by doing this and I need a faster way to…
Aaron
  • 3,135
  • 20
  • 51
  • 78
5
votes
5 answers

How can i recreate a spreadsheet or sharepoint datasheet view on a website?

I am trying to migrate users off of a sharepoint solution into a website + SQL backend. The one thing is that everyone seems to like the sharepoint view and the data sheet view for editing and managing information. what is the best spreadsheet /…
leora
  • 188,729
  • 360
  • 878
  • 1,366
5
votes
1 answer

Copy/paste data validation in Google Spreadsheets

I feel a bit silly not being able to figure this out. So this is the data validation I have set up: Cell Range: Journal!J2 Criteria: List from a range - Journal!W2:X2 Cell Range: Journal!M2 Criteria: List from a range - Journal!Y2:AA2 This is great…
Stephen Synowsky
  • 111
  • 1
  • 1
  • 8
5
votes
3 answers

How do I set the number of decimals in a Numbers cell using AppleScript?

I can set the format of a cell in a Numbers spreadsheet using: tell application "Numbers" activate tell document 1 tell active sheet set the selectedTable to ¬ (the first table whose class of selection…
Daryl Spitzer
  • 143,156
  • 76
  • 154
  • 173
5
votes
2 answers

Is there a free spreadsheet or spreadsheet-like control for Visual C++/ VB.Net?

I've been wanting to put together a simple little app that'll let me create simple spreadsheets; just entering data into a grid, maybe with a little basic font/cell/border formatting in there for good measure if possible. In other words, I want to…
Sean D
  • 159
  • 1
  • 3
5
votes
1 answer

What is worksheet.Cells(row,col).Formula

I was watching a tutorial for comparing two excel worksheets and came across this: cellVal1 = ws1.Cells(row, col).Formula In the video he says that this assigns the value of the specified cell to the cellVal1. I've only seen people use…
Justin L.
  • 993
  • 14
  • 33
5
votes
3 answers

Extract hyperlink from Open Office Calc Sheet

I have an Open Office Calc Sheet with a column full of data that has hyperlinks. I wish to trasnfer the hyperlinks to another column. How do I extract them? Thanks.,.
Ali
  • 4,311
  • 11
  • 44
  • 49
5
votes
2 answers

Need more examples on how to use Spreadsheet::ParseExcel

I have been using the Spreadsheet::ParseExcel to list the contents of spreadsheet. I've seen several examples on how to dump the entire spreadsheet. I really would like to see how to use this script more selectively. The example below from IBM…
XL.
  • 1,390
  • 4
  • 11
  • 13
5
votes
2 answers

Access Google-apps public spreadsheet via Javascript

Spent a bunch of time looking at this.. It seems that what little info there was about accessing a Google-apps spreadsheet is not very well maintained.. At Google IO this year there was an announcement of enhanced Google-apps script. Including UI…
dartdog
  • 10,432
  • 21
  • 72
  • 121
5
votes
1 answer

How to make an invisible character in HTML, that still get's picked up on text selection?

Backstory So I am doing a webchat as a side-project, and one of the issues I am encountering is making the UX of copying and pasting messages friendly. Right now all of the elements are organized within their own tags, spaced out and separated with…
Luiz Berti
  • 1,421
  • 1
  • 15
  • 24
5
votes
4 answers

What is the easiest way to display an editable list(like a spreadsheet) in HTML?

We have a requirement to display an editable list in a web page. What would be the easiest way to do that? Farpoint Spread was something I have used to achieve this earlier but it was quite slow when a large number of records were involved and it…
sarego
  • 2,957
  • 6
  • 28
  • 39
5
votes
0 answers

Vim-like command-line spreadsheet SC - How do you deal with the lack of Undo feature?

I'm looking for a command-line spreadsheet and so far sc is my best find (I explain why at the end of this message). But the lack of Undo feature is killing me. How do you deal with the lack of this vital missing feature? Right now, when I make a…
mascip
  • 1,347
  • 1
  • 14
  • 16
1 2 3
…
99 100