Stack Overflow
Stack Overflow

Questions tagged [cell]

A cell is an atomic element within a structure composed of columns and/or rows, such as a table or grid. For questions regarding cell arrays in MATLAB, the tag [cell-array] should be used.

Cell is a basic term that was introduced by spreadsheet programs like Excel, Lotus, etc.. It is also associated with tables in HTML and Word documents.

Cells can contain hard-coded values, computed values based on functions, visualizations based on computed values, or external objects.

For questions regarding cell arrays in MATLAB, the tag should be used.

References

5093 questions
43
votes
13 answers

How to disable Excel's automatic cell reference change after copy/paste?

I've got a massive Excel 2003 spreadsheet I'm working on. There are a lot of very large formulas with a lot of cell references. Here's a simple example. ='Sheet'!AC69+'Sheet'!AC52+'Sheet'!AC53)*$D$3+'Sheet'!AC49 Most of them are more complicated…
Bat Masterson
  • 1,164
  • 3
  • 11
  • 27
43
votes
3 answers

Google Spreadheets Scripts: check if cell is empty

I want to input a variable in a cell only if the cell is empty. The if statement, however, does not work. Any advice? var ss=SpreadsheetApp.getActiveSpreadsheet(); var r=ss.getRange("'odpovědi'!A2:J"); var rws=r.getNumRows(); ax=r.getCell(rws-1,…
orobinec
  • 445
  • 1
  • 4
  • 5
38
votes
5 answers

Changing datagridview cell color dynamically

I have a dataGridView object that is populated with data. I want to click a button and have it change the color of the background of the cell. This is what I currently have foreach(DataGridViewRow row in dataGridView1.Rows) { …
fifamaniac04
  • 2,343
  • 12
  • 49
  • 72
34
votes
4 answers

Get value of a merged cell of an excel from its cell address in vba

How to get the value of a merged cell of an excel having range address like "$B$4:$B$11" in vba
skmaran.nr.iras
  • 8,152
  • 28
  • 81
  • 116
34
votes
8 answers

UITableViewCell separator not showing up

I made a custom UITableViewCell in IB, but for some reason, despite the single line option for separator being selected, there are no separator lines on my table. Has this happened to any of you before? What gives? Thanks!
Dexter
  • 5,666
  • 6
  • 33
  • 45
34
votes
24 answers

How to get a jqGrid cell value when editing

How to get a jqGrid cell value when in-line editing (getcell and getRowData returns the cell content and not the actuall value of the input element).
raouf
  • 585
  • 1
  • 5
  • 8
33
votes
1 answer

How to use keyboard to drop-down a menu in an excel cell?

I have a drop-down menu created in an excel cell. Everytime I want to enter a value in that cell, after I navigate the focus to that cell using keyboard, I am not able to drop the drop-down menu using keyboard. I have to click the downward pointing…
Jay
  • 1,210
  • 9
  • 28
  • 48
30
votes
2 answers

min-height and table cells

I've done a little bit of research on this, but I just wanted to ask to people who'd know much better than I. Is it true that setting a height to a table cell only acts as min-height? I know this is true in Firefox, but what other browsers does this…
That Guy
  • 331
  • 1
  • 3
  • 7
28
votes
6 answers

NSTableView: detecting a mouse click together with the row and column

I'm trying to detect when a mouse click occurs in an NSTableView, and when it does, to determine the row and column of the cell that was clicked. So far I've tried to use NSTableViewSelectionDidChangeNotification, but there are two problems: It…
bright
  • 4,700
  • 1
  • 34
  • 59
27
votes
6 answers

SSRS Field Expression to change the background color of the Cell

I'm trying to write a field expression for a Cell in my report where I have to change the background color of the cell depending on the string value in the cell. Ex: if the column has a value 'Approved' in it, the cell should show a green background…
Avinash
  • 1,273
  • 4
  • 16
  • 23
27
votes
4 answers

iTextsharp, PdfPCell.VerticalAlignment and PdfPCell.HorizontalAlignment

Im trying to figure out how to get my text inside a PdfPCell to show in the middle. I have tried many different options, like: myCell.VerticalAlignment = Element.ALIGN_MIDDLE; myCell.VerticalAlignment =…
Jimmy
  • 393
  • 1
  • 3
  • 6
26
votes
3 answers

How do I select a single cell in a WPF datagrid?

When I click a cell in a WPF datagrid, the whole row is selected, and when I press Ctrl + C to copy the content, the whole row i copied... How do I select and copy the content of a single cell?
epsen
  • 263
  • 1
  • 3
  • 5
24
votes
4 answers

Want to create a cool static UI but : "Static table views are only valid..."

I'm creating a view like: For this I'm trying to use a Storyboard in which I add 2 TableViews (both as 'Static Cells') and then I manually add my Cell content directly from the storyboard... In my storyboard it looks great but when I build I…
Cehm
  • 1,502
  • 1
  • 12
  • 14
24
votes
3 answers

Get UITableviewCell position from "visible" area or window

I create an iPhone app base on uitableview and uitabbar. On each cell of tableview i have an "add to favorite button". When i pressed this button, i want to make the cell "jump" from her position to the favorite item of the tabbar (same as download…
Mickael
  • 271
  • 1
  • 3
  • 8
24
votes
9 answers

Excel doesn't update value unless I hit Enter

I have a very annoying problem in one of my worksheets in a workbook. I am using EXCEL 2007. Any cell's value will not be updated unless I hit ENTER. Either if the formula in the cell includes an if condition, or a VLOOKUP function or even an…
Thanasis
  • 695
  • 1
  • 4
  • 17
1
2
3
…
99 100