trim in excel

 removes multiple spaces on between words

Excel formatting to gmail

first paste in word

open vba in excel

alt-f11

still getting excel save prompt with automation

tried these 2 ideas

  object misValue = System.Reflection.Missing.Value;
                        workBook.Saved = true;
                        workBook.Close(false, misValue, misValue);

excel format codes

here

How to tell if a chosen range is in the used section of spreadsheet

this is what I did:
I unioned the existing used range with chosen range and checked for equality

if (!worksheet.UsedRange.Union(chosenrange).Equals(worksheet.UsedRange))
throw new EExcelUtilsRangeOutOfBoundsOfData();

More Excel and Dates (CSV version)

2 cases for CSV how excel picks up and formats text

top - windows culture

left - text

right- excel

excel picks up that 12/02/2012 is a date and chops of YY from the year

2012-02-14 is recognized as a date  and chops of YY from the year

15-Feb-2012-chops of YY from the year

2012/02/16 converted to default

22-12-2012 converted to default

here is more:

I have no idea why these things happen

Excel and Dates

when you enter in excel dates - if the date is in the format of the current culture then when you update the culture , the format will change.

For example if the culture is such:

and you have a s/sh such:

and then you change short format to dd-MMM-yy this will happen:

2 things happened 1) the 3rd cell changed formats 2)the 4th cell changed delimeters

even when you move the original s/sh to a different computer this is what happens

this happens with CSV also


fascinating stuff

Excel-CSV Date Issues

What happens when you save the following s/sh to csv?

The first column is formatted mm-dd-yyyy  (jan-2 ), the second dd-mm-yyyy(feb-12 )

The answer: 12-02-2011,12-02-2011

Unformattable dates in s/sh gear and excel

if you enter a value such as "123456789" in excel and format it to a date - excel cannot show it so it displays "######################". If you save to csv , excel will save "######################". spreadsheetgear will save nothing to csv.

DeletedRowInaccessibleException & linq

I was receiving this even though in the where clause I excluded deleted rows

i had to do this

//to avoid DeletedRowInaccessibleException errors AcceptChanges

            blah.AcceptChanges();

double quotes in formula

easiest method & CHAR(34) &