Search Results

Search found 3437 results on 138 pages for 'cell'.

Page 12/138 | < Previous Page | 8 9 10 11 12 13 14 15 16 17 18 19  | Next Page >

• Excel: Cell Value as Excel Document Metadata Property

  - by mjlefevre

  I know you can add custom Document Properties in Excel 2007. see: http://office.microsoft.com/en-us/excel/HA100475241033.aspx#5 But I thought there was a way to pull a value from a cell as a custom metadata property without code. Maybe I'm searching for it with the wrong terminology. Maybe it has to be done as a Named Range. I know this can be…

  Read the article

• Excel changing decimal places on number cells when I edit the cell's formula

  - by IanC

  I have a worksheet with thousands of number cells, all formatted "Number, 3 decimal places, use 1000 Separator ()". Starting a few days ago, if I edit a formula in any of these cells to reference another cell, Excel will change the decimal places to 14. For example, "=C$53^$B$4" = "=C$53^$B$10" will cause this. I am not aware of any settings…

  Read the article

• VBA code to hide or unhide rows based on a cell value

  - by I AM L

  Heres my code, but its not really doing anything, I dont see anything wrong with it: Private Sub PG1(ByVal Target As Range) If .Range("E50").Value = "Passed" Then Rows("51").EntireRow.Hidden = True End If ElseIf Range("E50").Value = "Failed" Then Rows("51").EntireRow.Hidden = True …

  Read the article

• Split cell value into multiple cells

  - by wilhelmtell

  How do I get Excel to split a sequence of delimited values in a cell over multiple cells? | A | B 1| 1 2 4 | 2| | Split over /\s+/: | A | B 1| 1 | 2| 2 | 3| 4 | This is in a pivot table, so I want the pivot table's mechanism to take the split in account, and consider it as if the data came this way…

  Read the article

• How to code Microsoft Excel "Shift Cells Up" feature in SQL

  - by user293249

  Take a simple table like below: Column Headings: || Agent's Name || Time Logged In || Center || Row 1: Andrew || 12:30 PM || Home Base Row 2: Jeff || 7:00 AM || Virtual Base Row 3: Ryan || 6:30 PM || Test Base Now lets say that a single cell is deleted so the table now looks like this: Column Headings: || Agent's Name || Time Logged In ||…

  Read the article

