The following VBA code works great in Excel 2003, but results in a "stack overflow error" in Excel 2007. The code is required to either unlock or lock certain cells based on a drop-down menu selection. I need to be able to run the code in both Excel 2003 and 2007. Please help. Private Sub Worksheet_Change(ByVal Target As Range) If [E2...
How can I set an X spacing between html table's columns? Using cellpadding or cellspacing I got vertical spacing too (and I don't want it!). I can't use CSS. Suggestions? ...
I have some data. I want to go through that data and change cells (for example - Background color), if that data meets a certain condition. Somehow, I've not been able to figure it out how to do this seemingly easy thing in Silverlight. ...
In an SSRS Report ,I have a table which has 14 columns, 1st column is 7am and the last column is 7pm. I have 100 records with conference names and the timings, ex: 1) interenational conference 9am to 5pm 2) national conference 8 am to 11 am so the problem is these column cells must merge based on the timings and siplay as one textb...
Hi, Im doin a project using JTable, i want to make my table cells editable. I used, public boolean isCellEditable(int row, int column) { return true; } My problem is, the cells are ediable but once after entering data into one cell and move on to the next, the previous data gets erased... kindly any one help me... ...
I need to import data from an excel file, but some field is a merged cell. How can I determine if a field is merged or not, and how many cells are merged together in that field? My code is like this: Dim Conn, DBPath ,Rs Set Conn = Server.CreateObject("ADODB.Connection") DBPath = "Driver={Microsoft Excel Driver (*.xls)}; DBQ=" & Ser...
Hi, I want to merge two cells in a JXTreeTable. Is this possible? I have read the solution for Merging cells in JTable, but this does not work for JXTreeTables. What I mean with merging cells: I want to create a structure like this: node 1 | title for 3 cells | title for 3 cells | subnode | c1 | c2 | c3 | c1 | c2 ...
When you edit a cell in an jtable the value is made permanent only if the focus is changed or if one hits enter (for example if you change the cell value from "abc" to "xyz" and close the window the edit is lost). How do i make the edit permanent when the user stops editing? I guess we have to update the cell value as the cell value ...
In Excel, how do I write a formula that will partially delete a cell (from a certain point onwards). For example, if A1 is "23432 Vol 23432". I want B1 to just be "23432 " (everything from Vol onwards is removed). Thanks. ...
I have an HTML table structure that looks something along the lines of: PRICE QUANTITY TOTAL [5____] [2____] 10 (TOTAL1=PRICE1*QUANTITY1) The values in the price and quantity column are editable. These are HTML form fields. The values in the total column are not editable. Instead they are direct functions of the colu...
Hi folks, During my iPhone app development, I saw this curious UITableView behavior which can be seen into this posted image: http://img690.imageshack.us/i/screenone.png/ It happens after adding more cells to the table by touching in a "More" cell button at the end. I can't figure out if the problem is the table data source or not? C...
Hello could someone please help me with the following: I want to center the text in a scalc open office spreadsheet cell via Delphi and the OOoTools toolkit. The following code does not work: sRange := '$A$3:$A$3'; ooParams := CreateUnoStruct('com.sun.star.beans.PropertyValue', 1); ooParams[0].Name := 'ToPoint'; ooParams[0].Value := s...
Hello All, i have the following values in a single cell let be A1 1234 567 454 Likewise all the A(N) are filled with values. N various from 1000 to 1500 i want this to get converted as 1234;567;454 Any shortcut available? ...
Two columns: Column A contains a complete list of available journal titles; Column B contains the ones to which my library already subscribes. Is it possible to delete entries from Column A if they also appear in Column B? In other words, I want to 'dovetail' two columns so that no entry is represented in both columns. Any help will ...
Most of the views in my app are UITableVlews inside a UIViewController. My App feels like it's lagging when trying to scroll through the tables. I was wondering (1.) if it is better to create the cell objects in the table view, or create them at runtime and add them to the cells subview? examples: - (UITableViewCell *)tableView:(UITabl...
Hi, I'm actually using the crystal report provide by Visual Studio 2008. I'm developping a wpf application in c#. So, i'm making a xmldoc and provide it to my crystalreport,and everything works properly,except when i want to export to excel from the crystalreportviewer. In my report,i have many data which are numbers like float,int......
I have a line of cells (or divs): cell1 cell2 cell3 cell4 I want cell1 cell2 and cell4 to always show all their data (but also to shrink to fit), and if there is not enough room on the line, i want cell2 to clip its data in order to prevent a wrapping of the line. I also would like cell4 to align to the right of the row. cell1 c...
I need table with editable cells for my android app. Something like QTableWidget in QT. So what widget should I use? ...
I have a 45x2 cell in MATLAB, with the first column an arbitrarily sized matrix of doubles. Some of these matrices are repeated, whilst others aren't. I'm attempting to strip out only the unique matrices (but recording the number of repeates), and keep the second column as is. I've tried a number of things (tabulate, hist et al) but th...
How to check for empty cells in gridbaglayout? e.g. there are 100 cells, only 10 filled with label or pictures? ...