For cell K1 copy value every 30 rows down.
=IF(MOD(ROW(),30)=1,$K$1,"")
For cell K1 copy value every 30 rows down.
=IF(MOD(ROW(),30)=1,$K$1,"")
Put this into a text file called info.php and add to root of website.
<?php phpinfo(); ?>
View like coolexample.com/info.php in a Web browser.
Help to debug errors like
BackUpWordPress requires PHP version 5.3.2 or later …
The checkbox doesn’t work. Change this in the registry
HKEY_CURRENT_USER\Software\Microsoft\Exchange\Client\Options\PickLogonProfile
Reg_SZ Value should be set to 0
Problem: Android 2.3 Gmail stopped displaying any new messages in the Inbox. You could only see the messages in the All Mail label.
Solution:
Go to Settings->Applications->Manage applications
Open Gmail and “Clear data”. Don’t worry! It doesn’t drop your account and also will simply re-sync after a few minutes.
If you want to extend your range down you can do this by calculating the first 2 cells with your formula and then highlighting them. You now grap the little square on the bottom right of the highlighted area and drag that down, across or both. If you have a specific cell (e.g. D2) which you wish for to remain in all the cells you extend your range to then in your 2 initial cell calculations use the following: Exntending Down =G2*D$2 =G3*D$2 Extending Across =G2*$D2 =H2*$D2 Extending Down and Across Use $D$2
Here’s the original source.
Here’s something which worked.
… simply index the network files as a workaround.
Add a non-indexed UNC as a library
===========================
1. Create a folder on your hard drive for shares. i.e. c:\share
2. Create another folder in the above share. i.e. c:\share\music
2. Link the Library to this folder.
3. Delete the folder.
4. Use the mklink in an elevated command prompt to make a symbolic link. Name the link the same as the folder you created above.
i.e – mklink /d c:\share\music \\server\music
5. Done. Now you have non-indexed UNC path as a library.
Cecilia Zhou
But it appears to be slow.
Here’s another reference to the same topic.
DragDrop ideas
private void treeView_DragDrop(object sender, System.Windows.Forms.DragEventArgs e) { TreeNode NewNode; if(e.Data.GetDataPresent("System.Windows.Forms.TreeNode", false)) { NewNode = (TreeNode)e.Data.GetData("System.Windows.Forms.TreeNode"); if (!(sender as TreeView).Nodes.Contains(NewNode))//Edit: add this if you don't want to add the same one again. { (sender as TreeView).Nodes.Add((TreeNode) NewNode.Clone()); NewNode.Remove(); //Edit: add this if you want to remove original one. } } }
Drag and drop is used pervasively in Windows for moving or copying files. Windows Explorer fully supports drag and drop, and for many users this is the preferred method of working with files. In addition, many users are accustomed to dropping files onto an application to open them — for example, dragging and dropping a .doc file onto Microsoft Word.
In this example drag and drop is used to populate a ListBox control with a list of files dragged from Windows Explorer.
To enable drag and drop for a file
Private Sub ListBox1_DragEnter(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles ListBox1.DragEnter If e.Data.GetDataPresent(DataFormats.FileDrop) Then e.Effect = DragDropEffects.All End If End Sub Private Sub ListBox1_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles ListBox1.DragDrop If e.Data.GetDataPresent(DataFormats.FileDrop) Then Dim MyFiles() As String Dim i As Integer ' Assign the files to an array. MyFiles = e.Data.GetData(DataFormats.FileDrop) ' Loop through the array and add the files to the list. For i = 0 To MyFiles.Length - 1 ListBox1.Items.Add(MyFiles(i)) Next End If End Sub
You may notice that in the DragEnter event the Effect is set to DragDropEffects.All. Because the files themselves are not actually being moved or copied, it does not really matter whichAllowedEffects were set by the source, so specifying All means that dropping is enabled for any FileDrop.
In the above example the FileDrop format contains the full path for each file being dropped. Rather than populating a list, you could just as easily perform other operations on the files — for example, opening them in MDI (multiple-document interface) document windows.
What’s Changed from Visual Basic 6.0
Windows special folder list and CLSID identifier codes.
e.g. Open Windows Explorer directly to Favorites, change the properties like this:
%windir%\explorer.exe Shell:::{323CA680-C24D-4099-B94D-446DD2D7249E}
Also:
Windows 7 Documents:
explorer shell:DocumentsLibrary
Windows 7 Desktop:
explorer shell:Desktop
Windows 7 My Computer:
explorer shell:MyComputerFolder
PHP has upload limits. Mine is 8 GB. One idea is to use WordPress to upload a small file using the name of your large file. Then use FTP to upload the big file. Simply delete the small file and rename the large. WP now “sees” the large file.
I suspect one could reset the owner of the large file to one WP uses and that would work too (if one knew how)