• remove image from tableViewCell created programatically

  - by Ruthy

  Hello, I would like to move an imageView contained on a cell and it works but creating a new image at new position keeping old image (then two are shown). How could I remove old one?? used code: UIImage *cellImage = [UIImage imageNamed:(@"%@", showIconName)]; UIImageView *imageViewToPutInCell = [[UIImageView alloc]…

  Read the article

• excel number format - varying decimal digits

  - by Alexxx

  I'm trying to set a special cell number format with theses rules: display percentage display at max 3 digits (decimal + integer part) So I can display 100% or 99.3% or 1.27% but not 100.9% or 100.27% or 99.27%. Of course, I can have negative number (-27.3%) and it does not affect my rules. I've try with the cell…

  Read the article

• Jqgrid set cell background color

  - by sachin

  In "Custom data tooltips in jqGrid 3.4" discussion, came to know how to use setcell to change the color of the text inside a cell of jqgrid. How can we change the background color of the cell? Tried the following jQuery("#list").setCell (row,col,'',{ background-color:'red'}) jQuery("#list").setCell (row,col,'','',{…

  Read the article

• jQTouch animated table cell hight

  - by Brett

  Hi everybody, I am using jQTouch to show a table list. When a cell (really a < li tag in jQTouch) is clicked, I would like to animate the height of the cell down to 0, then hide the element. I have tried using jquery.animate() for this, and it works on firefox/chrome/opera, but it is super slow on the iPhone. …

  Read the article

• DataView boolean cell

  - by Nilbert

  How would I add a cell to a DataView that was toggleable between True and False like the dataview in the Microsoft Visual C# properties window? I can only find a way to add a text box type cell to it, but I need to add a toggleable one, and also a dropdown list type. Thanks for any help.

  Read the article

• C# DataView boolean cell

  - by Nilbert

  How would I add a cell to a DataView that was toggleable between True and False like the dataview in the Microsoft Visual C# properties window? I can only find a way to add a text box type cell to it, but I need to add a toggleable one, and also a dropdown list type. Thanks for any help.

  Read the article

• didSelectRowAtIndexPath does not get called when scrolling and selecting a cell

  - by Falcon

  Hi all, It seems when I scroll my table view that if I select a cell while the table view is still scrolling, didSelectRowAtIndexPath doesn't get called. It works fine when the table view is still. Any ideas on why this might be? Also, is there a way that didSelectRowAtIndexPath can be called on press down? It…

  Read the article

• jqGrid cell editing need to position the error message dialog

  - by Harv

  I'm using jqGrid with cell editing. I have setup the colModel properties using the editrules option. Everything works fine in that if I edit a cell and try to save an invalid value the grid displays an error dialog, but I need to know how to position the error message dialog that comes up because in the case of…

  Read the article

• Get content of a single cell from a DataGrid in Flex 3

  - by Captain Phoenix

  I want to select information in a single cell from my DataGrid in Flex 3. Specifically, I'm displaying three phone numbers per line and the user needs to be able to select one of those numbers, from any row, but not the whole row. While similar to this, I am displaying the DataGrid to the user. The answer for…

  Read the article

• php PHPExcel split Excel cell coordinate

  - by Shiro

  currently, I used PHPExcel to import excel file, there is a function $cell-getCoordinate(); I would like to ask any solution for split the cell coordinate alphabet and integer? e.g A1, A2, I need to know currently which row, and until which column. I do some research about split, but not luck for it. Any…

  Read the article

• html table with slash splitting the leftup cell

  - by Tim

  Hi, I wonder how to write in html a table with slash splitting the leftup cell? i.e., for the leftup cell in the table, there is a diagonal line splitting it into two parts, with some texts on either sides. Thanks and regards!

  Read the article

• New line in GridView cell

  - by Chris

  I'm binding a GridView to an LINQ query. Some of the fields in the objects created by the LINQ statement are strings, and need to contain new lines. Apparently, GridView HTML-encodes everything in each cell, so I can't insert a <br /> to create a new line within a cell. How do I tell GridView not to…

  Read the article

• how to insert an object into a cell using JXL api

  - by sushil

  how to insert an object into a cell using JXL api.. i have a file which is not image.. i want to insert it into a cell of Excel sheet.. how can i achieve this?? please help...

  Read the article

• Macro to alert me when a cell changes value -- popup alert - EXCEL

  - by patrick

  Hey gurus, I am looking to create a macro to alert me when a cell's value changes. The cells in this particular column can have values of either "OVER" or "UNDER". I would like to write code to alert me via a popup (Message: "Cell A crosses under(over)") when the value changes. Thanks, patrick

  Read the article

• How to implement a custom cell renderer for ScrollTable in GWT

  - by tronda

  I've used the ScrollTable widget for GWT and I have a need for a custom cell renderer so I can isolate this code from the rest of the app. I would like to use generics if possible to get it type safe. This cell renderer will take a long as a value and do some calculation before displaying the result.…

  Read the article

• Cell value is read as #### in excel

  - by Sathish

  I am reading a cell value from excel using named range in my case sometime the column width is smaller then the value that is present in the cell and hence it is appearing as ##### when it is huge number. when i read this from csharp it is reading as #####. Any fix for this

  Read the article

• How can i change the edit mode of a cell in my Gridex Janus Table

  - by oz radiano

  Hello, I'm trying to create a Janus gridex which every cell has different edit mode. For instance, one cell will be comboBox edit mode and the second one will be free text How can it be done? Thanks in advance, Oz.

  Read the article

• How to edit cell of type Linkcolumn in a gridview

  - by Royson

  I have a gridview control having 4 columns. one of the column is of type linkcolumn. user has to enters data for each column. How can we edit link column cell. if i click on this cell nothing happen.i set its readonly to false also.

  Read the article

• Public Cell ID databases

  - by Alejandro Mezcua

  Hi. I'm building a location aware mobile application which uses GPS, but i'd like to be able to add cell location too. The best thing I have found so far is to use Google Gears, which has a location API available, but my application is not web based. Are there any good public cell id databases that…

  Read the article

• disable scrolling to cell in focus

  - by Victor

  I have a jtable inside of a scrollpane. how can i stop the scrollpane from scrolling up or down when a cell that is partly out of view gains focus? the problem is i am setting the cells to editable when the user mouses over them, so when you mouse over a cell that's partly out of view, the view…

  Read the article

< Previous Page | 8 9 10 11 12 13 14 15 16 17 18 19  | Next Page >