When you inaserrt a cell into a row,all data in that row is shifted down true or false?

Question 1

1helpful

1answer

I keep getting the message The data file 'personal folders' was not closed properly when I open Outlook, how can I prevent this from happening?

Hi,

The underlying reason why Outlook displays this "data file" check is very simple. There is a single flag in the header of the data file that is a Boolean value (True or False). While you use Outlook the value of this flag is constantly changing as the data file is updated. When the update begins the value is changed to False and then when the update completes the value is changed back to True (implying the update is finished and successful).

So, the key to the problem is the shut down process because once the Outlook.exe process is exited this flag value cannot be changed. If the Outlook.exe process was terminated prematurely or a 3rd party add-in did not properly set the flag value to True then the flag value can be left at False. If you start Outlook with a data file where the value of the flag is False you are guaranteed to see the "data file" check. If the value of the flag is True then you will not see the "data file" check.

Right now, there are a few known common causes for this issue:

- Shutting down Windows before the Outlook.exe process has exited

- 3rd party add-ins improperly "closing" the data file

- Outlook crashing

- Non-Outlook process accessing the data file

http://support.microsoft.com/kb/954642/en-us

http://support.microsoft.com/kb/948733/en-us

Regarding the post advised by Rod, I would like to explain more detailed:

+++++++++++++++++++++++++++++++++++++++++++++++++

When you shut down Outlook, the Outlook window goes away, but the Outlook.exe process can continue to run for some time. That's why you can see Outlook.exe sitting in Task Manager for a few minutes after closing the Outlook window. If you shut down Windows while the Outlook.exe process is still running Windows will not wait for the Outlook.exe process to exit. So, you increase the likelihood of encountering the "data file check" issue the next time you start Outlook (because the Outlook.exe process was not able to "close" your data file(s) completely before Windows was shut down).

On the other hand, if you leave Outlook running when you shut down Windows the Outlook.exe process will continue to run and exit on its own. When Windows is shut down, it sends messages to all visible window frames telling them to quit, and will wait for those programs to quit before shutting down. Not until all processes with open windows have exited will Windows finally shut down. This is somewhat counter-intuitive to most people as traditional training has always advised manually closing applications before shutting down Windows.

+++++++++++++++++++++++++++++++++++++++++++++++++

Mar 10, 2011 • Microsoft Computers & Internet

tip

How to export datagridview data to excel in C#

