Search Results

Search found 1510 results on 61 pages for 'cheat sheet'.

Page 34/61 | < Previous Page | 30 31 32 33 34 35 36 37 38 39 40 41  | Next Page >

  • Calculate time in Excel

    - by Sakthivel
    Hi friends, i have two columns in xl sheet A row have this format "8:25 PM EDT" and B row have this format "10:12:15 AM" , Now i want to add one hour to the B column if the A column contains the text "EDT" , Please help me to find out the solution Thanks in advance.

    Read the article

  • first Occurrence Of Non Blank Cell vba

    - by Madhu Kiran
    Hi, I am trying to write VBA code which works on my Excel sheet. Range("A65536").End(xlUp).Row gives me the row number of the last non blank cell. similarly i am trying to get the row number of the first non blank cell in that particular column. Thanks in advance. madhu

    Read the article

  • Detecting struckout text in a cell using JExcelApi

    - by Geo
    I need to detect whether the text within a cell is struck out or not. I'm using this: Cell cc = sheet.getCell("B1"); CellFormat format = cc.getCellFormat(); System.out.println(format.getFont().isStruckout()); but I remember I read somewhere that CellFormat is deprecated and CellFeatures should be used instead. How could one find out whether a text is struck out using CellFeatures?

    Read the article

  • What's the right tool for this job in Google Spreadsheets?

    - by Daniel Harvey
    Is it possible to nest simple programs within a Google doc spreadsheet, similar to how you would w/Basic in Excel? Or alternatively a simple = syntax using regex, if there is a way to do that in google docs? I want to take a list of multiple names(name1, name2, name3) in a single cell from across multiple identical sheets and transpose them to another sheet within the same spreadsheet, check for duplicates and ignore capitals, etc. Is there a way to do this?

    Read the article

  • how to increase the limit of exceptions in oracle

    - by Arunachalam
    how to increase the limit of exceptions in oracle ? i have a excel sheet in which their are about 900 records to be appended .so i converted the excel to dat file and wrote a batch file that read from the dat file and appends it to the concern table but the batch file stop execution once the exceptions reach 51(all integrity constrain parent key not found) so the remaining valid files are not updated .its very difficult to find which record has integrity constrain is there a way to increase this exception limit ?

    Read the article

  • pdfSharp moving items on page

    - by Azza
    Hi, I am trying to move content in a pdf document using pdfSharp. We have a number of documents that are the same size i.e. 488x320mm, the content within these documents is always positioned relative to the top right of the document but varies in size i.e. 210x330mm, 240x350mm etc. What i need to do is 'find' the content block and move it from its current position to the centre of the sheet. Please help!

    Read the article

  • Rows and Column of Excel File

    - by Mark
    It is possible to write a code that specifying the rows and column of spread sheet in terms of NUMBERS and NOT LIKE (B2:D6) Example: excelSheet.Range("B2:D6").Interior.Color = RGB(100, 100, 255) instead of B2 and D6 I want to write 5 rows and 3 column.. It is posible to write in vb.net 2003 code?

    Read the article

  • How to paste special in Excel using Applescript?

    - by Ed Taylor
    I am using Applescript to create a macro where data is transferred from several files to a single file. Data is copied with copy range the_range destination clipboard and pasted with paste worksheet active sheet destination range "A1" The problem is that most of the formatting is lost and I have not managed to get the "paste special"-syntax correct. I have downloaded "Excel2004AppleScriptRef.pdf".

    Read the article

  • Proper way to use multiple stylesheets...so it WORKS?

    - by thatryan
    I am making a site where I need to have styles separated for layout, colors and typography. So basically I took my main style sheet and just copied it 3 times, and in removed everything but coloring from one, everything but type related in another and etc. But when I link to them now there must be some cascade issue or something, because a lot of the type stuff is not being applied. Is there a proper way to do this?

    Read the article

  • SQL Replication (subsciber) can't connect to publication

    - by a3code
    I have 2 Virtual Machines, One with MS SQL server 2008 R2, other with MS SQL Server 2012 Express.... On 1 I have configuration for replication (publication), and I would like to setup Express version like subscriber. but I can't to connect to publisher SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name, 'XXXX'. (Replication.Utilities) I have tried to cheat and added XXXX server name to hosts file, but it dos't help. Additianlly I used to run http://www.hagrin.com/332/fixing-sql-server-replication-requires-actual-server-name-make-connection-server-error action for setup publication in correct way What I need to do for successful connection ?

    Read the article

  • How to give full path name in JSP programming?

    - by sujoy
    Actually when I run a particular JSP page it run perfectly(with external style sheet) but when servlet return back the control through RequestDispatcher, the page is not displaying properly means it don't took the css file path. In my program the stylesheet is present inside css directory and the page is present inside another directory named JSP. The code which include the css in the program is- <link rel="stylesheet" href="../css/stylesheet.css" type="text/css"/>

    Read the article

  • Place image over PDF

    - by Eric Acevedo
    How can I place an image over an existing PDF file at an specific coordinate location. The pdf represents a drawing sheet with one page. The image will be scaled. I'm checking ReportLab but can't find the answer. Thanks.

    Read the article

  • PHPUnit doesn't recognize file_exists()

    - by Ondrej Slinták
    I've set up a project with unit test files in NetBeans. I set bootstrap to C:\www\foo\_tests\TestAutoload.php and put simple autoload method to this file: function __autoload( $class_name ) { // series of ifs if ( ... ) { $file_name = ... } if ( file_exists ( $file_name ) ) { require_once( $file_name ); } else { echo "autoload error"; } } All of my tests fail on autoload this way. They always output just "autoload error". If I don't check if file_exists and just use require_once( $file ) no matter what's in $file, it works perfectly. Anyone encountered anything like this before? It's not something I couldn't resolve by simply not checking whether file exists or not, but I'm interested why it does this and if I can cheat it somehow.

    Read the article

  • How to Validate Pasted Dates in Excel

    - by jimdrang
    I want to validate pasted dates to remove /'s and ensure the year is 4 digits and when users paste them in it overwrites my excel validation. So, If a user pastes 05/19/10 into a cell, I would like it to convert to 05192010 or at least give an error if this is not possible. I don't know enough VB to add sheet-wide code that does this and I'm not sure if it would work when users paste multiple cells at a time.

    Read the article

  • filter items in a list view on sharepoint

    - by saravanaram
    Basically i have created a list by importing a spread sheet which contains username as one of the column. I now want to create a specific view which will show only items in the list only based on currently logged in users how do i do it. I've tried using [Me] with matching column from the imported spreadsheet but it was not working as expected.

    Read the article

  • hql query formation

    - by sarah
    Hi I want to construt a hql query like select PLAN_ID from "GPIL_DB"."ROUTE_PLAN" where ASSIGNED_TO in ('prav','sheet') and END_DATE > todays date I am doing in this way but getting an error in setting parameters s=('a','b'); Query q = getSession().createQuery("select planId from RoutePlan where assignedTo in REG "); if(selUsers != null) { q.setParameter("REG", s); } where i am doing wrong?

    Read the article

  • Dynamically add tab sheets to page control and embed a form?

    - by Jerry Dodge
    I'm working on a module which consists of a page control. By default, this page control (TPageControl) shouldn't have any tab sheets (TTabSheet), but upon initialization, it should dynamically insert these pages and embed a form inside of it. The issue comes with knowing how to insert a tab sheet into the page control. How do I create this? And once it's created, along with the forms inside each one, how do I iterate through them to destroy the forms?

    Read the article

  • Reading Excel Named Ranges by OLEDB hangs when the source file is open

    - by Sathish
    I am trying to read the Excel Named range using OLEDB using the below code "Select * from [MyNamedRange1]" everything works fine only when the source excel sheet is not opened if it is open then i am not able to read the range names using OLEDB it simply hangs Where as i am able to execute the query "Select * from [Sheet1$]" even if the workbook is open or closed... Any work arounds for reading the range by OLEDB only i dont want to go for interop... I have too many ranges defined in the excel file

    Read the article

  • Good JavaScript engine for animating via Sprite Sheets (not in canvas)

    - by N. Taylor Mullen
    I've looked around a bit for a great JavaScript Sprite Sheet animator lib/engine but couldn't find any good ones so I thought I'd ask around =). What I'm looking for in the engine is: Animate an image in a non-canvas setting (ex: div via css or img tags) Control frame rate/animation speed Flags to loop or to animate once etc. Are there any engines like this out there? If not I can always make my own but then again, I don't want to re-invent the wheel =].

    Read the article

< Previous Page | 30 31 32 33 34 35 36 37 38 39 40 41  | Next Page >