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

MATLAB: Is it possible to overload operators on native constructs (cells, structs, etc)?

I'm using cells to manage data in some stuff I'm working on. I'd like to be able to do things like: A = cellfun( @(X)( randn( 5,5 ) ), cell( 5,1 ), 'UniformOutput', 0 ); B = cellfun( @(X)( randn( 5,5 ) ), cell( 5,1 ), 'UniformOutput', 0 ); %# %#…
17
votes
1 answer

Stop Jupyter notebook from generating new blank cells after every alt-enter (run)

I am new to Jupyter notebooks. I have got into a habit of keeping parts of my code in different cells. Now every time a run a cell a new cell is added right after the last cell. So after a few runs I have many blank cell. Is there a way to restrict…
cryp
  • 2,285
  • 3
  • 26
  • 33
17
votes
4 answers

GWT CellTable - set column width

Is it possible to set the column width of CellTable in GWT?
Opal
  • 81,889
  • 28
  • 189
  • 210
17
votes
5 answers

javafx GridPane retrieve specific Cell content

I want to retrieve the content of one specific cell in a Gridpane. I have put buttons in the cells with the setConstraints(btt , 0 ,1 ) setConstraints(btt , 0 ,2 ) getChildren().add.... In my case the GridPane.getChildren.get(10) is not good. I…
Elias Elias
  • 419
  • 3
  • 6
  • 10
17
votes
8 answers

Fullcalendar: Change the color for specific days

I'm stuck with a project I get at work. I need to change the background color of some days. It's a calendar where the user should see, which days are available and which not. I found out that there is an attribute called "data-date", but I didn't…
Dr. Gadget
  • 303
  • 1
  • 3
  • 10
16
votes
3 answers

How to use VBA to make a cell in Excel 2007 transparent

I currently have: Range("Z1").Interior.Color = RGB(255, 255, 255) But this wipes out the borders of the cells. Instead I'd just like to set the transparency of the cells in range to 1.0. The docs seem to suggest it doesn't exist (?). Thanks!
AJP
  • 26,547
  • 23
  • 88
  • 127
16
votes
3 answers

Table cells fixed height regardless the content of the cell

I have a dynamic table that I generate after getting some inputs from the user to present some tabular data. I need to know if there is away to assign a fixed height for the cells even if some of them have some content / text. I would like all the…
digitup
  • 537
  • 2
  • 6
  • 18
16
votes
2 answers

What does the "s" attribute signify in a cell tag in XLSX

In the XML of a worksheet in an XLSX file (Excel 2007) cell tags that have a "t" attribute equal to "s" are string types. The value tag inside the c needs to be looked up and converted via the sharedStrings document. But, some cells have s="237"…
chugadie
  • 2,786
  • 1
  • 24
  • 33
16
votes
2 answers

How to read from merged cells of Excel in Java using Apache POI?

I have a Excel file in .xlsx format. I have stored data by merging cells to form various columns. I am reading the Excel file via a Java web application and saving its data to a database (MySQL). But when I read from merged cells I get null values…
Saber
  • 167
  • 1
  • 2
  • 6
16
votes
3 answers

How to get a cell value in JQGrid?

How to get a cell value in JQGrid? If I use the following syntax – var ret = jQuery("#MyGrid").jqGrid('getRowData', id); ret = ret.ProductId; it returns the following HTML. 'input class="editable" name=" ProductId " id="0_ ProductId " style="width:…
dev
  • 161
  • 1
  • 1
  • 4
15
votes
4 answers

Change the background of Cells with C#

I'm developing an program using C# to manipulate an Excel document, and I'm using Microsoft.Office.Interop.Excel._Worksheet worksheet; When I insert something to a x,y cell I use : worksheet.Cells[x, y] = "something"; Now I want to know if…
Wassim AZIRAR
  • 10,823
  • 38
  • 121
  • 174
15
votes
4 answers

How to make UITableview with Textfield in swift?

I want to make a table view with textfields in each cell, I have a custom class in a swift file: import UIKit public class TextInputTableViewCell: UITableViewCell{ @IBOutlet weak var textField: UITextField! public func configure(#text:…
Zablah
  • 332
  • 2
  • 3
  • 15
15
votes
10 answers

python docx set table cell background and text color

I am using python 2.7 with docx and I would like to change the background and text color of cells in my table based on condition. I could not find any usefull resources about single cell formatting Any suggestions? Edit 1 my code style_footer =…
Yebach
  • 1,661
  • 8
  • 31
  • 58
15
votes
1 answer

NPOI setting different cell format

i have problem setting different format in each cell, i want to set number format to thousand separator and thousand separator with 3 decimals, when number is not integer, here is my code, i think problem look like each cell format is set by last…
Kazenga
  • 476
  • 1
  • 4
  • 15
15
votes
3 answers

How to delete Certain Characters in a excel 2010 cell

In column A I have a load of name that look like this [John Smith] I still want them in A but the [] removed...
Hope T-p
  • 159
  • 1
  • 1
  • 3