First, add this to your namespace. using Microsoft.Office.Interop.Excel; Then, copy the codes below and paste it into the export button click event. Microsoft.Office.Interop.Excel.Application wapp; Microsoft.Office.Interop.Excel.Worksheet wsheet; Microsoft.Office.Interop.Excel.Workbook wbook; wapp = new Microsoft.Office.Interop.Excel.Application(); wapp.Visible = false; wbook = wapp.Workbooks.Add(true); wsheet = (Worksheet)wbook.ActiveSheet; if (dataGridView1.RowCount == 0) { mssgbox_noretrieve(); return; } try { for (int i = 0; i < this.dataGridView1.Columns.Count; i++) { wsheet.Cells[1, i + 1] = this.dataGridView1.Columns[i].HeaderText; } for (int i = 0; i < this.dataGridView1.Rows.Count; i++) { DataGridViewRow row = this.dataGridView1.Rows[i]; for (int j = 0; j < row.Cells.Count; j++) { DataGridViewCell cell = row.Cells[j]; try { wsheet.Cells[i + 2, j + 1] = (cell.Value == null) ? "" : cell.Value.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } wapp.Visible = true; } catch (Exception ex1) { MessageBox.Show(ex1.Message); } wapp.UserControl = true; That's all and enjoy... Larrix

on Jul 09, 2011 • Computers & Internet

tip

How to datagridview to excel in C#

First, add this to your namespace.
using Microsoft.Office.Interop.Excel;

Then, copy the codes below and paste it into the export button click event.

Microsoft.Office.Interop.Excel.Application wapp;
Microsoft.Office.Interop.Excel.Worksheet wsheet;
Microsoft.Office.Interop.Excel.Workbook wbook;
wapp = new Microsoft.Office.Interop.Excel.Application();
wapp.Visible = false;
wbook = wapp.Workbooks.Add(true);
wsheet = (Worksheet)wbook.ActiveSheet;

if (dataGridView1.RowCount == 0)
{
mssgbox_noretrieve();
return;
}
try
{
for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
{
wsheet.Cells[1, i + 1] = this.dataGridView1.Columns[i].HeaderText;
}

for (int i = 0; i < this.dataGridView1.Rows.Count; i++)
{
DataGridViewRow row = this.dataGridView1.Rows[i];
for (int j = 0; j < row.Cells.Count; j++)
{
DataGridViewCell cell = row.Cells[j];
try
{
wsheet.Cells[i + 2, j + 1] = (cell.Value == null) ? "" : cell.Value.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
wapp.Visible = true;
}
catch (Exception ex1)
{
MessageBox.Show(ex1.Message);
}
wapp.UserControl = true;

That's all and enjoy...
Larrix

on Jul 09, 2011 • Computers & Internet

0helpful

1answer

Plz tell me Sir/Madam. what is Hlookup And give me example

Hi Geetad11

This is Horizontal lookup , used to look up value in a 2 dimensional table .It searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. The H in HLOOKUP stands for "Horizontal."

Formulae Syntax

HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

Lookup_value is the value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string.

Table_array is a table of information in which data is looked up. Use a reference to a range or a range name.

The values in the first row of table_array can be text, numbers, or logical values.
If range_lookup is TRUE, the values in the first row of table_array must be placed in ascending order: ...-2, -1, 0, 1, 2,... , A-Z, FALSE, TRUE; otherwise, HLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted.
Uppercase and lowercase text are equivalent.
You can put values in ascending order, left to right, by selecting the values and then clicking Sort on the Data menu. Click Options, click Sort left to right, and then click OK. Under Sort by, click the row in the list, and then click Ascending.

Row_index_num is the row number in table_array from which the matching value will be returned. A row_index_num of 1 returns the first row value in table_array, a row_index_num of 2 returns the second row value in table_array, and so on. If row_index_num is less than 1, HLOOKUP returns the #VALUE! error value; if row_index_num is greater than the number of rows on table_array, HLOOKUP returns the #REF! error value.

Range_lookup is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, HLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.

Remarks

If HLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than lookup_value.
If lookup_value is smaller than the smallest value in the first row of table_array, HLOOKUP returns the #N/A error value.

Example
The example may be easier to understand if you copy it to a blank worksheet.

Oct 06, 2010 • Microsoft Excel for PC

0helpful

1answer

Hello i want to use h LOOK UP

Hi !!

How to implement Hlookup function:

Select your data and sort it in ascending order
Then type '=HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)'.
Lookup_value is the value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string. Table_array is a table of information in which data is looked up. Use a reference to a range or a range name. The values in the first row of table_array can be text, numbers, or logical values. If range_lookup is TRUE, the values in the first row of table_array must be placed in ascending order: ...-2, -1, 0, 1, 2,... , A-Z, FALSE, TRUE; otherwise, HLOOKUP may not give the correct value.
If range_lookup is FALSE, table_array does not need to be sorted. Uppercase and lowercase text are equivalent. You can put values in ascending order, left to right, by selecting the values and then clicking Sort on the Data menu. Click Options in the sort dialog box, click Sort left to right, and then click OK. Under Sort by, click the row in the list, and then click Ascending.
Row_index_num is the row number in table_array from which the matching value will be returned. A row_index_num of 1 returns the first row value in table_array, a row_index_num of 2 returns the second row value in table_array, and so on. If row_index_num is less than 1, HLOOKUP returns the #VALUE! error value; if row_index_num is greater than the number of rows on table_array, HLOOKUP returns the #REF! error value.
Range_lookup is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, HLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.
If HLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than lookup_value.
If lookup_value is smaller than the smallest value in the first row of table_array, HLOOKUP returns the #N/A error value.
If range_lookup is FALSE and lookup_value is text, you can use the wildcard characters, question mark (?) and asterisk (*), in lookup_value. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
In the example in the Excel training video the sorted data represents the density of water at different temperatures. The left most column gives the temperature in degrees and the top column specifies the 'decimal' degrees
We looked up the density of water at 5.4 degrees celsius using the Hlookupfunction.

Still have problems, Check this video on the you tube.

Hope this would help,

Thanks,
Anurag Shukla

Sep 04, 2009 • Microsoft Excel for PC

0helpful

1answer

Change of colummn

Macro1
Sub Dist1()
'
' Dist1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+D
'
Selection.TextToColumns Destination:=ActiveCell, DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1)), _
TrailingMinusNumbers:=True
End Sub

Macro2
Sub Dist2()
'
' Dist2 Macro
'
' Keyboard Shortcut: Ctrl+Shift+M
'
Selection.Copy
ActiveCell.Offset(0, 2).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
End Sub

if have any probs pl contact me

Zulfikar Ali
[email protected]
09899780221

Mar 19, 2009 • Microsoft Office Professional 2007 Full...

0helpful

1answer

Validation code using single loop for multiple fields in javascript

As example, use it:

JavaScript Form ValidationJavaScript can be used to validate input data in HTML forms before sending off the content to a server.
Form data that typically are checked by a JavaScript could be:

has the user left required fields empty?
has the user entered a valid e-mail address?
has the user entered a valid date?
has the user entered text in a numeric field?

Required FieldsThe function below checks if a required field has been left empty. If the required field is blank, an alert box alerts a message and the function returns false. If a value is entered, the function returns true (means that data is OK):
function validate_required(field,alerttxt)
{
with (field)
{
if (value==null||value=="")
{
alert(alerttxt);return false;
}
else
{
return true;
}
}
}The entire script, with the HTML form could look something like this:
<html>
<head>
<script type="text/javascript">
function validate_required(field,alerttxt)
{
with (field)
{
if (value==null||value=="")
{alert(alerttxt);return false;}
else {return true}
}
}function validate_form(thisform)
{
with (thisform)
{
if (validate_required(email,"Email must be filled out!")==false)
{email.focus();return false;}
}
}
</script>
</head><body>
<form action="submitpage.htm"
onsubmit="return validate_form(this)"
method="post">
Email: <input type="text" name="email" size="30">
<input type="submit" value="Submit">
</form>
</body></html>
E-mail ValidationThe function below checks if the content has the general syntax of an email.
This means that the input data must contain at least an @ sign and a dot (.). Also, the @ must not be the first character of the email address, and the last dot must at least be one character after the @ sign:
function validate_email(field,alerttxt)
{
with (field)
{
apos=value.indexOf("@");
dotpos=value.lastIndexOf(".");
if (apos<1||dotpos-apos<2)
{alert(alerttxt);return false;}
else {return true;}
}
}The entire script, with the HTML form could look something like this:
<html>
<head>
<script type="text/javascript">
function validate_email(field,alerttxt)
{
with (field)
{
apos=value.indexOf("@");
dotpos=value.lastIndexOf(".");
if (apos<1||dotpos-apos<2)
{alert(alerttxt);return false;}
else {return true;}
}
}function validate_form(thisform)
{
with (thisform)
{
if (validate_email(email,"Not a valid e-mail address!")==false)
{email.focus();return false;}
}
}
</script>
</head><body>
<form action="submitpage.htm"
onsubmit="return validate_form(this);"
method="post">
Email: <input type="text" name="email" size="30">
<input type="submit" value="Submit">
</form>

P.S.: If this information was helpful, please rate this solution.
</body></html>

Mar 04, 2009 • Computers & Internet

0helpful

1answer

H look up

Hi vrusha,

Your right hlookup is very simular to vlookup, the key difference is it searches along the top row of the table, finds the matching data and gives you one of the below cells (depending on how you write the formula), just think of a vlookup on it's side.

The formula works like this:
=HLOOKUP(lookup value, table, row_index_number, range_lookup)

lookup value = is the value you want to match against the table i.e. ABBA

table = the range of cells that make up the table you want to search i.e. A1:D300

row_index_number = the number of rows from the top of the table you want to get the value from, 1 is the top of the table, 2 is directly below

range_lookup = if you want an exact match type FALSE, if you want the nearest match type TRUE

Jul 17, 2008 • Microsoft Office Professional 2007 Full...

0helpful

1answer

HELP with macro config

Hi Hss Holdings,

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table
table_to_check = the table you want to find the data from
column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.
range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here
B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)
G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)
etc

Jul 12, 2008 • Excel (SS8SATAS5128400R)

21helpful

16answers

Gears of war problem

Simple fix for forward-back movement axis inversion:

In "My Documents\My Games\Gears of *** for Windows\***Game\Config", edit the file "***Input.ini". At the very top, under the section "[Engine.PlayerInput]", change your MoveForwardSpeed to a negative number, like this:

MoveForwardSpeed=-1200

Note that I only play offline, and this setting in this file works great for me with Logitech Rumblepad 2 (although all of the other buttons are still a little off, but that I can live with). I tried every other reference to forward-backward movement and the left Y axis in this file, as well as "<installdir>\Engine\Config\BaseInput.ini" and "<installdir>\***Game\Config\DefaultInput.ini", so don't bother with those...

Dec 08, 2007 • Logitech Rumblepad 2 Game Pad

Question 2

kakima

Computers & ... Master 102,366 Answers
Posted on Feb 28, 2013

kakima

Computers & ... Master

Joined: Dec 16, 2009

Answers

102366

Questions

0

Helped

10444082

Points

622693

With most spreadsheet programs, false. Of course, the data in that row below the insertion point is usually pushed down but not the data above.

Related Topics:

Trustworthy Expert Solutions

When you inaserrt a cell into a row,all data in that row is shifted down true or false?

1 Answer

kakima

Add Your Answer

Attachments: Added items

Related Questions:

I keep getting the message The data file 'personal folders' was not closed properly when I open Outlook, how can I prevent this from happening?

How to export datagridview data to excel in C#

How to datagridview to excel in C#

Plz tell me Sir/Madam. what is Hlookup And give me example

Hello i want to use h LOOK UP

Change of colummn

Validation code using single loop for multiple fields in javascript

H look up

HELP with macro config

Gears of war problem

Not finding what you are looking for?

Computers & Internet

I keep getting the message The data file 'personal folders' was not closed properly when I open Outlook, how can I prevent this from happening?

Ask a Question

Check Out the Mobile Browsers Report

Top Computers & Internet Experts

Grand Canyon Tech

Brad Brown

Cindy Wells

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Manuals & User Guides

Encahdd2bu3zb.pdf. user-manual-Cavalry...

Fujitsu Lifebook e751.pdf....

Behringer EUROPOWER PMP3000 Powered...

Related Topics:

Trustworthy Expert Solutions

When you inaserrt a cell into a row,all data in that row is shifted down true or false?

1 Answer

kakima

Add Your Answer

Attachments: Added items

Related Questions:

I keep getting the message The data file 'personal folders' was not closed properly when I open Outlook, how can I prevent this from happening?

How to export datagridview data to excel in C#

How to datagridview to excel in C#

Plz tell me Sir/Madam. what is Hlookup And give me example

Hello i want to use h LOOK UP

Change of colummn

Validation code using single loop for multiple fields in javascript

H look up

HELP with macro config

Gears of war problem

Not finding what you are looking for?

Computers & Internet

I keep getting the message The data file 'personal folders' was not closed properly when I open Outlook, how can I prevent this from happening?

Ask a Question

Popular Questions

Change NAT to open

Vertical lines in my laptop screen BEWARE SPAM NUMBER +1-800-532-4187 BELOW

HP Pavillion dv9000 - won't power up

LG KU990 PC suite installer

Monitor goes blank less than a second after turning on.

Check Out the Mobile Browsers Report

Top Computers & Internet Experts

Grand Canyon Tech

Brad Brown

Cindy Wells

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Manuals & User Guides

Encahdd2bu3zb.pdf. user-manual-Cavalry...

Fujitsu Lifebook e751.pdf....

Behringer EUROPOWER PMP3000 Powered...